OK, I have a page where the user enters an election date. When they enter the date I first check to see if this council has an election date already. If it does I generate a message that says there is already an election date for this council and I give them a link to edit the current date. If it there is no election date, then I let them enter the date and Id number of the council. Well, what is happening is that when I enter a date for a council that I know does not already have an election date (I clear the table of all date), and then enter a new date, the date enters fine but my select query (which is happening BEFORE the insert and is wrapped in a CFIF to eliminate entering duplicate data) is returning a record count of 1 anyway. I even ran SQL Profiler to look at the sequence of events and all events are happening in the order that they should I am going to go ahead and re-write this part of the app so that when the user selects a neighborhood council, I query the database and if there is already an election date in the table then I will send them to the edit form rather than the insert new record form. This should eliminate unnecessary trips to the database. But I was wondering if anyone had any thoughts on this. I can attach code if need be.
Thanks, -- Bruce Sorge "I'm a mawg: half man, half dog. I'm my own best friend!" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade & see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:276788 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
