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:305794 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Possible to use value statement and dual in mysql 5?
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
RE: Possible to use value statement and dual in mysql 5?
I worked around the problem by just running a separate update query to change the 'mls' field value after the photos are processed. -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:305808 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Possible to use value statement and dual in mysql 5?
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:305762 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4