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
