I'm attempting to update a record via the recordset.update method, However, the recordset object is defined and accesses the correct record that I want to update, as I can retrieve field values from the record.
The open string for the recordset that I'm using should allow changes:
Expand|Select|Wrap|Line Numbers
- ors.open "Select * from products where productname='"&request("txtname")&"'",ocon1,Adopendynamic,Adlockoptimistic
Expand|Select|Wrap|Line Numbers
- ors.open "Select * from products where productID='"&request("txtids")&"'",ocon1,Adopendynamic,Adlockoptimistic
Syntax error in date in query expression 'productID="89"
Is there some other "object" that needs to be defined to allow changes to the record, or something else that I am missing that causes this update to fail?
thanks 4 u reply ( Fary )