[thelist] Interesting SQL Mass update

Rob Smith rob.smith at THERMON.com
Mon Oct 28 10:47:01 CST 2002


That worked nicely.

Thanks all who've helped me on this one.

<tip type="Good web design" author="Rob.Smith">
If you use splash pages for your websites, please include a some sort of
navigation that's visible and intuitive for the user to understand. No
mystery meat links please.


-----Original Message-----
From: Chris Blessing [mailto:webguy at mail.rit.edu]
Sent: Monday, October 28, 2002 10:41 AM
To: thelist at lists.evolt.org
Subject: RE: [thelist] Interesting SQL Mass update



SET URL = replace(URL, ' target="_blank"', '')

That'll just remove the target= part and the leading space.

Chris Blessing
webguy at mail.rit.edu

> Hi Jay,
> I asked for that. Perhaps I should refine my problem. The URL links are
> different for most fields (*.dbo.ProductMedia). From the UPDATE query you
> listed, wouldn't that update all to be 1. I just want to extract a part of
> the string from inside different and not alike strings.
> Rob

For unsubscribe and other options, including
the Tip Harvester and archive of thelist go to:
http://lists.evolt.org Workers of the Web, evolt !

More information about the thelist mailing list