Sorted!! I simply did the SELECT REPLACE () AS newContent then an UPDATE query using the newContent. Loop through the contentid from 1 to 80 on an index loop.
All links changed in about 12.5 secs. Certainly beats finding and editing manually!! Cheers for the help. Dave At 14:16 3/18/2003 +0000, you wrote: >Yep. I want to update all the links in the content table to have >fuseaction= in them. > >Could it be that I needed to specify the AS foo bit of the query. > >Do I need to do it as an update query? > >Cheers > >Dave > >At 14:06 3/18/2003 +0000, you wrote: > > > > > > I ran the following query: > > > > > > SELECT REPLACE(content.content, 'index.cfm/', 'index.cfm?fuseaction=') > > > FROM content > > > WHERE contentid = 34 > > > > > > All this returns is the content field but does change the actual text. > > > > >I assume you meant "doesn't"... If you did then that's weird, cos I've just > >tried a similar thing on one of my databases and it seemed to work fine.... > > > >SELECT Replace(Content,"specification","lies") AS NewHeadline > >FROM tblnews > > > > > Any ideas. Can I do it via CF as in do a select on each content record, > > > replace the bits using Replace() then update those records with the > >changes? > > > > >So do you actually want to update the database?? > > > >Regards > > > >Stephen > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=14 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=14 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.14
