Is this the correct syntax for looping through an insert:
Insert into ProteinSequence
(Project_ID,
AA_Sequence,
Gene_Name,
Count)
Values(
'#thisprojectid#',
'#form['ProteinSequence' & LoopCount]#',
'#form['genename' & LoopCount]#',
'#form['NoAminoAcids' & LoopCount]#'
)
I am getting an error when I know the form field name is correct:
[Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name
'ProteinSequence'.
The error occurred
in*C:\inetpub\wwwroot\sttr2\orders\neworder_main_confirm_action.cfm:
line 77*
75 : '#form['ProteinSequence'& LoopCount]#',
76 : '#form['genename'& LoopCount]#',
*77 : '#form['NoAminoAcids'& LoopCount]#'*
78 : )
79 :</cfquery>
Rick.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338548
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
