Alright... looks like we have a winner...
insert
into hmls_photos
(photo_filename, photo_mls_number)
select '#photolist.name#', '#listfirst(photolist.name,
'_')#'
from dual
where
not exists (select photo_filename
from hmls_photos
where photo_filename =
'#photolist.name#')
After leaving out the value clause (which I figured was to be in there
somewhere)
things worked well. I haven't checked all the data, but at least the query ran!
I'll check it out further.
Thanks for all your help and patience!
All to everyone else for your responses, as well!
Rick
> -----Original Message-----
> From: Aaron Rouse [mailto:[EMAIL PROTECTED]
> Sent: Friday, May 16, 2008 1:26 PM
> To: CF-Talk
> Subject: Re: What's wrong with this query?
>
> Yes you are, you added code to what I put in my last email. Why do you have
> the VALUES part on there? The SELECT from dual is handling the VALUES that
> you need. What I put in my last email should be all you need with the
> exception of needing the opening and closing CFQUERY tags and again I may
> have a typo or two in mine but it should be really close to what you need.
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:305490
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
