var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Override SQL character
I'm trying to search for all records that contain a quotation character in the database. These records were migrated from a mainframe system.
I use the following command:
The results are:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Unclosed quotation mark before the character string ' order by cliLastName, cliFirstName, cliBirthName'.
/ladds/lib/getrecordset.asp, line 6
Is there a way to override the quotation character temporarily?
You just have to escape the character. Use this:
That is, two single quotes, and not a double quote.
Thanks ... worked like a charm!