Problems with mediumtext in update statement

[webIntern]

I have a web page that updates records in a mySQL database. I'm having trouble updating the fields that are of "mediumtext" type. When I'm updating that field using ASP/vbscript, the value is a string. I get the following error on the page:

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[MySQL][ODBC 3.51 Driver][mysqld-4.0.14-nt]You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'desc='testing solution testing testing', challenge='testing te

My sql update string looks like this:
sSqlString = "UPDATE casestudy SET sector=" & ssector & ", client=" & sclient & ", solution=" & ssolution & ", desc=" & sdesc & ", challenge=" & schallenge & ", result=" & sresult & " WHERE num = " & number

OH and the string variables all already have single quotes around the the values.

Can someone help me...please...thanks in advance

 

[sleipnir214]

Actually, your update string does not look like:

sSqlString = "UPDATE casestudy SET sector=" & ssector & ", client=" & sclient & ", solution=" & ssolution & ", desc=" & sdesc & ", challenge=" & schallenge & ", result=" & sresult & " WHERE num = " & number

That's just the code that creates it.

I recommend as a first step that you output the created query to the browser and examine it.


Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[swampBoogie]

Don't use desc as a column name, it's a reserved word in SQL.

 

[webIntern]

You're right, it was because 'desc' is a reserved word. I changed the name of the field in the database and updated that change in my code. Everything works now.

Thanks!!!