No, dual is a MySQL function, also. I just haven't found a way to use "value" statements as part of the "dual" select statement involved. The "dual" method seems to be limited to the specific function of catching duplicates.
Rick > -----Original Message----- > From: AJ Mercer [mailto:[EMAIL PROTECTED] > Sent: Wednesday, May 21, 2008 3:25 AM > To: CF-Talk > Subject: Re: Possible to use value statement and dual in mysql 5? > > I think you will find 'dual' is an oracle only thing > > > > > On Wed, May 21, 2008 at 3:39 AM, Rick Faircloth <[EMAIL PROTECTED]> > wrote: > > > Hi, all... > > > > Does anyone know if it's possible to use a value statement > > in this query that uses "dual"? > > > > I need to insert a value of "hmls" for the field "mls" in the > > property_photos table > > when this query is run... > > > > insert > > into property_photos > > ( photo_filename, photo_mls_number ) > > > > select '#photolist.name#', '#listfirst(photolist.name, '_')#' > > from dual > > where > > not exists (select photo_filename > > from property_photos > > where photo_filename = '#photolist.name#') > > > > Thanks, > > > > Rick > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:305807 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
