Nick, You are right. I can depend on it most of the time. I just get leary when I fond code that uses max(id) and then I see an insert into a table followed by a query that searches by all values that were just inserted. The other one is where a cfquery does the insert and then uses a compound statement with a ";" to execute the next line to get @@identity or scope_identity().
All of these work and I have no problem with them or the developers that use this style. I just enjoy keeping my references to primary and foreign keys assignment and retrieval to my database. A stored proc takes me less time to create than most of my custom queries. MS SQL Server 2005 with the macro stored procedure creation makes that even quicker. As much as I dislike the slowness of the DB interface to 2005, it does have features that I can appreciate. Cheers, Teddy My own personal style would not to have compound statements in my <cfquery> as that elaves On 10/6/06, Nick Tong - TalkWebSolutions.co.uk <[EMAIL PROTECTED]> wrote: > > i.ve use boogiebounce and it works great. IP stops me from sharing sadly > but > i can say it does work. > > On 06/10/06, Dave Lyons <[EMAIL PROTECTED]> wrote: > > > > thanks Doug, I had contected boogiebounce before about it and the rep > told > > me it wouldnt work for this but i might try it anyways. > > > > > > >Here is a couple of links for your perusing. > > > > > > > > >http://evolt.org/node/17492 > > > > > >http://boogietools.com/products/ > > > > > > > > > > > >----- Original Message ----- > > >From: "Dave Lyons" <[EMAIL PROTECTED]> > > >To: "CF-Talk" <[email protected]> > > >Sent: Thursday, October 05, 2006 8:08 PM > > >Subject: removing bad emails from bounced emails and db > > > > > > > > >> yes I know we have gone over this before, sorta > > >> > > >> the deal is that we have a mailing list db that wasnt cleaned out for > > over > > >8 years so there are like 10,000 no good emails in it. I made some > script > > to > > >go in ang get the bounced emails, parse them for email addresses then > > delete > > >them from the list (checking the mail account with cfpop). > > >> > > >> The problem is that cfpop is so slow that it times out, i fixed that > by > > >using forwarding the page to another page inbetween emails then > > cflocation'n > > >them back to start again but after awhile i get errors about it not > being > > >able to forward the page. > > >> The other problem is that it is god awefully slow, bout 30-40 seconds > > for > > >each email. > > >> > > >> So the situation really is this, this first batch of cleaning out is > > gunna > > >be a bitch for whomever does it, which they really dont want to do, so > I > > am > > >looking to see if any of you know of any programs that can do it > > >effectively. > > >> > > >> Again, here is the problem. > > >> They send a newsletter out and they will get about 10,000 bounced > > >addresses back and basically we just need to grab all those 10,000 > emails > > >and delete them from mailing list. Although its not that simple but, do > > any > > >of you have anything or now of anything to effectively do it, doesnt > > matter > > >if it costs $$. > > >> > > >> tia > > >> > > >> > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:255795 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
