Forums
This topic is locked
Menu Lists
03 Mar 2006 21:06:28 Rob Rob posted:
I created a list menu below, it is only populated by Events that have data linked to them. So that means as of now only 3 of the five will show. That great. But what I can't figure out to do is how to pass on the Events Name to the next page which has another list menu that is only populated by tracks underthe selected event. I tried a form variable, but that passes on onlythe Event ID numebr not the Name. I need to pass the Event Name on. Can anybody Help?<cfquery name="rs_events" datasource="LearnCenter">
SELECT *
FROM C:\CFusionMX7\wwwroot\Classes\Classes.Events
WHERE EXISTS
(SELECT * FROM C:\CFusionMX7\wwwroot\Classes\Classes.Tracks WHERE Tracks.EventID = Events.EventID)
ORDER BY EventName ASC
</cfquery>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="www.w3.org/1999/xhtml">
<head>
<title>Event List</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
</head>
<body>
<h3>Select an Event</h3>
<form action="Track_List.cfm" method="post" name="frm_Events">
<p>
<select name="eventList" id="eventList">
<cfoutput query="rs_events">
<option value="#rs_events.EventID#">#rs_events.EventName#</option>
</cfoutput>
</select>
<input type="submit" name="Submit" value="Submit" />
</p>
<p> </p>
</form>
</body>
</html>