<cfquery name = "qryPropertyCategories">
Select CategoryID, CategoryName
>From tblPropCategories
Order By CategoryName
</cfquery>
<td align="right">Property Category: </td>
<td>
<Select name="selCategories">
<option value="" selected>All Types
<cfoutput query="qryPropertyCategory">
<option value="#CategoryID#">#CategoryName#
</cfoutput>
</select>
</td>
----- Original Message -----
From: "Interent Gold Coast Properties"
<[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, April 01, 1999 11:00 PM
Subject: CF SELECT HELP
> I am using the drop down box in a form to offer the user a selection
> extracted from the database however I cannot get the "required" facility
to
> work in the event the user does not select any data from that field
>
> your assistance would be appreciated
>
> the code I am using as follows:
>
> <td><b>Property Category</b><br>
> <cfselect name="PropertyCategory" size="1" required="yes"
> message="Please Select Your Property Category">
> <option></option>
> <cfoutput query="PropertyCategoryDropDown">
> <option>#PropertyCategoryDropDown.PropertyCategory#</option>
> </cfoutput>
> </cfselect>
> </td>
>
>
> Kind Regards
>
> Claude Raiola
> E-Mail: [EMAIL PROTECTED]
> Website: www.internetgoldcoastproperties.com.au
>
>
> --------------------------------------------------------------------------
----
> Archives: http://www.eGroups.com/list/cf-talk
> 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.eGroups.com/list/cf-talk
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.