Saturday, November 9, 2002, 9:01:36 AM, you wrote: >> -----Original Message----- >> From: jon hall [mailto:jonhall@;ozline.net] >> Sent: Friday, November 08, 2002 4:22 PM >> To: CF-Talk >> >> Specifically what I was trying to optimize was a check to see >> of an email address was a duplicate, valid, and not in a >> remove list. This would require 2 database queries and a run >> through the validate method.
SA> Aside... Why even have a remove list ? Why not have a remove flag in one SA> table? That's the way I have it...it's an import routine, new addresses are coming from a cvs file uploaded... -- jon mailto:jonhall@;ozline.net ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
