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

Reply via email to