dynamic select names

[vijay_wv]

Hi,

need help to write action page respective to the dynamic select names and
values from the database as shown below. I know how to write code if the select
box has name not pulling from the database but in my case names are also
pulling from the database and I have no clue how to write action page for this.

For example: (if the select box name is just "ServerModel" then i know how to
write an action page)

<cfif #len(LTrim(form.ServerModel))# GT 0>
<cfquery name="getHwCost" datasource="isdMRRequest">
SELECT EstUnitPrice FROM ServerHardware
WHERE HdwrItemID = '#form.ServerModel#'
</cfquery>
<cfquery name="insertServerItems" datasource="isdMRRequest">
INSERT INTO ServerReqDetail
(ServerRequestNo,ItemID,UnitPrice,ServerReqIndex,H ardOrSoft)

VALUES(#RequestNo#,'#form.ServerModel#','#getHwCos t.EstUnitPrice#',#Index#,'H')

</cfquery>
</cfif>

Here is my case (code shown below)

Here is the formpage.cfm:

<cfquery name="categorytest" datasource="isdMRRequest">
Select * from ServerCategories WHERE RetireDate IS NULL AND Appear = 1 AND
Type = 'H' ORDER BY CategoryID
</cfquery>
<cfloop query="categorytest">
<cfset TMP2 = #Category#><tr><td align="left">
<cfoutput query="categorytest" maxrows="1">
#TMP2#:<br>
</cfoutput><cfset TMP = #CategoryID#></td><td align="left">
<select name="#categorytest.Category#">
<option value="">Select</option>
<cfoutput query="getHardwareItems">
<cfif #CategoryID# EQ #TMP#>
<option value="#HdwrItemID#">#Description# #DollarFormat(EstUnitPrice)#
</option>
</cfif>
</cfoutput>
<cfif #categorytest.qty# EQ 1>
<input type="hidden" type="text" name="dummy" size="1">&nbsp;&nbsp;Qty:&nbsp;
<input type="text" name="<cfoutput>#categorytest.Category#Qty</cfoutput>"
size="1">
</cfif>
<cfif #categorytest.Repeat# GTE 2>
<tr>
<td></td>
<td nowrap><select name="#categorytest.Category#2">
<option value="">Select</option>
<cfoutput query="getHardwareItems">
<cfif #CategoryID# EQ #TMP#>
<option value="#HdwrItemID#">#Description# #DollarFormat(EstUnitPrice)#
</option>
</cfif>
</cfoutput>
</select>
<cfif #categorytest.qty# EQ 1>
<input type="hidden" type="text" name="dummy" size="1">&nbsp;Qty:&nbsp;
<input type="text" name="<cfoutput>#categorytest.Category#Qty2</cfoutput>"
size="1">
</cfif> </td>
</tr>
</cfif>
<cfif #categorytest.Repeat# GTE 3>
<tr>
<td></td>
<td nowrap><select name="#categorytest.Category#3">
<option value="">Select</option>
<cfoutput query="getHardwareItems">
<cfif #CategoryID# EQ #TMP#>
<option value="#HdwrItemID#">#Description# #DollarFormat(EstUnitPrice)#
</option>
</cfif>
</cfoutput>
</select>
<cfif #categorytest.qty# EQ 1>
<input type="hidden" type="text" name="dummy" size="1">&nbsp;Qty:&nbsp;
<input type="text" name="<cfoutput>#categorytest.Category#Qty3</cfoutput>"
size="1">
</cfif> </td>
</tr>
</cfif>

Please help me in creating an action page for the code shown above...Thanks a
lot in advance.

[BSterner]

Can you clarify in more detail what you're trying to do w/this form. What do
you mean by "I know how to write code if the select box has name not pulling
from the database"? Looks like you're not outputting a select box if the value
isn't in the database?

[jorgepino]

not entirely sure what you trying to accomplish
can you give me some more info
post code make sure to use the "attache Code " feature