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