It looks like your code has been greatly excerpted. There is no chance that
you are setting the variable getPeopleInfo equal to some simple value and
overwriting the query somewhere between the query and the loop? Is the name
of the query dynamic?
Sorry for the questions, but it seems very unlikely that ColdFusion would
behave this way. Any additional information would be useful.
Benjamin S. Rogers
Web Developer, c4.net
voice: (508) 240-0051
fax: (508) 240-0057
-----Original Message-----
From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 08, 2001 1:49 PM
To: CF-Talk
Subject: Query confusion - CF not recognising query name
I've got some code running which SHOULD work, but isn't, and is confusing
the hell out of me
Here's the code;
<cfquery name="getPeopleInfo" datasource="People" blockfactor=100>
select ID
from #variables.peopleTable# (nolock)
where ID in (#variables.IDList#)
and #PreserveSingleQuotes(variables.whereList)#
order by #form.OrderBy#
</cfquery>
<cfset variables.IDCount=getPeopleInfo.RecordCount>
Here's the error;
An error occurred while evaluating the expression:
variables.IDCount=getPeopleInfo.RecordCount
Error near line 527, column 8.
Error resolving parameter GETPEOPLEINFO.RECORDCOUNT
ColdFusion was unable to determine the value of the parameter. This problem
is very likely due to the fact that either:
You have misspelled the parameter name, or
You have not specified a QUERY attribute for a CFOUTPUT, CFMAIL, or CFTABLE
tag.
I've tried putting a CFLoop straight after the query and it comes back that
the query doesn't exist - but I know it does (obviously)
It's running on CFPro4.5.1 SP2 on NT (Dual PIII 733, 512Mb RAM)
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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
