Re: Query confusion - CF not recognising query name

[jeffc]

I just took out the ---- and #PreserveSingleQuotes(variables.whereList)# ---
set some variables and it worked fine for me. What's in the wherelist??
It ran fine for me. cf 4.01 on Windows 2000 server.

Jeff Craig

<cfset variables.peopletable = "users">
<cfset variables.idlist = "1,2,3,4,5,6">
<cfset form.orderby = "email">

<cfquery name="getPeopleInfo" datasource="voluma" blockfactor=100>
select ID
from #variables.peopleTable# (nolock)
where ID in (#variables.IDList#)
order by #form.OrderBy#
</cfquery>
<cfset variables.IDCount=getPeopleInfo.RecordCount>
<cfoutput>#variables.idcount#</cfoutput>


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists