Update statement problems

[Fary4u]

Hi,

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:

ors.open "Select * from products where productname='"&request("txtname")&"'",ocon1,Adopendynamic,Adlockoptimistic
 

there is no problem to update statement but when i use with primarykey & it's automatic number using the following code then : (

ors.open "Select * from products where productID='"&request("txtids")&"'",ocon1,Adopendynamic,Adlockoptimistic
 

Microsoft JET Database Engine (0x80040E07)
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 )

[Stewart Ross]

Hi. Remove the single quotes before and after ProductID in the WHERE clause of your SQL string. You are treating the long-integer autonumber value as a string, causing a type mismatch error on trying to open the recordset filtered to a specific value.

ors.open "Select * from products where productID = " & request ("txtids"), ocon1, Adopendynamic, Adlockoptimistic

-Stewart

ps I have moved your post from our Insights area - which is an articles section - to the answers section where it belongs.