INSERT from ASP to Access crashes

[RichCrider]

Can anyone tell me why this isn't working?

cid, uid, u, d, and s are numbers
sd, ed are dates
c is text

Thanks!

myC = "INSERT INTO tbl_requests(req_client, req_user, req_unit_id,
req_cat_id, req_shift_id, req_start, req_end, req_sp_req,
req_submitted, req_status) VALUES" & "(" & cid & ", " & uid & ", " &
u & ", " & d & ", " & s & ", #" & sd & "#, #" & ed & "#, '" & c &
"', #" & now() & "#, " & 1 & ")"

conn.execute myc

[Bob Barrows [MVP]]

RichCrider wrote:

Can anyone tell me why this isn't working?

cid, uid, u, d, and s are numbers
sd, ed are dates
c is text

The datatypes of the variables are not really relevant. It is the datatypes
of the table columns that we need to hear about.
Thanks!

myC = "INSERT INTO tbl_requests(req_client, req_user, req_unit_id,
req_cat_id, req_shift_id, req_start, req_end, req_sp_req,
req_submitted, req_status) VALUES" & "(" & cid & ", " & uid & ", " &
u & ", " & d & ", " & s & ", #" & sd & "#, #" & ed & "#, '" & c &
"', #" & now() & "#, " & 1 & ")"

conn.execute myc

Show us the result of

response.write myc

Bob Barrows

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[Bob Barrows [MVP]]

RichCrider wrote:

Can anyone tell me why this isn't working?

Also, tell us what you mean by "isn't working". We aren't looking over your
shoulder. Are you getting error messages? Incorrect results?

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[Rich Crider]

the data types of the columns are numbers, dates and text as listed
above (I listed variable names, not column names in my earlier post.)

If I try to execute it from the ASP page, I get:
"There is a problem with the page you are trying to reach and it cannot
be displayed." Everything on the page except insert and execute works
correctly.

Response.write returns the following:
INSERT INTO tbl_requests(req_client, req_user, req_unit_id, req_cat_id,
req_shift_id, req_start, req_end, req_sp_req, req_submitted, req_status)
VALUES(1, 1, 1, 1, 1, #1/1/2004#, #1/5/2004#, 'Comments', #3/24/2004
12:47:37 PM#, 1)
thanks for your help!

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!