Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Evaluate AND PreserveSingleQuotes?

Status
Not open for further replies.

bobbyr

Programmer
Nov 30, 2000
66
US
Is it possible to do an Evaluate(mytext) AND a PreserveSingleQuotes(mytext) at the same time? I know with ASP I could just nest them like PreserveSingleQuote(Evaluate(mytext)), but it doesn't seem to work in CFML.
 
preservesinglequotes has to be used only in sql statements
so i guess you can first <cfset a_variable=evaluate(&quot;#your_text#&quot;)> and then do a cfquery, in which you have :
select ... from ... where anything=(#preservesinglequotes(a_variable)#)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top