Problems with the ' symbol..
I have a database query where it looks like this
strQuery = "UPDATE resource SET TITLE = ' "&request.form("TITLE")&" ' WHERE
ID = '"&request.form("ID")&"';"
the problem is that if the field called title has a ' in the text then the
UPDATE fails, because I have closed the TITLE field early. If I reverse the
" & ' marks then I will have the same problem but the opposite way.....
I thought about doing something with ASP, replace but I still cant get round
the fact that I will have a ' in the UPDATE statement..
Can I do something like REPLACE ' with the CHAR code value and add the code
in the SQL record, and will this display the ' or the code.
|All times are GMT. The time now is 02:22 AM.|
Powered by vBulletin®. Copyright ©2000 - 2013, vBulletin Solutions, Inc.
SEO by vBSEO ©2010, Crawlability, Inc.