
April 26th, 2006, 03:49 PM
|
|
Registered User
|
|
Join Date: Nov 2005
Posts: 22
Time spent in forums: 6 h 38 m 47 sec
Reputation Power: 0
|
|
|
Coldfusion help
Im very new in coldfusion and i need help. IM trying to change a static web pageto dynamic using coldfusion.
in my 1st page i have this codes so far
Code:
<cfquery name="wholeprList" datasource="petroleum_table">
SELECT Variable_Name
FROM vardefsx
WHERE Variable_Name IN ('RACPUUS','RAIMUUS','WTIPUUS','MGWHUUS','D2WHUUS' ,'DSWHUUS','PRPCUUS','JKTCUUS','RFTCUUS ');
</cfquery>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>wholesale Price</title>
</head>
<body>
<h1><strong>Short-Term Energy Outlook</strong></h1>
<h2>PETROLEUM</h2>
<form action="processSchedule.cfm" method="post">
<h1>Wholesale Price</h1>
<ul>
<cfloop query="wholeprList">
<li><cfoutput>#Variable_Name#</cfoutput>
<input type="checkbox" name="criteria">
</cfloop>
</ul>
</li>
</form>
</body>
</html>
what i am trying to do is make a page which has check buttons, then when a user checks it the data will be read from Access database.. so far this 1st page that i did, works fine showing me all the categories i wanted with checkboxes, this is also coming from the db. Now problem is how will i make a result page, resulting from the category that the user will check..
i hope i expliain it clear.. please any suggestions
thanks
|