Ummm...there's no loop in this code. On line 6 you're setting the variable
citysearch equal to something, and therefore you're blowing away the
resultset, because it's also called citysearch. I'm pretty sure that you
can't have a VARIABLES scope variable and a query resultset that use the
same name, because it confuses CF Server. But it might work if you specify
the VARIABLES. scope to differentiate the two.
Kevin Langevin
UsWebGuys
954-612-2136
[EMAIL PROTECTED]
> -----Original Message-----
> From: Lee Fuller [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, August 01, 2001 12:52 AM
> To: CF-Talk
> Subject: Recordcount/Query Strangeness..
>
>
> Ok.. Now I think I'm going nutz. This is completely crazy.
>
> When running this code...
>
> 1: <cfif not isdefined("citysearch.recordcount")>
> 2: <cfset citysearch = 0>
> 3: NOT!
> 4: <cfabort>
> 5: <cfelse>
> 6: <cfset citysearch = "#citysearch.recordcount#">
> 7: <cfoutput>#citysearch.recordcount#</cfoutput>
> 8: <cfabort>
> 9: </cfif>
>
> I get an error nearl line 7 column 15 "Error resolving parameter
> CITYSEARCH.RECORDCOUNT". However, I *CAN* do a CFOUTPUT and view the
> "CITYSEARCH" var.
>
> Even tho it HAS to go into the loop where the CITYSEARCH.RECORDCOUNT var
> is in existence to get to the part where it says it isn't in existence.
> Amazing.
>
> And this (along with the query) is the ONLY code on the page.
>
> Anyone have any ideas?
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
