> Now my problem is this .... Is it possible to query the full list for the > email addresses that are not in the database ???
The easiest way I can think of off the top of my head... <cfquery name="results" dbtype="query"> select email from qFullList where address not in (qPartialList.address) </cfquery> I'm not fluent on QofQ, so you may need to use a #quotedValueList()# around the variable in the IN list if it yells at you. -Justin Scott, Lead Developer Sceiron Internet Services, Inc. http://www.sceiron.com ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
