I'm trying to insert a bunch of data into a database. I'm not sure why, but it's not updating (writing). Any help is truly appreciated.


Set rsInsertRequest = Server.CreateObject("ADODB.Recordset")
objRS.ActiveConnection = MM_spgsconn_STRING

sql = "INSERT INTO PaymentHistory (" & _
"ClientID, UserID, ClientName, Name, Address, City, State, Zip, TimeStamp, Receipt, " & _
"CreditCardType, CreditCardNumber, ExpirationDate, Comment, Reference, Reference2, " & _
"Reference3, Reference4, Reference5, Amount, Fee, GrandTotal, OrderNumber, Type) " & _
"value(" & lngClientID & ", " & lngUserID & ", '" & strShortName & "', '" & varcardname & "', '" & _
varaddress1 & "', '" & varcityname & "', '" & varpostalcd & "', '" & varstatecd & "', '" & _
Now() & "', '" & strResponseReferenceNum & "', '" & varcardtype & ", '" & varcardlastfour & _
"', '" & varexpdate & "', '" & varclientref2 & " for " & varclientref3 & "', " & _
varclientref1 & "', '" & varclientref2 & "', '" & "', '" & varclientref3 & "', '" & _
varclientref4 & "', '" & varclientref5 & "') "

objrs.Open

sql=""

What is your error and what DB are you inserting into? (this will help others help you)

What I can see strait away:
a..The number of fields you are inserting into does not match the number of values you have - this must match!

To resolve:
1..Ensure you have friendly errors turned off in your advanced browser settings.

2..Run and execute the statement, post the exact error

3..Run the statement and response.write the sql to the browser (but not exectue) post the sql in your next post - this way we can see the values you are attempting to insert.

FYI: the error usually tells you exactly what the problem is

Or you can strip the sql back and execute (lets say your first three fields) then add a couple and run, another couple then run... when you error out you have found your problematic value.

Wind is your friend
Matt