I have retrieved a date from a form and the
Request.form("D OB") gives me the format of: 12/04/1976.
When I try to use SQL to add the record to the database, I get the error below.
Microsoft OLE DB Provider for SQL Server error '80004005'
Arithmetic overflow error converting expression to data type datetime.
The code generating the error is below:
oRs.Open "MailList",...
dsmith76
Last Activity: Feb 16 '16, 10:26 PM
Joined: Dec 9 '11
Location:
-
How to format a date from a form for SQL server
-
Problem returning values from a function written in vbscript
When I use this code, it works fine:
<% Function RandomNumber(in tHighestNumber)
Randomize
RandomNumber = Int(Rnd * intHighestNumbe r) + 1
End Function
SEEDNMBR=(Rando mNumber(16))
Response.Write SEEDNMBR %>
However, with the code below I get this error code:Microsoft VBScript compilation error '800a03ea'
Syntax error
/seed_modify_bat ch.asp, line 20
Function RandomNumber(in tHighestNumber)... -
How does one do the reverse of a union query?
I have a maillist table which contains usernames of my entire membership list. Another table (Registry) has username as a foreign key. I am doing a checkbox form that reads from an SQL Server database and I don't want to have names on the checkbox list which are already included in the Registry table, because these people have already registered. Here is my current code:
...Code:SQL = "SELECT maillist.MAILID as maillist_mailid,maillist.L_NAME,maillist.F_NAME,
-
Thanks, thought I tried it without the quotes, but I guess not.
Another question, I am doing my login process for username and password using a form and then validating the info via the database running on sql server. I have read that I should not rely solely on cookies because some people disable them. With most browsers set to "autofill" are cookies becoming obsolete? Are they more for the benefit of the programmer, since they require... -
Error when writing cookies
I am getting the error: Type mismatch:'Expir es'
Microsoft VBScript runtime error '800a000d'
on this code:
mailid and local_number are variable that are read from a form.
<%response.cook ies("login")("m ailid")=mailid %>
<%response.cook ies("login")("l ocal_number")=l ocal_number %>
<%response.cook ies("login").Ex pires="Date + 7"...
No activity results to display
Leave a comment: