Web Design and Development Forums

Strange CF Error

This is a discussion on "Strange CF Error" within the Java, JSP, Cold Fusion section. This forum, and the thread "Strange CF Error are both part of the Program Your Website category.

Old Jun 8th, 2007, 12:32   #1 (permalink)
New Member
 
Join Date: Jun 2007
Location: London
Posts: 6
Strange CF Error

I have a strange CF Error. My page was developed in a framework designed by the company I work for. It is an MVC-based framework and for security reasons, I can not give you the details. However, there is a page that when you add a record, the code behind first deletes any record and then re-enters it, to prevent users haing the same record twice in the database. If you do this the first 4 times it's fine, but after the 4th time, the application just runs forever, until the screen is blank. The delete function on its own works fine, so something must be wrong with the add error.
The code does something like this:
<cfloop list="list of items chosen by user" index="i">
<cfquery datasource="datasource">
DELETE FROM table WHERE staff_id=i
</cfquery>
<cfquery datasource="datasource">
INSERT INTO table(staff_id)
VALUES(i)
</cfquery>
<cfloop>
We've checked the JDBC datasource and it connects to the underlying Oracle database properly.
Is there any reason this is happening?

Nikki
tallgal2007 is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
Reply

Tags
cfquery

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Another strange microsoft error Daniel Webforumz Cafe 9 Oct 25th, 2007 13:59
[SOLVED] Strange error with $_POST AdRock PHP Forum 2 Oct 13th, 2007 17:12
Keep getting error message Microsoft VBScript runtime error '800a01a8' cpando1974 ASP Forum 2 Aug 7th, 2007 12:00
Error 500 - Internal server error JasonStanley PHP Forum 3 Apr 23rd, 2007 17:56



Latest Updates

All Points SEO Security Advisory - CHECK YOUR SITE NOW!

Creative Coding :: February 2008

Webforumz is sponsored by: WESH UK Web Hosting
All times are GMT. The time now is 16:24.

Sleep Study Scoring :: Free Bet :: Website Templates :: Online Betting :: Bookmakers :: Funny Quotes :: Internet Recruitment Software :: Microsoft CRM Experts :: Online Casino :: Decorated Christmas Trees :: Midwife Forums :: Football Betting :: Ecommerce Software :: Web Hosting :: Football Stats :: Dry Cleaning Collection :: xtreme wales - extreme clothing :: Apuestas :: Sharepoint Consultants :: Website Optimisation :: Office Clearance London :: Sharepoint Experts :: Sports Betting :: Casino :: Website Templates :: Web Design Development India :: Online Gambling

Powered by: vBulletin Version 3.7, Copyright ©2000 - 2008, Jelsoft Enterprises Limited.
© 2003-2008 Webforumz.com : All Rights Reserved
Search Engine Friendly URLs by vBSEO 3.2.0 RC6


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59