I must be blind today - I've used cfloops like this many times....but the
output is wrong#@!$@#!^%$
I've reduced the code to see what was happening, and the value of the userID
the getusers query is not updating with each iteration of the output....in
other words, this code:
<cfquery name=getusers datasource=#dsn#>
select userID
from users
where companyID = 1
</cfquery>
<cfquery name=getm datasource=#dsn2#>
select userID
from billing
where companyID = 1
</cfquery>
<table>
<cfoutput query=getusers>
#getusers.userID# <cfloop query=getm>(#getusers.userID#,#getm.userID#)
</cfloop><p>
</cfoutput>
produces this output:
1 (1,1) (1,4) (1,19) (1,22) (1,23)
4 (1,1) (1,4) (1,19) (1,22) (1,23)
19 (1,1) (1,4) (1,19) (1,22) (1,23)
22 (1,1) (1,4) (1,19) (1,22) (1,23)
23 (1,1) (1,4) (1,19) (1,22) (1,23)
I don't have a clue what I've done wrong....help, please!
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