[ADVERT] Or, simply purchase a ready to go MLS search solution from the company I work for. We have the MLS data for over 200 MLS markets.
http://www.wolfnet.com http://www.mlsfinder.com [/ADVERT] Wil Genovese Sr. Web Application Developer One man with courage makes a majority. -Andrew Jackson A fine is a tax for doing wrong. A tax is a fine for doing well. On Jun 5, 2008, at 12:58 PM, Jochem van Dieten wrote: > Rick Faircloth wrote: >> (Simplified version... MySQL 5) >> >> <cfloop query='get_hmls_commercial_data'> >> >> <cfquery name='insert_data' datasource='xxxxx' > > Do get_hmls_commercial_data and insert_data query the same database? > In > that case you should do: > > INSERT INTO properties (mls_number) > SELECT ... > FROM ... > WHERE mls_number NOT IN ( > SELECT mls_number > FROM properties > ) > > Jochem > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306924 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
