Here is what i did
Still only pulls ONE of the 2 runways that it should for the first report.
however i may have done it wrong.
<cfloop query="qgetwild">
<CFOUTPUT>
<tr><td valign=top><font face=verdana size=2 color="black">
<B>Date of Incident:</b> #DateFormat(O_Period_dt_Beg, 'mmmm d, yyyy')#</td>
<td valign=top NOWRAP><font face=verdana size=2 color=black><b>Number of
Wildlife Incidents:</b> #O_WildLife#</td>
<td valign=top NOWRAP><font face=verdana size=1 color=black><B>Report
Number:</b>
#O_Report_Num#</td></tr><tr><td colspan=3 valign=top><font face=verdana
size=2 color="black"><b>Wildlife Info:</b> #O_WildLife_Incidents#</td></tr>
<tr>
<td colspan=3 valign=top><font face=verdana size=2 color=black>
<b>Bird Strikes:</b> #O_Bird_Strikes# <B>K9:</b> #O_K9#
<B>Flocks of Birds:</b>
#O_Flocks_of_Birds# <b>Small Mammals:</b>
#O_Small_Mammals#</td></tr><tr>
<tr>
<td colspan=3 valign=top><font face=verdana size=2 color=black>
<B>Runways Affected:</b>
<CFQUERY datasource="#dsn#" name="qgetrunwaydetail">
SELECT runway_ID
FROM Runway_Detail
WHERE O_Report_Num = #qgetwild.O_Report_Num#
</CFQUERY>
<P>What runway was affected if any?<BR>
<cfif ListFind(ValueList(qgetrunwaydetail.runway_ID),
qgetrunways.runway_id)>#qgetrunways.runway#</CFIF>
</td></tr> <tr><td colspan=3>
<hr NOSHADE color=black></td></tr></CFOUTPUT></cfloop>
---------------------------------------
Kelly Matthews
Internet Development Coordinator
AAAE
703.578.2509
[EMAIL PROTECTED]
http://www.airportnet.org
---------------------------------------
> -----Original Message-----
> From: Joseph Thompson [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, July 25, 2000 10:11 AM
> To: [EMAIL PROTECTED]
> Subject: Re: CFOUTPUT/QUERY question/Problem
>
>
> On Tue, 25 Jul 2000 09:49:25 -0400, [EMAIL PROTECTED] wrote:
>
> > Ok someone helped me with something similar before. Basically I
> initially
> > run a query based on a set
> > of dates and pull ALL records within that date range (simple enough):
>
> Good morning. I suspect that the trick here is to use an output loop
> <cfloop query="qgetwild">
> <cfquery ="qgetrunwaydetail">
> ..
> </cfquery>
> </cfloop>
>
> I have seen more elegant solutions, but this is my favorite : )
>
>
>
>
>
> _______________________________________________________
> Say Bye to Slow Internet!
> http://www.home.com/xinbox/signup.html
>
> --------------------------------------------------------------------------
> ----
> Archives: http://www.mail-archive.com/[email protected]/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
