RE: Help with Transact SQL
Perhaps I'm missing something here but shouldn't a simple update statement suffice e.g. Update sometable Set pathField = '/path1/path2/rest_of_path' Where pathField = 'http://an_absolute_path/new_path_1/path2/rest_of_path ' Or is there more to it? Kola -Original Message- From: Frank Mamone [mailto:[EMAIL PROTECTED] Sent: 24 September 2003 23:38 To: CF-Talk Subject: Help with Transact SQL Hi, I need help with an update query using transact SQL. I need to modify the data in record set in the following way. The field contains a URL like this: /path1/path2/rest_of_path I need to change it to: http://an_absolute_path/new_path_1/path2/rest_of_path So everything stays the same from path2 on. Thanks in advance for your help. Frank Mamone ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:138422 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Re: Help with Transact SQL
you can use the following to update all rows at once: update tablename set uri_column = 'http://etc.com/etc' + uri_column - Original Message - From: Frank Mamone [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, September 25, 2003 1:38 AM Subject: Help with Transact SQL Hi, I need help with an update query using transact SQL. I need to modify the data in record set in the following way. The field contains a URL like this: /path1/path2/rest_of_path I need to change it to: http://an_absolute_path/new_path_1/path2/rest_of_path So everything stays the same from path2 on. Thanks in advance for your help. Frank Mamone ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:138423 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 ColdFusion MX 6.1, now 2.5 times faster. http://www.macromedia.com/software/coldfusion/productinfo/upgrade/jump/introducing.html?trackingid=ColdFusion_468x60g_HouseofFusion_carat_082803
Re: Help with Transact SQL
Thanks for your responses. What I was looking for was the Replace functionwhich I eventually found. I never used functions in SQL before so that's whyI wasn't sure.I apologize if I wasn't totally clear.-Frank- Original Message -From: Mahmut Basaran [EMAIL PROTECTED]To: CF-Talk [EMAIL PROTECTED]Sent: Thursday, September 25, 2003 9:41 AMSubject: Re: Help with Transact SQL you can use the following to update all rows at once: update tablename set uri_column = 'http://etc.com/etc' + uri_column - Original Message - From: Frank Mamone [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, September 25, 2003 1:38 AM Subject: Help with Transact SQL Hi, I need help with an update query using transact SQL. I need to modify the data in record set in the following way. The field contains a URL like this: /path1/path2/rest_of_path I need to change it to: http://an_absolute_path/new_path_1/path2/rest_of_path So everything stays the same from path2 on. Thanks in advance for your help. Frank Mamone [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]