<cfquery name="getProducts" ....>
SELECT ProductID, ProductNumber FROM Product ORDER BY ProductNumber
</cfquery>
.
.
.
<select name="Products> size="10">
<cfoutput query="getProducts">
<option value="#ProductID#"<cfif Form.Products eq ProductID>
selected</cfif>>#ProductNumber#</option></cfoutput>
</select>
The </option> tag is for compatibility with XML.
HTH
Dick
At 6:54 PM -0700 10/2/00, monika kon wrote:
>Hello everyone,
>
>I have a scrolling list on my CF template.I have a
>field in the database named "Product Numbers",I want
>that the "product numbers" (in my case) should come
>from the database to the List.So if I add another
>product number to the database ,it should be
>automatically reflected in the scrolling list.Please
>help. Thanks in advance
>Shally
------------------------------------------------------------------------------
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.
