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 >> >> >> >> >> >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
