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
