[cfaussie] RE: PRE-SELECTED Drop Down List

[Adam Chapman]

Hi Matthew,

Your second select list should be something like this:

<select name="StreetTypeID" tabindex="18">
        <option value=""<cfif not val(form.StreetTypeID)>
selected</cfif>>Select a Street Type</option> 
        <cfoutput query="qStreetTypes">
                <option value="#StreetTypeID#"<cfif
val(form.StreetTypeID) eq StreetTypeID>
selected</cfif>>>#StreetType#</option>
        </cfoutput>
</select>

Cheers,
Adam

-----Original Message-----
From: Matthew Doepel [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, June 23, 2004 10:51 AM
To: CFAussie Mailing List
Subject: [cfaussie] PRE-SELECTED Drop Down List


I want a user to select a value from a drop down list on form 1, then
preselect that value in the same list on the next form, Anyone help?
 
Drop down list query :
 
<CFQUERY NAME="qStreetTypes" DATASOURCE="SalesAccounts">
            SELECT      StreetTypes.StreetTypeID, StreetTypes.StreetType
            FROM        StreetTypes
            ORDER BY    StreetTypes.StreetType
</CFQUERY>
FORM 1:
<select name="StreetTypeID" tabindex="18">
                           <option value="" selected>Select a Street
Type</option> 
                            <cfoutput query="qStreetTypes">
                              <option
value="#StreetTypeID#">#StreetType#</option>
                            </cfoutput>
                          </select>
 
FORM 2: This is where I want the list to preselect the value from form 1
using  #FORM.StreetTypeID#
 
<select name="StreetTypeID" tabindex="18">
                         <option value="" selected>Select a Street
Type</option> 
                            <cfoutput query="qStreetTypes">
                              <option
value="#StreetTypeID#">#StreetType#</option>
                            </cfoutput>
                          </select>
 
Matthew Doepel
MGD Strategic Business Solutions
T: +61.2.9360.1555 | M: +61.417.88.55.44
F: +61.2.9380.6777
A: PO Box 1194, Darlinghurst, NSW 1300
E: [EMAIL PROTECTED]  | W: www.mgd.com.au
 
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to
[EMAIL PROTECTED] Aussie Macromedia Developers:
http://lists.daemon.com.au/ Register now for the 3rd National Conference
on Tourism Futures, being held in Townsville, North Queensland 4-7
August - www.tq.com.au/tfconf

---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
Aussie Macromedia Developers: http://lists.daemon.com.au/