Yes, certainly it does. when you use that same variable name as the loop
index. Change the name of your loop index. call it "iProd" maybe like
this:
<cfloop list=#valuelist(prod.productID)# index="iProd">
<cfparam name="total#iProd#" default=0>
<cfparam name="amttotal#iProd#" default=0>
</cfloop>
and your problems will disappear
-----Original Message-----
From: Diana Nichols [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 11, 2001 11:30 AM
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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
