MS SQL - Syntax error for valid query

i have problem second query in code (gives me syntax error in having line)

<cfquery name="getdupes" datasource="#application.odbc1#" dbtype="odbc" username="#application.usernameodbc1#" password="#application.userpassodbc1#">
select *
from view_formcount
where formcount >= 2
order formnum
</cfquery>

<cfset variables.lstforms = "">

<cfoutput query="getdupes">
<cfset variables.lstforms= listappend(variables.lstforms,"'#getdupes.formnum#'")>
</cfoutput>

<cfset variables.whereclause = "(formnum = #replacenocase(variables.lstforms,',',' or formnum = ','all')#)">

<cfquery name="getdetails" datasource="#application.odbc1#" dbtype="odbc" username="#application.usernameodbc1#" password="#application.userpassodbc1#">
select tblforms.formnum, tblforms.formname, tblforms.formcustnum, tblcompanies.companyabbr
from tblforms inner join tblcompanies on tblforms.formcustnum = tblcompanies.companynum
group tblforms.formnum, tblforms.formname, tblforms.formcustnum, tblcompanies.companyabbr
having #variables.whereclause#
order tblforms.formnum, tblforms.formcustnum
</cfquery>

now, odd thing if take query text out of cfquery tags , use cfoutput instead (to see in browser query getting executed) query can paste enterprise mgr , runs fine.

i can paste resulting text code in cfquery , cf run fine.

in other words, dynamic version query gives me error, if output sql statement, copy-and-paste cfquery that's erroring out (replacing what's there) run static query, works fine (sample of static query below).

the error when try dynamically "error executing database query. [macromedia][sqlserver jdbc driver][sqlserver]line 4: incorrect syntax near '10169318'. error occurred on line 21." having clause starts.

select tblforms.formnum, tblforms.formname, tblforms.formcustnum, tblcompanies.companyabbr tblforms inner join tblcompanies on tblforms.formcustnum = tblcompanies.companynum group tblforms.formnum, tblforms.formname, tblforms.formcustnum, tblcompanies.companyabbr having (formnum = '10169318' or formnum = '1016concerta' or formnum = '1016nsaids' or formnum = '1016strattera' or formnum = '1016wellbutrin' or formnum = '18504211' or formnum = '185093807' or formnum = '73208565' or formnum = '732120027' or formnum = '7322154' or formnum = '7323402' or formnum = '7323522' or formnum = '73238900' or formnum = '7324211' or formnum = '7324211s' or formnum = '7324265' or formnum = '73242891' or formnum = '732434341' or formnum = '732434342' or formnum = '73243435' or formnum = '73243436' or formnum = '73243439' or formnum = '73243440' or formnum = '73243441' or formnum = '73243442' or formnum = '73243443' or formnum = '7324359' or formnum = '7324360' or formnum = '7324370' or formnum = '7324560' or formnum = '7324959' or formnum = '7326411ptreg' or formnum = '7326599' or formnum = '7326600' or formnum = '7326620' or formnum = '7326707' or formnum = '7326931' or formnum = '7328410' or formnum = '732851031top' or formnum = '7328512' or formnum = '7328548' or formnum = '7328548p2' or formnum = '7328548p3' or formnum = '7328548p4' or formnum = '73289400' or formnum = '73290d' or formnum = '7329154' or formnum = '73291544jhs' or formnum = '73291545jhs' or formnum = '73291546jhsmh' or formnum = '73291547jhsmh' or formnum = '7329174' or formnum = '7329308' or formnum = '7329402' or formnum = '7329424' or formnum = '7329455' or formnum = '7329520' or formnum = '7329539' or formnum = '73297701jh' or formnum = '73298273' or formnum = '73298400' or formnum = '73298403' or formnum = '73298404' or formnum = '7329883' or formnum = '73298860' or formnum = '7329887' or formnum = '73298974' or formnum = '7329899' or formnum = '7329899s' or formnum = '73299190' or formnum = '7329987' or formnum = '7329999pto' or formnum = '732av5160' or formnum = '732cmhfraz' or formnum = '732hipaa' or formnum = '732hipaaflyers' or formnum = '734heart' or formnum = '7444711' or formnum = '7449230' or formnum = '744hr4991' or formnum = '7538014mi' or formnum = '77511044' or formnum = '77511045' or formnum = '775stampnochange' or formnum = '80851001blue' or formnum = '80mr4200' or formnum = '80mr4273' or formnum = '80mr4274' or formnum = '80mr4300' or formnum = '80mr9934' or formnum = '80mr9935' or formnum = '80shc100' or formnum = '80shc4301' or formnum = '80shc9830' or formnum = '80shc9832') order tblforms.formnum, tblforms.formcustnum

use preservesinglequotes function whereclause variable.

More discussions in Database Access

adobe