You are here:   Details View
Register   |  Login
Easy Search and Replace for HTMLText in DotNetNuke
Easy Search and Replace for HTMLText in DotNetNuke
By xfernal on Aug 24, 2010 07:23 PM • Rank (1397) • Views 1395
Share This  Retweet  
0

0

I keep seeing people post these long SQL Scripts for replacing the nText within the Text/HTML module in DotNetNuke. I was probably guilty of writing a long SQL script like that before, so here is a quick and dirty way to do it:

Select Cast(Replace(Cast(Content as nvarchar(max)), 'wordtofind', 'wordtoreplace') as ntext) from HTMLText

Map Location

GPS Latitude: 35.77975 Longitude: -78.64341
Visitors
Top User:  
Total Check-Ins: 2
Unique Visitors: 2
My Check-Ins: 0
      
Comments (1) - Comment RSS
SusanaFernandes wrote: on Nov 10, 2010 06:52 AM
estou a fazer testes
Permalink | Report Abuse
Socialize



Who Viewed
Who Reviewed
Shortened URL
http://tinyurl.com/2af6q38

What is I'm Vivo!™ ?

Vivo is the Italian word for alive. Therefore, "I’m Vivo!" means "I’m Alive!" As a user and as a community, you decide if a piece of information will live or die. I’m Vivo! is changing how people discover information and bring it to life! » Learn more
» Submit an audio/podcast, business, feed, image, news, or video!