II really need help, I am new to CF what I am trying to do is the following:
I have a table in a form and I am trying to insert multiple data in a table .
I created an insert record but the problem that when I click the submit it inserts only the firs row of the table and that�s it .
Pls keep in mind that the number of rows is variable
This is the code I have:
<cfif IsDefined("FORM.MM_InsertRecord") AND FORM.MM_InsertRecord EQ "InsertOrder">
<cfquery datasource="MontPharmaData">
INSERT INTO Orders (UserName, CodeNo, DIN, BrandName, Manufacturer, GenericName,
"Size", Price, Qty, Extension) VALUES (
<cfif IsDefined("FORM.HFUsername") AND #FORM.HFUsername# NEQ "">
'#FORM.HFUsername#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.HFCodeNo") AND #FORM.HFCodeNo# NEQ "">
#FORM.HFCodeNo#
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.HFDIN") AND #FORM.HFDIN# NEQ "">
'#FORM.HFDIN#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.HFBrandName") AND #FORM.HFBrandName# NEQ "">
'#FORM.HFBrandName#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.HFManufacturer") AND #FORM.HFManufacturer# NEQ "">
'#FORM.HFManufacturer#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.HFGenericName") AND #FORM.HFGenericName# NEQ "">
'#FORM.HFGenericName#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.HFSize") AND #FORM.HFSize# NEQ "">
'#FORM.HFSize#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.HFPrice") AND #FORM.HFPrice# NEQ "">
'#FORM.HFPrice#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.HFQty") AND #FORM.HFQty# NEQ "">
'#FORM.HFQty#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.HFExtension") AND #FORM.HFExtension# NEQ "">
'#FORM.HFExtension#'
<cfelse>
NULL
</cfif>
)
</cfquery>
</cfif>
pls. help
Jamal
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
