Aseem,
this is probably form a poorly-formed SQL statement. Get your application to
output <@SQL> on the error page of Insert_Reg, then build a new query
inside MSAccess, go to SQL VIEW and paste in your SQL statement (you may
have to replace some of the ? with actual values). Access will probably give you
a clearer idea about what's wrong with your insert. I suspect it has something
to do with how you're formattign the datetime fields (see bold
below).
| [Query] | INSERT INTO Registration(FName,MI,LName,Address1,Address2,City,State,Zip,PhoneArea,PhonePrefix,PhoneSuffix,W_PhoneArea,W_PhonePrefix,W_PhoneSuffix,DOB,Email,BillingFName,BillingMI,BillingLName,BillingAddress1,BillingAddress2,BillingCity,BillingState,BillingZip,Creation_Date,Created_By) VALUES ('Aseem','','Mal',?,'','SANTA MONICA','CA','90401','310','998','2648','310','998','2648',{ ts '1959-03-08 00:00:00' },?,'Aseem','','Mal',?,'','SANTA MONICA','CA','90401',{ ts '2000-13-00 00:00:00' },'') | |
| [BoundVals] | [v1='1250,'; v2='[EMAIL PROTECTED]'; v3='1250,'] | |
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Aseem Mal
Sent: Tuesday, August 13, 2002 3:12 PM
To: Multiple recipients of list witango-talk
Subject: Witango-Talk: Help Help. Tango getting funny.Please Help. Go to:
http://new.milkeninstitute.org/store/registration.taf?_function=newuser
Hi. Anyone please try the "Register" link on the above page. I am getting this strange error. The debug-info is pasted below:
