I figured it out`-`
<cfquery name="GetRefences" datasource="#REQUEST.dataSource#">
SELECT *
FROM topics
</cfquery><html label="reference">
<h2>insert Reference</h2>
<p class="note"> </p>
<cfform action="insert_action.cfm" method="post" label="reference">
<table width="578" border="0">
<tr>
<td width="111">reference topic</td>
<td width="457"><cfselect name="topic">
<cfoutput query="GetRefences" group="areas" groupcasesensitive="no">
<option value="#areas#" label="reference_text"<cfif GetRefences.areas
eq
areas>
SELECTED</cfif>>#GetRefences.areas#</option>
</cfoutput>
</cfselect></td>
</tr>
<tr>
<td>reference text</td>
<td><cftextarea name="reference" label="reference" id="reference" rows="5"
cols="40"></cftextarea></td>
</tr>
<tr>
<td>reference link</td>
<td> <cfinput type="Text" name="reference_link" label="reference"
id="reference_link" size="50"></td>
</tr>
</fieldset>
<tr>
<td> </td>
<td><cfinput type = "submit" name="submit" class="button" value =
"submit"></td>
</tr>
<tr>
<td> </td>
</tr>
</table></cfform>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:5334
Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
