Hi, sorry for the slightly OT post.
I have a mysql db with a table containing html content. I have links in the content like this: index.cfm/welcome.content/cmid=2 What I want to do is find all the links that have index.cfm/ and replace them with index.cfm?fuseaction= I also want to replace the '/' after the .content so that this: welcome.content/cmid=2 becomes welcome.content&cmid=2 In the end I want a url like this: index.cfm?fuseaction=welcome.content&cmid=2 Is there anyway to do this directly within a query? I don't have access via command line and can only do it using the SQL builder in CF studio. Any help would be great. Cheers Dave ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=14 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=14 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.14
