Home : Products : Gossamer Links : Discussions :

Products: Gossamer Links: Discussions: Re: [Alex] SQL UPDATE in DOCS: Edit Log

Here is the list of edits for this post
Re: [Alex] SQL UPDATE in DOCS
I have an HTML stripping function: untag() which returns the string passed to it, minus the HTML tags. I wish to pass all the Titles or Descriptions (depending on what the user has selected) through my html stripper function.

I was hoping this could be done with a single update function. But if not, I guess it would have to be a loop of every record.... select, then update.

Code:
if ($option eq 'Title') {
$affected = $ct->update(
{
Title => \"REPLACE('Title','%', untag('%')"
}
);}


http://www.iuni.com/...tware/web/index.html
Links Plugins

Last edited by:

Ian: Jun 17, 2002, 8:33 PM

Edit Log: