Easy Date Handling
I'm working on a system that requires alot of date handling, and i'm getting pretty tired of doing custom calculating when modifying dates, so i hope someone would be able to help me. Is there any easy way to do re-calculating of dates? such as adding 2,11
or 36 months to a date, and have it automatically checking whether or not it should increase months or year, and by how much?
Like, if i have to add 11 months to the date right now, i have to check which month it's in to see whether or not i could just take one month lesser the next year and so on.
View Replies
ADVERTISEMENT
<% Response.Write "" & FormatDateTime(now,2) & "" %>
Gives me the date in MM/DD/YYYY. How can I reformat this to DD/MM/YYYY?
View Replies
View Related
I have a variable that represents a standard mm/dd/yyyy date , but i want to change it to just October 6
''''
datepart("m","d" , mydatevariable)
'''''
....doesnt work.
View Replies
View Related
I’m trying to write a script that will select some records from an Access database within a certain date range one of the fields is a date. Code:
View Replies
View Related
I need to do a string comparison (in asp) that checks to see if "META" is contained somewhere/anywhere in the string. Can anyone tell me the syntax for doing this?
View Replies
View Related
I'm hoping for an easy solution to this that I'm not seeing that
someone more experienced will.
All I want to do it mark an option tag as selected....
<%
hourCounter = 1
Do WHILE hourCounter <= 12 %>
<option value="<%=hourCounter%>" <%If hourCounter =
hour(rsCalendarEdit("fld_calendar_DateTime")) Then Response.write "
selected" End If %>><%=hourCounter%></option>
<% hourCounter = hourCounter + 1
Loop
%>
The trouble is if the time is "PM" I have a problem as you can see. Is
there a method or property here I can implement that I'm not seeing?
View Replies
View Related
why asp is retarded compared to some other server side scripting languages? or am i just the retard? Code:
<% If Session("auth") = "1" And Session("userid") <> "" Then %>
// Show user information box....
<% Else %>
// Show login form....
<% End If %>
in my head, what i just wrote should equal something like if the session variable "auth" equals 1 and the session variable "userid" does not equal nothing, then do this.well, i haven't set any session variables, and it's processing the chunk of code right after the above if/then. either shows a user information box or a login form.it shows the user information box, instead of the form.
really baffles me considering i haven't set any session variables. i guess this is why i like php better, but i'm trying to get a grasp on asp, it just seems to hard to do something simple. can anyone tell me why that code is returning the wrong block of code?
View Replies
View Related
Using ASP & Access. So I am having a total brain-fade. I am trying to pull up data out of a table. But I want a "select all" option. What should the value be for the "select all" option of the form? What should the WHERE statement be in the query?
View Replies
View Related
<%= objrs ("age"), 2)%>????
how do i get it to only display the first 2 numbers?
View Replies
View Related
I am having trouble with our server host they are saying that the php
upload limit is 20 mbs but using the code below with my flash file I
can only get it to do 8mbs. I know that asp is allowing for up to
20mbs though so I was hoping that someone would be able to change this
code to ASP(I am not very good at either php or asp). I think that
should be pretty easy:
<?php
if (is_uploaded_file($_FILES['Filedata']['tmp_name'])) {
$uploadDirectory = "uploads/";
$uploadFile = $uploadDirectory .
basename($_FILES['Filedata']['name']);
copy($_FILES['Filedata']['tmp_name'], $uploadFile);
}
?>
View Replies
View Related
I am just trying to take pieces out of the sql statement individually and display them. I get this error:
ADODB.Recordset (0x800A0CC1)
Item cannot be found in the collection corresponding to the requested name or ordinal
There is data there in the table and I'm not sure what's going on. Code:
View Replies
View Related
Im making an asp website for a rotary club what would be the best script to create a website something like a CMS without all the forums and stuff.
View Replies
View Related
What is the easiest way to create a graph in either asp or html code? Is there one? I am doing several SQL queries the result of which I will give me a number. I need to put this number into some kind of graph (bar graph) on the page. THe number will vary so it must be some type of dynamicly created graph.
I would prefer to not use a thrid party tool to do this if possible ......
View Replies
View Related
Basicly I have a table that gets contact info and stores it from a form AND emails me...
Problem is I want to just email a link to the ContactInfo.. which should be referenced via the unique PK so whwn i view it, it would be nice to reference the row just inserted...
ala view.asp?emailpk=141
figured there woudl be something like recaffected out there.
View Replies
View Related
I need to write an application which should work as web application (ASP.NET) and it should have its counterpart for winforms - (they would do the same thing). My question is... what kind of pattern shall I use (MVP or MVC) for writing these apps to minimize overhead of rewriting code (e.g. I'll start writing winform app and then create similar web app )?
View Replies
View Related
I've searched the forum for the answer to this..it's probably on here somewhere but in a different guise to my particular question and I don't know enough to figure it out.
If I have a basic form to mail ie
strEmail = request.form("Email")
and
mail = "me@me.com"
can I simply do this to get my form to be sent to 2 email addresses?
mail = "me@me.com, you@me.com"
View Replies
View Related
I have a "tell a friend" form and the backend sends the information just fine, however in the bodytext I want the "comments" box text to be added to the e-mail. User fills in his name, his email, friends email, comments box (name=message) and the email is sent except the text from the comments box. My code for the body tag is:
objNewMail.Body = sendersName & " (mailto:" & sendersEmail & ") thought you would be interested in this article " & vbcrlf & vbcrlf & vbcrlf & "Link:" & vbcrlf & request.ServerVariables("HTTP_REFERER")
How can I insert the comments box text in there?
My thought was:
objNewMail.Body = sendersName & " (mailto:" & sendersEmail & ") thought you would be interested in this article " & vbcrlf & vbcrlf & message & "Link:" & vbcrlf & request.ServerVariables("HTTP_REFERER") but it does not work.
View Replies
View Related
I have several pages ( ASP) that were working OK on NT4. We moved it to Server 2003. At random , it appears that the Server.CreateObject fails.
I've looked through the code and it looks OK. Is there an easy way to make sure I have Closed all CONNECTIONS RecordSets etc.
View Replies
View Related
The database is used for referencing filename, there located folder, id, order shown, but also there are some fields say "location_1" up to "location_4" which have a 0 , 1 or 2 in them. 0 means that file not needed for that section. 1 means needed for that section, and 2 means mandantory (must be seen before exit).
firstly selecting a location from a html radio box, drop down menu (not decided yet) will return whats needed so not showing pages what aint needed and wasting time.
Here it is though in order on the left i wish it to build a menu, but more advanced than plain links would be good. drop down like windows explorer etc. Code:
View Replies
View Related
i would like to create the following one, but nor I know as. One index.asp that db catches one information as heading, hour of entrance and station time and shows in the page index. An example, let us assume that now they are 23:00, then the shown information will be inserted in the page index.asp in accordance with the current hour.
If it will have something registered in cadastre in db that it starts the 23:00 and it finishes the 01:00 will be in index, passing the hour it leaves and it enters another message with programmed hour.
If I have in db a message that would have to be shown of the 09:00 the 11:30, and now I am 11:20, the system analyze and show the information, until he is 11:31, when then I enter another one, and thus successively, they are menmsagens that in accordance with enter the hour of the server.
View Replies
View Related
i'm looking for a easy to setup web chat script that i can install on IIS? if someone can point me in the right direction it woudl be great, i download a couple cgi scripts but couldn't get them to load.
View Replies
View Related
I have several pages ( ASP) that were working OK on NT4.
We moved it to Server 2003. At random , it appears that the
Server.CreateObject fails.
I've looked through the code and it looks OK.
Is there an easy way to make sure I have Closed all
CONNECTIONS
RecordSets
etc.
View Replies
View Related
I am adding simple records to a fairly simple access database with the following code
rsEntry.Fields("Player1") = ShortName(Player1)
rsEntry.Fields("Player2") = ShortName(Player2)
'Write the updated recordset to the database
rsEntry.Update
rsEntry.Close
adoCon.Close
Set rsEntry = Nothing
Set adoCon = Nothing
How can I SIMPLY :-) prevent duplicate records from being added? I know I can set the index property on the fields but that mean handling the errors - not sure how to do this.
OR I could write the code to seach the DB before update - which may be the only way :-(
Is there a simple way?
View Replies
View Related
I am developing a simple booking system where I had a booking date. The problem is I want to make sure that the user must book 3 days in advanced for certain room.
I have tried to use DateDiff but it seems doesn't work. Actually i just 1 to make sure that the user must book 3 days in advanced from the current date. I am wondering whether there is anything goes wrong in my datediff function. Code:
View Replies
View Related
I have been trying to find a script on the net that would allow me to handle directory listings through ASP. I'm basically looking to change the default generated pages when browsing directories. Eventually I would love to be able to change which directories/files show based on permissions and be able to allow uploads to current directory listings.
View Replies
View Related
I am attempting to use url's on a database driven webpage - the url's are really ugly (created by mapquest) - I have tried to put " quotes " around the urls in the database as well as without - but all i get is a blank about page, can anyone help.
Here is my code:
<td><a href="<%Response.Write(rs("Directions"))%>" target="_blank">Directions</a></td>
View Replies
View Related
How do i do error handling using asp. Like taking an example i am getting this error on trying to save a record twice whihc has a primary key constraint:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again.
how can i handle such cases and where do i place the code???
View Replies
View Related
I have a piece of code which causes an exception. Now i don't know why that is. I would like to know the best way to debug the exception.
I know about try and catch statements. However with these you need to have a basic idea of the type of exceptions that could occur. Does someone have a better suggestion on how to debug an exception?
View Replies
View Related
sql = "SELECT * FROM Calls WHERE Date BETWEEN " &startdate& " AND " &enddate
Where did I go wrong?????????????
Ugly response:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
View Replies
View Related
I want to error handling in ASP. But i think that ASP is not enough for
error handling. I have got two chance.
1. I can prapare an error page and control throught IIS.
2. I can use on error resume next.
For 1. This is a general handling. I want to handle local error. Maybe i do
special thing when error occured.
For 2. I have to write alot of lines code. I have to control every line.
View Replies
View Related
if I have two strings as follows :
"1,3,45,65,777,89,00
and
"8,9,67,54,89,23
The numbers represent a predefined access permission to a certain file.
I need a function to sift through the first string, and compare it to the second string. What numbers are located in the second string, which are are located in the first string need to be removed (from the second string) leaving only unmatched numbers beind.
View Replies
View Related
how use the array handling in asp
View Replies
View Related
Is there a possiblity that, when an error comes in asp page in server, especially with sql script, to hide that error from user and display just Error, report to admin,
i just want to make a general case where when an error comes i should take the page to report to admin.
View Replies
View Related
