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:306922
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
