You are overwriting the query with an index named by the same name... this
should work:
<cfoutput>
#valuelist(prod.productID)#
<cfloop list=#valuelist(prod.productID)# index="i">
<cfparam name="total#i#" default=0>
<cfparam name="amttotal#i#" default=0>
</cfloop>
#valuelist(prod.productID)#
</cfoutput>
-Cameron
--------------------
Cameron Childress
elliptIQ Inc.
p.770.460.7277.232
f.770.460.0963
> -----Original Message-----
> From: Diana Nichols [mailto:[EMAIL PROTECTED]]
> Sent: Friday, May 11, 2001 2:30 PM
> To: CF-Talk
> Subject: loop puzzle....
>
>
> Can anyone explain why this is happening?
> the first valuelist prints perfectly, the second one throws this error:
> Parameter 1 of function ValueList which is now "prod.productID" must be
> pointing to a valid query name
>
> They are identical, and the only thing between them is the loop you see
> below. (The loop runs fine, too)
>
> The loop seems to delete the value of the query (???)
>
> <cfoutput>
> #valuelist(prod.productID)#
>
> <cfloop list=#valuelist(prod.productID)# index="prod">
> <cfparam name="total#prod#" default=0>
> <cfparam name="amttotal#prod#" default=0>
> </cfloop>
>
> #valuelist(prod.productID)#
> </cfoutput>
>
> TIA!
> D
>
> *************
> Diana Nichols
> Webmistress
> http://www.lavenderthreads.com
> 770.434.7374
>
> "One man's magic is another man's engineering." ---Lazarus Long
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
