If I am reading your code right, just change your
#lookup.Audit_ID# to
#qrySelectRecords.Audit_ID#
I am assuming that your query is named qrySelectRecords.
Hope this helps
H Larry Juncker
L Senior Cold Fusion Programmer
I Heartland Communications Group
Internet Division
-----Original Message-----
From: Angél Stewart [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 08, 2000 11:37 AM
To: [EMAIL PROTECTED]
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/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.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message
to [EMAIL PROTECTED] with 'unsubscribe' in the body.
