macromedia.coldfusion.database_access
[Top] [All Lists]
<prev [Date] next>
Google
 
<prev [Thread] next>

Re: MS SQL - Syntax error for valid query

from [AWFrueh1808]
Subject: Re: MS SQL - Syntax error for valid query
From: "AWFrueh1808" <webforumsuser@xxxxxxxxxxxxxx>
Date: Tue, 29 Jan 2008 20:05:15 +0000 (UTC)
Newsgroups: macromedia.coldfusion.database_access 

Gotcha.  So the single quotes are indeed only escaped as part of a SQL 
statement (or more accurately, as part of a CFQUERY.  When you CFOUTPUT the 
same variable, the quotes will not be escaped?
[More with this subject...]
<Prev in Thread] Current Thread [Next in Thread>
Previous by Date:  can not update MS-Acess 2000 db; currently locked, steppoff-donegal
Next by Date:  Re: MS SQL - Syntax error for valid query, Ian Skinner
Previous by Thread:  Re: MS SQL - Syntax error for valid query, Ian Skinner
Next by Thread:  Re: MS SQL - Syntax error for valid query, Ian Skinner
Indexes:  [Date] [Thread] [Top] [All Lists]