In the debug info Look at the line: [v1='1250,'; v2='[EMAIL PROTECTED]'; v3='1250,']
Just below the insert statement. The "?" are substituted by v1, v2 etc. The problem is something else. -----Original Message----- From: Troy Sosamon [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 13, 2002 12:51 PM To: Multiple recipients of list witango-talk Subject: RE: Witango-Talk: Help Help. Tango getting funny. [Query] INSERT INTO Registration (FName,MI,LName,Address1,Address2,City,State,Zip,PhoneArea,PhonePrefix,P hone Suffix,W_PhoneArea,W_PhonePrefix,W_PhoneSuffix,DOB,Email,BillingFName,Bi llin gMI,BillingLName,BillingAddress1,BillingAddress2,BillingCity,BillingStat e,Bi llingZip,Creation_Date,Created_By) VALUES ('Troy','','test',?,'','test','co','80202','111','222','333','222','333' ,'44 4',{ ts '1994-02-01 00:00:00' },?,'Troy','','test',?,'','test','co','80202',{ ts '2000-13-00 00:00:00' },'') [ You have a problem with the address1 and 2 fields. I entered address info in the form and it is not in the insert command. There is a ? and ''. Troy Sosamon ----------- Original Message --------------- 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: Error An error occurred while processing your request: File: registration.taf Position: Insert_Reg Class: DBMS Main Error Number: -3100 [Microsoft][ODBC Microsoft Access Driver] Reserved error (|); there is no message for this error. 37000 File: registration.taf Position: Insert_Reg Class: Internal Main Error Number: -101 General error during data source operation. ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
