Actually, that's not right. Either one will work.
I prefer <cfset variables.IDCount=getPeopleInfo.RecordCount> myself.
Have you run the query in a query analyzer? If so, does it return results?
Also, are you catching a database error and not returning anything to the
client?
============================================================
Russel Madere, Jr. Senior Web Developer
ICQ: 5446158 http://www.TurboSquid.com
Some days you eat the bear; some days the bear eats you.
============================================================
> -----Original Message-----
> From: t nelson [mailto:[EMAIL PROTECTED]]
> Sent: Monday, January 08, 2001 13:17
> To: CF-Talk
> Subject: Re: Query confusion - CF not recognising query name
>
>
> here's a real silly question but is
>
> <cfset variables.IDCount=getPeopleInfo.RecordCount> written exactly like
>
> this or is it written like
>
> <cfset variables.IDCount=#getPeopleInfo.RecordCount#> leaving the # off
> could be your problem.
>
> cheers,
>
> nelson
>
>
> ----Original Message Follows----
> From: "Philip Arnold - ASP" <[EMAIL PROTECTED]>
> Reply-To: [EMAIL PROTECTED]
> To: CF-Talk <[EMAIL PROTECTED]>
> Subject: Query confusion - CF not recognising query name
> Date: Mon, 08 Jan 2001 18:49:07 -0000
> Received: from [207.31.122.140] by hotmail.com (3.2) with ESMTP id
> MHotMailBC235737002ED82197E8CF1F7A8C1FA567; Mon Jan 08 11:06:20 2001
> Received: from houseoffusion.com ([207.31.122.140]) by
> www.houseoffusion.com (Post.Office MTA v3.5.3 release 223 ID#
> 0-54969U100L100S0V35) with ESMTP id com for
> <[EMAIL PROTECTED]>; Mon, 8 Jan 2001 14:04:13 -0500
> From [EMAIL PROTECTED] Mon Jan 08 11:07:45 2001
> Message-id: <[EMAIL PROTECTED]>
>
> 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
