[thelist] Interesting SQL Mass update
Rob Smith
rob.smith at THERMON.com
Mon Oct 28 10:47:01 CST 2002
Cool!
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.
</tip>
Rob
-----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
Rob-
Try:
UPDATE tblFoo
SET URL = replace(URL, ' target="_blank"', '')
That'll just remove the target= part and the leading space.
Chris Blessing
webguy at mail.rit.edu
http://www.330i.net
> 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