> 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 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
