> > 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 Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.14
