UPDATE statment

[chenko]

Im using the update statment to change some values in my DB

SQLupdate = "UPDATE FILE_ID (ID1, ID2, ID3) VALUES (42, 34, 34)"
 
CN.Execute SQLupdate

My question is how do I select which record to update? I already have a recordset open at the record I want with this...

Set rsFiles = Server.CreateObject("ADODB.Recordset")
rsFiles.Open "SELECT * FROM FILE_ID WHERE ID1=23" , CN, 3, 3

[kayoca]

This is how you can use the UPDATE statement.

UPDATE MyTable SET MyInt=(1), MyStr=('mystr') WHERE MyID=1;

[chenko]

Would mine be ok if I just added "WHERE ID=23" on the end

[chenko]

"UPDATE FILE_ID (" & _
		"ID1, ID2, ID3" & _
		") VALUES (" & _
		"32, 43, 54" & _ 
		") WHERE ID1=23"

Whats wrong with this, I get a error....

Microsoft JET Database Engine error '80040e14'

Syntax error in UPDATE statement.

/simon/asp/sub.asp, line 89

[vb_dba]

That syntax is for an Insert statement, try changing to this:

"UPDATE FILE_ID Set ID1 = 32, ID2 = 43, ID3 = 54 " & _
"WHERE ID1=23"

Regards,

Chris

[chenko]

ah cheers


I used this anyway

SQL = "UPDATE FILE_ID Set ID1 = 32 WHERE ID1=23"
CN.execute SQL
SQL = "UPDATE FILE_ID Set ID1 = 32 WHERE ID2=32"
CN.execute SQL