ODBiC Discussion Board

trying to updated field

by John Thompson, April 18, 2007 21:43

I have this sql statement that works fine in MS Access, but returns "DATABASE ERROR: 07001 [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1." When I run it in ODBScript

<!--UPDATE plog SET plog.InvoiceIDNum = Left([AddressInvoice],InStr(1,[AddressInvoice],",")-1)-->

Inside the address field is also the order number, example:

123456, 2345 Circle Street, Chino, CA, 89675 (This is all in ONE field upon initial import)

I want to get just the value before the first comma (the actual order number) and insert it into a new field. Again it works in access just fine. Am I missing something?

Thanks, John


Post Your Reply:

E-mail  optional

HTTP Link: 
Link text: 


Copyright ©1997-2003, Roger Harris. All rights reserved.