SQL UPDATE cant use characters for update the table column?

[lazzypink]

query = "UPDATE Camera SET CameraName=" + CameraName + " WHERE CameraName=" + oldIPCamera.Cam eraName;

hi guys! can help me solve this problem? why i cant update the new camera name (camera_3) for replace the old camera name (camera_7)? there is an error "invalid column name camera_7" or is there have any others method to do this? thanks!

[amitpatel66]

query = "UPDATE Camera SET CameraName=" + CameraName + " WHERE CameraName=" + oldIPCamera.Cam eraName;

hi guys! can help me solve this problem? why i cant update the new camera name (camera_3) for replace the old camera name (camera_7)? there is an error "invalid column name camera_7" or is there have any others method to do this? thanks!

What is this value oldIPCamera.Cam eraName?
Is it a column from a table oldIPCamera or its a variable createed in your source code??

[lazzypink]

What is this value oldIPCamera.Cam eraName?
Is it a column from a table oldIPCamera or its a variable createed in your source code??

oldIPCamera.Cam eraName is a variable created in my source code. do u have any idea?...thanks!

[amitpatel66]

oldIPCamera.Cam eraName is a variable created in my source code. do u have any idea?...thanks!

The problem in your update statement is that you are not enclosing the values camera_7 and the other one in a single quotes. Try something like this:

query = "UPDATE Camera SET CameraName= '" + CameraName + "' WHERE CameraName='" + oldIPCamera.CameraName + "'";

[lazzypink]

The problem in your update statement is that you are not enclosing the values camera_7 and the other one in a single quotes. Try something like this:

query = "UPDATE Camera SET CameraName= '" + CameraName + "' WHERE CameraName='" + oldIPCamera.CameraName + "'";

Yup! you are correct, i got what i want. thanks pal..

[amitpatel66]

Yup! you are correct, i got what i want. thanks pal..

You are welcome. Do post back in case of any further issues