Another easy one... I guess for you guys... 1

[Ayac]

Hi All,

It is probably a very dummy question, but I just started Cold Fusion, anyways, so how come this:

<cfset strQuery = "SELECT * FROM members WHERE FIRST_NAME LIKE 'Smith%' AND LICENSE_STATUS IS NOT NULL ORDER BY SORT_FIELD">
<CFQUERY NAME="SearchList" DATASOURCE="iMIS_Members">
#strQuery#
</CFQUERY>

does not work, but this does:

<CFQUERY NAME="SearchList" DATASOURCE="iMIS_Members">
SELECT * FROM members WHERE FIRST_NAME LIKE 'Smith%' AND LICENSE_STATUS IS NOT NULL ORDER BY SORT_FIELD
</CFQUERY>

The first one gives me an ODBC error, however it looks identical to me to the other.

Any ideas?

 

[webmigit]

<CFQUERY NAME="SearchList" DATASOURCE="iMIS_Members">
#preservesinglequotes(strQuery)#
</CFQUERY>

Preservesinglequotes is the function you want for that

http://livedocs.macromedia.com/coldfusion/6/CFML_Reference/functions-pt252.htm

ALFII.com

http://www.alfii.com

---------------------
If this post answered or helped to answer your question, please reply with such so that forum members with a similar question will know to use this advice.

 

[Ayac]

Awesome! Thank you!!!