|
| |
|
|
malky800
Posts: 116
Joined: 1/11/2006
Status: offline
 |
RE: Calling a date - 2/14/2006 16:22:40
My html page response was as follows but nothing went into the database.
INSERT INTO Table1 (name1, email, question, [date]) VALUES ('Test','Test@testdomain.com','My
Question',#01/01/2001#)
|
|
|
|
rdouglass
Posts: 9280
From: Biddeford, ME USA
Status: offline
|
RE: Calling a date - 2/14/2006 16:25:57
quote:
My html page response was as follows but nothing went into the database.
Yes, we stopped it with a Response.end - now let's try to build the query one piece at a time. Try this one next:
query="INSERT INTO Table1 (name1) VALUES ('" & name1 &"')"
If that works, continue adding fields until we find one that fails.
_____________________________
Don't take you're eye off your final destination.
ASP Checkbox Function Tutorial.
| |
|
|
|
malky800
Posts: 116
Joined: 1/11/2006
Status: offline
|
RE: Calling a date - 2/14/2006 16:40:18
All up to here works perfectly.
query="INSERT INTO Table1 (name1,email,question) VALUES ('" & name1 & "','" & email & "','" & question & "')"
This doesn't work anymore
query="INSERT INTO Table1 (name1,email,question,date) VALUES ('" & name1 & "','" & email & "','" & question & "','" & now() & "')"
Remind me how to put the date in properly.
| |
|
|
|
malky800
Posts: 116
Joined: 1/11/2006
Status: offline
|
RE: Calling a date - 2/15/2006 9:30:30
WoW! i don't know why, but now it worked!
Thank you everyone for your time and effort in helping me!
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
k¥ 