Here is the form:
<FORM ACTION="index.cfm" METHOD="POST" NAME="CAForm">
<CFOUTPUT>
<TABLE BORDER="1" CELLPADDING="2" ALIGN="center" WIDTH="40%">
<TR>
<TD VALIGN="top">
<B>Organization:</B><BR>
#GetCA.Organization#<BR>
<B>Account Number:</B> #GetCA.CAAccount#<BR>
#GetCA.CAAccount#<BR>
<B>Address:</B><BR>
#GetCA.CAAddress1#<BR>
#getCA.CAAddress2#<BR>
#getCA.CAAddress3#<BR>
<B>City, State Zip:</B><BR>
#getCA.CACity#,
</CFOUTPUT>
<CFOUTPUT QUERY="Application.States">
<CFIF getCA.State_Fk EQ Application.States.State_Pk>
#Application.States.StateAbbreviation#
</CFIF>
</CFOUTPUT>
<CFOUTPUT>
#getCA.CAZip#<BR>
<B>Country:</B><BR>
</CFOUTPUT>
<CFOUTPUT QUERY="Application.Countries">
<CFIF getCA.Country_Fk EQ Application.Countries.Country_Pk>
#Application.Countries.CountryName#
</CFIF>
</CFOUTPUT><BR>
<CFOUTPUT>
<B>Phone, Fax:</B><BR>
#getCA.CAPhone# #getCA.CAFax#<BR>
<B>Credit Limit:</B> #DollarFormat(getCA.CreditLimit)#<BR>
<CFIF Len(getCA.CurrentBalance)>
<B>Current Balance:</B> #DollarFormat(getCA.CurrentBalance)#<BR>
</CFIF>
<B>Tax ID:</B> #getCA.CATaxNo#
</TD>
</TR>
<TR>
<TD>
<B>Payment Amount:</B> <INPUT TYPE="text" NAME="Amount" SIZE="5"
MAXLENGTH="8">
</TD>
</TR>
<TR>
<TD>
<B>Notes:</B> <INPUT TYPE="text" NAME="Notes" SIZE="30"
MAXLENGTH="200">
</TD>
</TR>
<TR>
<TD ALIGN="center">
<INPUT TYPE="submit" VALUE="Enter Payment">
<INPUT TYPE="hidden" NAME="CA_Pk" VALUE="#getCA.CreditAccount_Pk#">
</TD>
</TR>
</TABLE>
<INPUT TYPE="hidden" NAME="Step" VALUE="#Evaluate(Attributes.Step + 1)#">
<INPUT TYPE="hidden" NAME="FuseAction" VALUE="#Attributes.FuseAction#">
</CFOUTPUT>
</FORM>
Here is the page that submits the data:
<CFSETTING ENABLECFOUTPUTONLY="no">
<!--- Enter the payment --->
<CFSTOREDPROC PROCEDURE="pr_CAPayment" DATASOURCE="#request.admin.ds#" DEBUG="Yes">
<CFPROCPARAM TYPE="In" CFSQLTYPE="CF_SQL_INTEGER" DBVARNAME="@CA_Pk"
VALUE="#Attributes.CA_Pk#" NULL="No">
<CFPROCPARAM TYPE="In" CFSQLTYPE="CF_SQL_MONEY" DBVARNAME="@Amount"
VALUE="#Attributes.Amount#" NULL="No">
<CFPROCPARAM TYPE="In" CFSQLTYPE="CF_SQL_VARCHAR" DBVARNAME="@Notes"
VALUE="#Left(Attributes.Notes, 200)#" NULL="No">
</CFSTOREDPROC>
<CFLOCATION
URL="#request.admin.cfroot#index.cfm?FuseAction=Main&Message=CAPayment&Amount=#Attributes.Amount#"
ADDTOKEN="no">
"Andrew Scott" <[EMAIL PROTECTED]> wrote:
>Can you send me the snippet of code for the submit part!!
>
>
>Regards,
>Andrew Scott
>
>
>-----Original Message-----
>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
>Sent: Wednesday, 26 September 2001 0:06 AM
>To: Fusebox
>Subject: RE: cf_bodycontent causes procedure to run twice?!!
>
>Okay, I tried removing the js check and it still is double submitting.
>Only now it is doing it regardless of cfbodycontent being their or not.
>
>Ian
>
>"Andrew Scott" <[EMAIL PROTECTED]> wrote:
>
>>I racked my brain over this last year, and worked out that under IE5.5
>>the JS would submit the information one for each call. The normal
>submit
>>input, and the JS way. I have no idea why MS allowed this to get into
>>something that was already working, or if anyone knows why this has
>been
>>changed.
>>
>>But yeah the workaround at the moment is switch away from submit type
>>and JS submit combination!
>>
>>
>>Regards,
>>Andrew Scott
>>
>>
>>-----Original Message-----
>>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
>>Sent: Monday, 24 September 2001 14:35 PM
>>To: Fusebox
>>Subject: RE: RE: cf_bodycontent causes procedure to run twice?!!
>>
>>Ummm, yep. Has this already gone around and I missed it? Why would the
>>problem go away when I take out the bodycontent tags?
>>
>>Ian
>>
>>"Andrew Scott" <[EMAIL PROTECTED]> wrote:
>>
>>>Let me guess you are running ie5.5 on Widnows 95/98/me/2000, you are
>>>also using the JS submit with the onSubmit or onClick?
>>>
>>>
>>>Regards,
>>>Andrew Scott
>>>
>>>
>>>-----Original Message-----
>>>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
>>>Sent: Saturday, 22 September 2001 8:55 AM
>>>To: Fusebox
>>>Subject: cf_bodycontent causes procedure to run twice?!!
>>>
>>>Okay, here is a weird one. I have a stored procedure that has been
>>>running twice everytime I submit the page instead of once. I started
>>>eliminating everything from the index page to try and isolate the
>>>problem and I found that the problem vanishes as soon as I take out
>the
>>>cf_bodycontent and app_layout from my index page. The code for the
>>index
>>>page, stored procedure and stored procedure calling page is below. My
>>>site has over 300 procedures and this is only occurring on 5
>procedures
>>>that are in 2 different fuseboxes on my site. Any ideas?
>>>
>>>The index page:
>>>
>>><CFSETTING ENABLECFOUTPUTONLY="yes">
>>><CFINCLUDE TEMPLATE="#webpath#/admin/app_locals.cfm">
>>><CFSETTING ENABLECFOUTPUTONLY="No">
>>>
>>><CF_BODYCONTENT>
>>> <CFINCLUDE TEMPLATE="blocks/dsp_message.cfm">
>>>
>>> <!--- Inventory Tools --->
>>> <CFSWITCH EXPRESSION="#Attributes.FuseAction#">
>>> <CFCASE VALUE="CAPayment">
>>> <CFSWITCH EXPRESSION="#Attributes.Step#">
>>> <CFCASE VALUE="1">
>>> <CFINCLUDE TEMPLATE="blocks/dsp_FindCAForm.cfm">
>>> </CFCASE>
>>> <CFCASE VALUE="2">
>>> <CFINCLUDE TEMPLATE="blocks/dsp_CAList.cfm">
>>> </CFCASE>
>>> <CFCASE VALUE="3">
>>> <CFIF IsDefined("Attributes.CANumber") AND
>>>IsNumeric(Attributes.CANumber) AND Len(Attributes.CANumber)>
>>> <CFSET Attributes.CA_Pk =
>>>Evaluate("Attributes.R_"&Attributes.CANumber)>
>>> <CFINCLUDE TEMPLATE="blocks/dsp_CAForm.cfm">
>>> <CFELSE>
>>> <CFLOCATION
>>>URL="index.cfm?FuseAction=CAPayment&Step=1&Message=CANotFound"
>>>ADDTOKEN="no">
>>> </CFIF>
>>> </CFCASE>
>>> <CFCASE VALUE="4">
>>> <CFINCLUDE TEMPLATE="actions/act_CAPayment.cfm">
>>> </CFCASE>
>>> </CFSWITCH>
>>> </CFCASE>
>>>
>>> <CFDEFAULTCASE>
>>> <CFINCLUDE TEMPLATE="blocks/dsp_Login.cfm">
>>> </CFDEFAULTCASE>
>>> </CFSWITCH>
>>></CF_BODYCONTENT>
>>><CFINCLUDE TEMPLATE="#request.admin.cfroot#app_layout.cfm">
>>>
>>>The page that calls the sp (actions/act_CAPayment.cfm):
>>>
>>><!--- Enter the payment --->
>>><CFSTOREDPROC PROCEDURE="pr_CAPayment" DATASOURCE="#request.admin.ds#"
>>>DEBUG="Yes">
>>> <CFPROCPARAM TYPE="In" CFSQLTYPE="CF_SQL_INTEGER"
>>DBVARNAME="@CA_Pk"
>>>VALUE="#Attributes.CA_Pk#" NULL="No">
>>> <CFPROCPARAM TYPE="In" CFSQLTYPE="CF_SQL_MONEY"
>DBVARNAME="@Amount"
>>>VALUE="#Attributes.Amount#" NULL="No">
>>> <CFPROCPARAM TYPE="In" CFSQLTYPE="CF_SQL_VARCHAR"
>>DBVARNAME="@Notes"
>>>VALUE="#Left(Attributes.Notes, 200)#" NULL="No">
>>></CFSTOREDPROC>
>>>
>>>The stored procedure:
>>>
>>>CREATE PROCEDURE pr_CAPayment
>>> @CA_Pk int,
>>> @Amount money,
>>> @Notes varchar(200)
>>>AS
>>>
>>>INSERT INTO
>>> CreditActHist
>>> (CreditAccount_Fk,
>>> PaymentAmt,
>>> CreditActHistNotes)
>>>VALUES
>>> (@CA_Pk,
>>> @Amount,
>>> @Notes)
>>>
>>>UPDATE
>>> CreditAccount
>>>SET
>>> CurrentBalance = CurrentBalance - @Amount
>>>WHERE
>>> CreditAccount_Pk = @CA_Pk
>>>--
>>>Webmaster
>>>
>>>The Catholic Store
>>>http://www.catholicstore.com
>>>
>>>The Catholic Liturgical Library
>>>http://www.catholicliturgy.com
>>>
>>>Friends Of UD
>>>http://www.friendsofud.com
>>>
>>>
>>>
>>>
>>>
>>>
>>
>>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Get the mailserver that powers this list at http://www.coolfusion.com
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
