Re: Duplicate query execution in application.cfm for a certain page
Brent Shaub wrote: > I'm having trouble debugging this one. I have a query in application. > cfm that inserts to a table. For most pages, I see one record. For a > particular page, I am seeing two. What would be in this file that > could cause application.cfm to fire twice? Usually it means there are 2 requests. One for the page, one for an error handler or a 404 handler. Jochem ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257087 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Duplicate query execution in application.cfm for a certain page
Somehow this one worked itself out. I made the following changes: 1. made some changes to the frame that referred to it, 2. renamed the file and renamed it back, (didn't seem to work) 3. created a new page with a new name and linked to it in the calling frame, 4. removed the link and page created in 3. Of all of these, clearing the cache for the calling page seems to make the most sense. It's working now, and that's the best answer I have. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257055 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Duplicate query execution in application.cfm for a certain page
Brent Shaub wrote: > > Hello all, > > I'm having trouble debugging this one. I have a query in application.cfm > that inserts to a table. For most pages, I see one record. For a > particular page, I am seeing two. What would be in this file that could > cause application.cfm to fire twice? I even tried using a request-scope > flag to prevent the second entry with no luck. It's a simple page without > any includes, and it's not being included. > > Thanks for any help on this, > Brent > It could be because of a duplicate request. Put a cflog tag in there and check the thread id. /t -- View this message in context: http://www.nabble.com/Duplicate-query-execution-in-application.cfm-for-a-certain-page-tf2460888.html#a6859790 Sent from the Cold Fusion - Technical mailing list archive at Nabble.com. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257052 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Duplicate query execution in application.cfm for a certain page
These are good thoughts, Ben. I forgot to mention how simple this page is. I'm accessing it via a simple link in a navigation frame. Come to think of it, that is one thing I didn't think of. The refering page has no form, isn't doing a post and has no validation JavaScript. It's a basic "a href". But the target is another frame. I will experiment with this a bit more. Thanks for your post, Brent ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257051 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Duplicate query execution in application.cfm for a certain page
For starters, start CFMailing yourself the CGI / FORM scopes right before the INSERT it performed. That way you can see all the data / environmental variables that are in existence when this happens. Secondly, you might have a Form that is submitted twice. Are you doing any Javascript stuff on Form validation or something that might do this. Remember, once the Form submits, it will fire a page request. If you submit the page AND then Javascript does some flavor of a form.submit(), this will be submitting the form twice even though visually (from the user's stand point), the form has only submitted once. -ben .. Ben Nadel Certified Advanced ColdFusion Developer www.bennadel.com -Original Message- From: Brent Shaub [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 17, 2006 12:55 PM To: CF-Talk Subject: Duplicate query execution in application.cfm for a certain page Hello all, I'm having trouble debugging this one. I have a query in application.cfm that inserts to a table. For most pages, I see one record. For a particular page, I am seeing two. What would be in this file that could cause application.cfm to fire twice? I even tried using a request-scope flag to prevent the second entry with no luck. It's a simple page without any includes, and it's not being included. Thanks for any help on this, Brent ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257048 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
