Ok... I created a unique index on photo_filename and it definitely
stopped the process by throwing an error. In the CF app log, it states
"Error Executing Database Query.Duplicate entry '94219_0.JPG' for key 2"
So how do I modify the query, which now looks like this...
insert into hmls_photos
(photo_filename, photo_mls_number)
values (<cfqueryparam cfsqltype="cf_sql_varchar" value="#photolist.name#">,
<cfqueryparam cfsqltype="cf_sql_varchar"
value="#listfirst(photolist.name, '_')#">)
.... to allow the query to skip duplicates and continue to execute?
<pseudocode>
and if you find a duplicate value, just skip it, and go on to the next
value
</pseudocode>
> -----Original Message-----
> From: Dave Watts [mailto:[EMAIL PROTECTED]
> Sent: Friday, May 16, 2008 11:19 AM
> To: CF-Talk
> Subject: RE: What's wrong with this query?
>
> > Not being so well-versed in indexing (just starting using
> > those in MySQL 5), I don't understand how having a unique
> > index on the photo_filename column will prevent an insert of
> > a duplicate value.
> >
> > Is that function a part of creating a unique index? Does it
> > cause MySQL 5 to screen inserts for duplicates and reject them?
>
> Yes. That's why it's called a "unique" index.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:305442
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
