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]
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
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
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:138371 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