> 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.
I have a fixed IP, so I've now got debugging permanently on form me only
> 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 checked all of these when I was having the problem - I just couldn't talk
to the query although the SQL was running
> 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.
In that table there's only a few fields - most of which are INT, but since
it's working again, I can't trace the problem again
> Just try to get one record to work see if the problem is in the code or a
> record issue.
I tried that - it just wouldn't talk to the query
Philip Arnold
Director
Certified ColdFusion Developer
ASP Multimedia Limited
T: +44 (0)20 8680 1133
"Websites for the real world"
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**********************************************************************
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
