Hi Jeff!.
qry_get_team_members returns the members who and all added ..
please have a look at this this is the code..
-------------------
<cfoutput query=qry_get_single_meeting_attendees group=meeting_idx>
<tr align="center" valign="top" bgcolor="##FFFFFF">
<td valign="top" align="left" width="348"><font face="Arial, Helvetica,
sans-serif" size="1">
<cfloop index=loopcount from=1 to=#qry_get_team_members.recordcount#>
<cfif #qry_get_team_members.rec_id[loopcount]# eq #member_idx#>
<div align="center">#qry_get_team_members.name[loopcount]#<br> </div>
</cfif>
</cfloop>
---------------------------------------------------
this is the query
<cfquery datasource=reports name=qry_get_team_members>
select * from MEMBERS where team_idx=#session.team_idx# </cfquery>
--
On Mon, 09 Apr 2001 11:44:04
Garza, Jeff wrote:
>Ok, so what is the output of qry_get_team_members and qry_get_meetings.
>
>Are you returning the proper resultsets from these queries?
>
>Jeff Garza
>Web Developer/Webmaster
>Spectrum Astro, Inc.
>480.892.8200
>
>[EMAIL PROTECTED]
>http://www.spectrumastro.com
>
>
>
>-----Original Message-----
>From: paul . [mailto:[EMAIL PROTECTED]]
>Sent: Monday, April 09, 2001 11:01 AM
>To: CF-Talk
>Subject: RE: cfloop is not working please suggest ..
>
>
>
>--well jeff thanks..
>but am indexing because i need to make the members display first and make
>them absentees for the meeting..
>the issue is am adding the members and indexing them and make them absent
>later.
>here the case is am adding them.. its fine and and displays the first added
>person.. when i make the fisrt guy absent only the next member it shows..
>but i want all of the guys who are added so that i can make any of them
>absent
>-got it?? help me please .. but the same thing works elsewhere but not here
>-paul
>
>On Mon, 09 Apr 2001 10:28:42
> Garza, Jeff wrote:
>>Why are you using a indexed loop when you can loop on the query???
>>
>><CFLOOP query="qry_get_team_members">
>> <cfif rec_id eq member_idx>
>> <div align="center"><CFOUTPUT>#name#</CFOUTPUT></div>
>> </cfif>
>></cfloop>
>></font></td>
>><cfloop query="qry_get_meetings.recordcount">
>> <cfif rec_id eq meeting_idx>
>> </cfif>
>></cfloop>
>>
>>Also, you need to use a cfoutput tag pair within your cfloop to display the
>>ouput. Also, If you are getting no output, make sure that you are properly
>>closing your TR's and TD's. Netscape will puke if all is not right within
>>your table structure.
>>
>>Jeff Garza
>>Web Developer/Webmaster
>>Spectrum Astro, Inc.
>>480.892.8200
>>
>>[EMAIL PROTECTED]
>>http://www.spectrumastro.com
>>
>>
>>
>>-----Original Message-----
>>From: paul . [mailto:[EMAIL PROTECTED]]
>>Sent: Monday, April 09, 2001 10:02 AM
>>To: CF-Talk
>>Subject: Re: cfloop is not working please suggest ..SOS hey Guys please
>>suggest
>>
>>
>> hey guys please do suggest
>>-paul
>>--
>>
>>On Mon, 09 Apr 2001 09:27:06
>> paul . wrote:
>>>Hi all !.. i am using the following coding But it shows just the first
>>record only not all that records which match the query.. is this cfloop is
>>not working..? But 'indexing' its doing..
>>>please suggest
>>>-paul
>>>
>>>
>>>
>>> <cfloop index=loopcount from=1 to=#qry_get_team_members.recordcount#>
>>> <cfif #qry_get_team_members.rec_id[loopcount]# eq #member_idx#>
>>> <div align="center">#qry_get_team_members.name[loopcount]#
></div>
>>> </cfif>
>>> </cfloop>
>>> </font></td>
>>> <cfloop index=loopcount from=1 to=#qry_get_meetings.recordcount#>
>>> <cfif qry_get_meetings.rec_id[loopcount] eq meeting_idx>
>>> </cfif>
>>> </cfloop>
>>>
>>>
>>>Get 250 color business cards for FREE! at Lycos Mail
>>>http://mail.lycos.com/freemail/vistaprint_index.html
>>>
>>
>>>
>
>>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
