Rank: Member
Joined: 1/10/2005(UTC)
Posts: 714
Thanks: 14 times
Was thanked: 1 time(s) in 1 post(s)
|
I have to prefix "<h6>Overview</h6>" to all of my product's long description field. With having over 1500 products, i need an easy wat to do this. suggestions?
|
|
|
|
|
|
Rank: Member
Joined: 8/17/2006(UTC)
Posts: 681
|
Run something like this on your db (not tested not guaranteed)
update bvc_Product
set LongDescription = "<h6>Overview</h6>" + LongDescription
where LongDescription not like "<h6>Overview</h6>%"
This should do it. Make sure you backup, test off-site, bla bla .. so you don't mess up with your db.
Regards,
Corneliu |
|
|
|
|
|
|
Rank: Member
Joined: 1/10/2005(UTC)
Posts: 714
Thanks: 14 times
Was thanked: 1 time(s) in 1 post(s)
|
awsome, ill test it. thanks!
|
|
|
|
|
|
Rank: Member
Joined: 1/10/2005(UTC)
Posts: 714
Thanks: 14 times
Was thanked: 1 time(s) in 1 post(s)
|
I get this error:
Msg 207, Level 16, State 1, Line 3
Invalid column name '<h6>Overview</h6>%'.
|
|
|
|
|
|
Rank: Member
Joined: 12/23/2003(UTC)
Posts: 909
|
Use SQL Find & Replace. Tap Noah @ Resposio. |
|
|
|
|
|
|
Rank: Member
Joined: 1/10/2005(UTC)
Posts: 714
Thanks: 14 times
Was thanked: 1 time(s) in 1 post(s)
|
yeah i've used SQL find and replace and got tons of errors
|
|
|
|
|
|
Rank: Member
Joined: 1/10/2005(UTC)
Posts: 714
Thanks: 14 times
Was thanked: 1 time(s) in 1 post(s)
|
the error was because of the " when it should be '
|
|
|
|
|
|
Rank: Member
Joined: 5/24/2004(UTC)
Posts: 4,147
|
Is this something that would be better done in your product page template, since it's a title heading? Quicker to update, no mass product changes. |
|
|
|
|
|
|
Rank: Member
Joined: 1/10/2005(UTC)
Posts: 714
Thanks: 14 times
Was thanked: 1 time(s) in 1 post(s)
|
its for use with the product tabs. That's the way i have it now is on the page template, but it creates some problems.
The call for the long description puts 2 spans around the long descriptions which creates the problem im having.
|
|
|
|
|
|
Rank: Member
Joined: 1/24/2008(UTC)
Posts: 60
|
Try this: In Product.aspx.vb (Product Template Page Code), search for Code:Me.lblDescription.Text = Me.LocalProduct.LongDescription Replace with Code:Me.lblDescription.Text = "<h6>Overview</h6>" & Me.LocalProduct.LongDescription This will accomplish the same thing as the mass DB replacement, and much easier to modify. Only thing is if the spans are affecting you, this may not help. . . I tried this on my site, and it seemed to work fine though. Hope it helps. |
- Brian Web Developer/IT Manager  |
|
|
|
|
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.