get rid of "getusers" in getusers.userID
<cfoutput query=getusers>
#getusers.userID# <cfloop query=getm>(#userID#,#getm.userID#)
</cfloop><p>
</cfoutput>
Todd
----- Original Message -----
From: "Diana Nichols" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, May 04, 2001 3:34 PM
Subject: cfloop help!
| 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