> <input type="text" name="quantity,#keyArray[counter]#" value="numeric
> value">
> <input type="text" name="cost,#keyArray[counter]#" value="numeric value">
Creating dynamic variables means...
> <cfquery name="qry_saveissue" datasource="#str_dsn#">
> Insert into issue_values(issue_name,system_key,quantity,cost)
>
>
VALUES('#form.issue_name#',#keyArray[counter]#,#form.quantity,keyArray[count
> er]# ,#form.cost,#keyArray[counter]# )
> </cfquery>
..you need to evaluate() them in the processing code...
<cfquery name="qry_saveissue" datasource="#str_dsn#">
Insert into issue_values(
issue_name,
system_key,
quantity,
cost)
VALUES(
'#form.issue_name#',
#keyArray[counter]#,
#evaluate("form.quantity," & keyArray[counter])#,
#evaluate("form.cost," & keyArray[counter])#)
</cfquery>
Also, you cannot use commas in your variable names as CF will have a hissy
fit. Use a dash or underscore instead. I left your commas in the
evaluate() example above to demonstrate how it would be done.
-Justin Scott, Lead Developer
Sceiron Internet Services, Inc.
http://www.sceiron.com
PS: Your sig says you're a certified developer.. you should know this stuff
already.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
