Phillip,
A couple of suggestions. I use debugging on a production servers all the
time. If you have access to the CF Admin, I turn on debugging for my IP
address. Since I'm on dial-up and my ISP drops my connection all the time. I
have to change IP addresses that the debug shows on about every half hour.
While I'm debugging.
When I don't have the luxury of turning on debug. I use this to see what is
being passed.
<cfif #cgi.Remote_addr# is "123.456.789.123">
<cfoutput>
Whatever variables I'm looking to trace.
#PreserveSingleQuotes(variables.whereList)#
#variables.peopletable#
#variables.idlist#
#form.orderby#
</cfoutput>
</cfif>
I did run your query against one of my usertables and it ran fine without
the wherelist and got
the idcount to showup.... I'm guessing you have some record(s) with special
characters that are
causing the problem.
Just try to get one record to work see if the problem is in the code or a
record issue.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
