Ok I figured it out DUH:
<input type="checkbox" name="runway_id#runway_id#" <cfif
ListFind(ValueList(qgetrunwaydetail.runway_ID), runway_id)>CHECKED</CFIF>
value="#runway_id#">#runway#
Thanks Dave!
---------------------------------------
Kelly Matthews
Internet Development Coordinator
AAAE
703.578.2509
[EMAIL PROTECTED]
http://www.airportnet.org
---------------------------------------
> -----Original Message-----
> From: Kelly Matthews [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, July 20, 2000 2:01 PM
> To: '[EMAIL PROTECTED]'; [EMAIL PROTECTED]
> Subject: RE: Help w/ query display...
>
> ok thats the thing i didnt know how to do it was only looking at the FIRST
> and iw asnt sure
> how to get it to look at all of them. The missing quotes was just from
> typing and trying too many
> damn things.. hehe I will try that thanks!
> Kelly
>
> ---------------------------------------
> 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/[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.
