Am not sure were in your statement that you want the database but here is a
copy of one I have on a site. Mine is CFSELECT but am sure select works
the same way. Matter of fact looking at mine I should change to select less
overhead :) Hope it helps.
Good Luck
David
<cfselect name="LNI_FAC" size="15" multiple>
<option value="ALL" selected>All FAC Cables</option>
<option value="'Unassigned'">Unassigned</options>
<cfloop query="LIST_FAC" >
<OPTION
value="'<cfoutput>#list_FAC.FAC_CA#</cfoutput>'"><cfoutput>#LIST_FAC.FAC_CA#
</cfoutput></option>
</cfloop>
</cfselect>
----- Original Message -----
From: "Ang�l Stewart" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, August 08, 2000 9:37 AM
Subject: Hi Guys n Gals! Quick Select box question :)
> I need a select box to display a value from a database.
>
> The box is not dynamic, and it is not a CFSelect box.
>
> It is a regular, plain vanilla <select> statement sitting inside a CFFORM
> inside a <CFLOOP query="qrySelectRecords"> statement.
>
> I just know this is really really easy for you gurus..but I just can't
> figure it out at the moment..
>
> here is the box code as it is now:
>
> <td><select <cfoutput>name="reason_#lookup.Audit_ID#"</cfoutput>>
> <option value="" SELECTED></Option>
> <option value="G">9/80</option>
> <option value="N">Absent Without Permission</option>
> <option value="F">Funeral Leave</option>
> <option value="I">Injury</option>
> <option value="J">Jury Duty</option>
> <option value="M">Maternity</option>
> <option value="O">Other Approved Absences</option>
> <option value="H">Public Holiday</option>
> <option value="S">Sick Leave</option>
> <option value="U">Surgical Leave</option>
> <option value="S">Suspension</option>
> <option value="C">Time Off</option>
> <option value="T">Training/Conferences/Team Building</option>
> <option value="W">Weekend</option>
> <option value="A">Vacation</option>
> </select></td>
>
> </tr>
>
> Thanks all!
> -Gel
>
>
> --------------------------------------------------------------------------
----
> 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.
