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.