Create a page that queries the items from the datasource then output these
items into a list.
<cfquery name="getitems" datasource="yourDSN">
SELECT itemid,item_name
FROM your_item_table
WHERE 0=0
</cfquery>
<!--- OUTPUT HERE --->
<cfform action="gotoyourblankpage.cfm">
<select name="items">
<option value=""> [ Select ] </option>
<cfoutput query="getitems">
<option value="#itemid#">#item_name#</option>
</cfloop>
</select>
<input type="submit">
</cfform>
WHEN THE FORM IS SUBMITTED, It sends the selected itemid as form.items. Use
this in your query to find the complete data for the item.
Contents of gotoyourblankpage.cfm-----------
<cfquery name="getitem" datasource="yourDSN">
SELECT itemid,item_name
FROM your_item_table
WHERE itemid='#form.itemid#'
</cfquery>
<cfoutput your content here...
----- Original Message -----
From: "Web Designer" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, February 06, 2002 5:48 PM
Subject: [CFTALKTor] Creating dynamic pages
> Hi,
>
> Does anyone know how to take build a drop down menu from an access
database,
> using cold fusion that links the items to a generic page where it will be
> built based on the fields from the database? All the info in the page
> except for some graphics will be dynamic. Does this make sense?
>
> Would I use a template for this?
>
> Thanks!
> Kelly
>
>
>
>
>
>
>
> -
> You are subscribed to the CFUGToronto CFTALK ListSRV.
> This message has been posted by: "Web Designer" <[EMAIL PROTECTED]>
> To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/
> Manager: Kevin Towes ([EMAIL PROTECTED])
http://www.CFUGToronto.org/
> This System has been donated by Infopreneur, Inc.
> (http://www.infopreneur.net)
-
You are subscribed to the CFUGToronto CFTALK ListSRV.
This message has been posted by: "Paul Giroux - Sympatico" <[EMAIL PROTECTED]>
To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/
Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/
This System has been donated by Infopreneur, Inc.
(http://www.infopreneur.net)
