This should be an easy one for someone ...

[Stefan]

Hi,

Can someone please tell me what is wrong with the following Kode... I have
tried everything ...

upKey is a variable with a value of 1 (int)... Why in the world does it keep
telling me invalid column...




KODE:
------------
SqlCommand command = new SqlCommand("UPDATE Table SET Column=stringvariable
WHERE column=upKey",myConn);


command.ExecuteNonQuery();


ERROR:
-----------------------
Invalid column name 'upKey'.

Source Error:


Line 275: SqlCommand command = new SqlCommand("UPDATE Table SET
Column='stringVariable' WHERE Column=upKey",myConn);
Line 276:
Line 277: command.ExecuteNonQuery();

 

[William Gower]

If upKey is a character field

Where column = '" & upKey & "'"

 

[Stefan]

Thanks William.... That worked ...

If upKey is a character field

Where column = '" & upKey & "'"