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
>
>
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
