Coldfusion form processing

[kjab]

Hello,

I have created a form based on values from a MSSQL database

<cfoutput query="Items">
<tr>
<td>#trim(Item)# #DollarFormat(Price)#</td>
<td><input name="#trim(Item)#" type="text" value="Qty"></td>
</tr>
</cfoutput>


how can i query the database and use the results from the item query to process the form



Thanks in advance

[slappyjaw]

<cfquery name="name of query" datasource="your datasource address" username="usernameofdatasource" password="password for datasource" result="and your results for the query!">
Please fill in the information and it will be the query part of the script.