Are you talking to SQL Server? I don't think it likes the table name
"Users" Try putting square brackets around the table name, eg. "[Users]"
and see if that helps.
AND run it with debugging on to show the SQL and the result. This will let
you know whether the SQL is actually being executed and how many rows it
returns.
-----Original Message-----
From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 08, 2001 10:49 AM
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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
