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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.14
