Thanks Mark. I'll add this to my SQL snippets library for future use. I'm sure that the client will move the goal posts again.
:0) Dave At 09:33 3/19/2003 +1100, you wrote: > > 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. >Sorry this is a bit late but I think you could have done it in one step with >just an update statement: > >UPDATE content >SET content.content = REPLACE(content.content, 'index.cfm/', >'index.cfm?fuseaction=') > > >There is also a REGEXP function that you can use in conjunction with this if >you ever need to. > >Cheers > >Mark > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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
