One of the clients that I, Yan Huang, have been working with to migrate from static Dreamweaver generated pages to the Sungard EXP Web CMS needs their datasheets to show under the Admin interface.  It won’t show up unless it is within EXP Web’s subdirectories, so we moved the datasheets to menus/datasheets directory.  However, there are hundreds of links in the content that will have to be manually changed if we do not do it systematically.  My initial idea was to do use IIS’s version of Mod_rewrite (Apache) to internally redirect ../datasheets/file.pdf to ../menu/datasheets/file.pdf, however that plan was tossed out when we realized with our server’s configurations does not allow rewriting of .pdf files.  Crockett suggested going through the HTML content table and doing a replace with SQL so we proceeded with that.  The query we ran seemed simple enough but it completely messed up the HTML tables code!  Thank goodness we backed up that table…phew!  When we did not have [”] in the WHERE clause, all the attributes in the table rows and table definitions were stripped out.  When we did include it, it distorted many of the cells in the tables.  We restored the table that we backed up and now hopefully, a better way to implement this will occur to either me (Yan Huang) or Crockett.

MS SQL Select query (left), MS SQL Update query (right)