Please advice what I should do if I to have a form such as this:
<FORM action="cse_subadd.cfm" method="post">
<TABLE width="500" border="0" cellspacing="0" cellpadding="0"
align="center">
<cfset bidarray=arraynew(3)>
<cfloop index="loopcount" from="1" to="#maxbids#">
<TR>
<TD> Quantity:
</TD>
<TD>
<INPUT type="text" name="bidarray[#loopcount#][1]" size="7"
maxlength="15">
</TD>
<TD>Price:
</TD>
<TD>
<INPUT type="text" name="bidarray[#loopcount#][2]" size="7"
maxlength="15">
</TD>
<TD Promised Delivery:
</TD>
<TD>
<INPUT type="text" name="bidarray[#loopcount#][3]" size="15"
maxlength="15">
</TD>
</TR>
</cfloop>
and cse_subadd.cfm is as follows:
<cfloop index="loopcount" from="1" to="#maxbids#">
<cfoutput>
#bidarray[1][1]#
<cfset bidqty = #bidarray[loopcount][1]#>
<cfset bidprc = #bidarray[loopcount][2]#>
<cfset promdel = #bidarray[loopcount][3]#>
<cfquery name="insert" datasource="svbid" dbtype="ODBC">
INSERT INTO bids(reqid, bidprc, bidstatus, bidqty, orgbiddate, promdel,
supplierid)
VALUES(#reqid#, #bidqty#, 5, #bidprc#, #DateFormat(Now(),"mm/dd/yyyy")#,
#promdel#, #customer#)
</cfquery>
</cfoutput>
</cfloop>
I get the following error:
Error Diagnostic Information
An error occurred while evaluating the expression:
#bidarray[1][1]#
Error near line 5, column 13.
----------------------------------------------------------------------------
----
Error resolving parameter BIDARRAY
ColdFusion was unable to determine the value of the parameter. This problem
is very likely due to the fact that either:
You have misspelled the parameter name, or
You have not specified a QUERY attribute for a CFOUTPUT, CFMAIL, or CFTABLE
tag.
The error occurred while processing an element with a general identifier of
(#bidarray[1][1]#), occupying document position (5:1) to (5:16).
******THE MAIN QUESTION IS ***************************
I can't put # sign within a variable surrounded by # (#abc#xyz##), how do i
get around that?
*******************************************
Thankyou, Nehal
>
> --------------------------------------------------------------------------
----
> > ------------------
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or
send a
> > message with 'unsubscribe' in the body to
[EMAIL PROTECTED]
> >
>
> --------------------------------------------------------------------------
----------------------
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
a message with 'unsubscribe' in the body to
[EMAIL PROTECTED]
----------------------------------------------------------------------------
--------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
