> uh where do i put this:
> <cfif ListFind(ValueList(qgetrunwaydetail.runway_ID), runway_id)>
> I did it like this (guessing) but then only the TWO runways that should be
> checked show up I still
> need the other 2 NON CHECKED runways to show up unchecked?? Any
> suggestions?
>
> <CFQUERY datasource="#dsn#" name="qgetrunways">
> SELECT *
> FROM Runways
> </CFQUERY>
> <CFQUERY datasource="#dsn#" name="qgetrunwaydetail">
> SELECT runway_ID
> FROM Runway_Detail
> WHERE O_Report_Num = #qgetops.O_Report_Num#
> </CFQUERY>
> <P>What runway was affected if any?<BR>
>
>
> <CFOUTPUT query="qgetrunways">
> <cfif ListFind(ValueList(qgetrunwaydetail.runway_ID), runway_id)>
> <input type="checkbox" name="runway_id#runway_id#" <CFIF runway_id IS
> qgetrunwaydetail.runways.runway_id>CHECKED</CFIF>
> value="#runway_id#">#runway# </CFIF>
> </CFOUTPUT>
>
> ---------------------------------------
> Kelly Matthews
> Internet Development Coordinator
> AAAE
> 703.578.2509
> [EMAIL PROTECTED]
> http://www.airportnet.org
> ---------------------------------------
>
> -----Original Message-----
> From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, July 20, 2000 1:57 PM
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: RE: Help w/ query display...
>
> > Ok I run these 2 queries:
> > <CFQUERY datasource="#dsn#" name="qgetrunways">
> > SELECT *
> > FROM Runways
> > </CFQUERY>
> > <CFQUERY datasource="#dsn#" name="qgetrunwaydetail">
> > SELECT *
> > FROM Runway_Detail
> > WHERE O_Report_Num = #qgetops.O_Report_Num#
> > </CFQUERY>
> > The first just pulls all the runways.
> > The 2nd pulls any runways that were affected. the Runway_ID
> > is the field that is associated in both tables.
> >
> > In the output I have all the runways display with check boxes
> > (this works fine) by doing this:
> > <CFOUTPUT query="qgetrunways">
> > <input type="checkbox" name="runway_id#runway_id#"
> > value="#runway_id#">#runway#
> > </CFOUTPUT>
> > This works fine. It displays the 4 runways. HOwever with the
> > 2nd query it finds that 2 of the runways were reported to have
> > problems therefore I want those 2 check boxes to be CHECKED.
> > However doing this:
> > <input type="checkbox" name="runway_id#runway_id#"
> > value="#runway_id#" <CFIF runway_ID IS "qgetrunwaydetail.runway_ID">
> > CHECKED</CFIF>>#runway#
> >
> > Does not work. even though there are 2 runway Id's that are
> > pulled from the runwaydetail query it only brings back one
> > in this output. Either way it doesnt check any boxes at all.
> > Yet throws no errors either. The queries work fine so its
> > something in the way I am outputting. Any Suggestions???
>
> There are a couple of problems with what you're doing. The first problem
> is
> that you're referencing a string:
>
> <CFIF runway_ID IS "qgetrunwaydetail.runway_ID">
>
> instead of a variable:
>
> <CFIF runway_ID IS qgetrunwaydetail.runway_ID>
>
> The second problem is that you really want to have any runway checked if
> it's in the list of runways that have problems, so you'll have to look at
> all of them at once, rather than just looking at the first one:
>
> <cfif ListFind(ValueList(qgetrunwaydetail.runway_ID), runway_id)>
>
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
> voice: (202) 797-5496
> fax: (202) 797-5444
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
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.
