[thelist] Interesting SQL Mass update

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


SQL Server 7/2000

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


Rob-

Are you talking Access or SQL Server or MySQL?

Also, as Jay noted, are all the URLs the same or do the differ?

Chris Blessing
webguy at mail.rit.edu
http://www.330i.net

> Hi list,
>
> sorry about that last email.. wrong button
>
> I've got a small table, about 1000 rows or so, and some of the
> columns have
> something like this in it:
> <a href="../links/page1.html" target="_blank">
>
> I want to remove the 'target="_blank"' part of the string. Is
> there a way to
> do this mass update in SQL? I could probably do in ASP, but don't want to
> have to resort to that - time.
>
> Thanks in advance,
>
> Rob.Smith
--
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