Tried that at the same time I put the "where clause" before
the "values" clause...
insert into hmls_photos
(photo_filename, photo_mls_number)
where #photolist.name# not in
(select photo_filename from hmls_photos)
values (<cfqueryparam cfsqltype="cf_sql_varchar"
value="#photolist.name#">,
<cfqueryparam cfsqltype="cf_sql_varchar"
value="#listfirst(photolist.name, '_')#">)
> -----Original Message-----
> From: Kris Jones [mailto:[EMAIL PROTECTED]
> Sent: Friday, May 16, 2008 11:01 AM
> To: CF-Talk
> Subject: Re: What's wrong with this query?
>
> I think you'd need hash-marks (string delimiters) around
> photolist.name in the where clause, right?
>
> ....
> where '#photolist.name#' not in (select photo_filename from htmls_photos)
> ....
>
> -KJ
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:305430
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
