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
