<< Drunktender v2.0 progress | Home | Why porting data to a new system is a pain >>
I'm smrt, seriously ...
posted on Wednesday, November 07, 2007 11:41 PM |

So I'm writing my updater app to fix the image problem I outlined and saw I actually have a problem with the SQL I wrote anyways.  The replace error on an Ntext datatype would still happen, but even if that error wouldn't happen, another problem would have happened.

The problem of nothing actually happening.  I was replacing the same string with itself.  I needed the /image/ to reset the image tag back to the domain root.

The code SHOULD be:

begin tran
Update     subtext_Content
    Set    [text] = replace([text], '<img src="images/', '<img src="/images/')

select * from subtext_Content where [text] like '%<img src="images/%'
Tags [ General ]

Your Comments.

  • # 

    Love the idea, you still need to dig deeper on the google API though, as the same search on google sometimes shows totally different results!!!

    Why hasn't a major search company done something like this before???

    Left by Robin Jones at 10/25/2007 11:10 AM
  • # 

    This breaks if searching for "c#"

    Left by konks. at 10/26/2007 9:10 AM
Post Comment
Title *
Name *
Email
Url
Comment *  
Please add 3 and 6 and type the answer here:
Friends
Microsoft
Archives
Post Categories