How to update Text Column in Sql server if that column contains HTML content.

Question

How to update Text Column in Sql server if that column contains HTML content.

ralahari

Old Hand

Points: 301
More actions
March 6, 2014 at 3:08 am

#304965

In My Database content column, I am having below content.
In this content I need to update ".anythingSlider .forward" Css class
Can u guys please guide me on this.

<link href="jquery-ui-1.8.1.custom.css" rel="stylesheet" type="text/css" />
<link href="hdvlink.css" rel="stylesheet" type="text/css" />
<script type="text/javascript">
// Slider Controls
alert('Start');
function formatText(index, panel) {
return index + "";
}
$(function () {
$('.anythingSlider').anythingSlider({
easing: "easeInOutExpo", // Anything other than "linear" or "swing" requires the easing plugin
autoPlay: true, // This turns off the entire FUNCTIONALY, not just if it starts running or not.
delay: 14000000, // How long between slide transitions in AutoPlay mode
startStopped: true, // If autoPlay is on, this can force it to start stopped
animationTime: 1000, // How long the slide transition takes
hashTags: true, // Should links change the hashtag in the URL?
buildNavigation: false, // If true, builds and list of anchor links to link to each slide
pauseOnHover: true, // If true, and autoPlay is enabled, the show will pause on hover
startText: "", // Start text
stopText: "", // Stop text
navigationFormatter: formatText // Details at the top of the file on this use (advanced use)
});
$("#slide-jump").click(function(){
$('.anythingSlider').anythingSlider(6);
});
});
/*
anythingSlider v1.2
By Chris Coyier: http://css-tricks.com
with major improvements by Doug Neiner: http://pixelgraphics.us/
based on work by Remy Sharp: http://jqueryfordesigners.com/
To use the navigationFormatter function, you must have a function that
accepts two paramaters, and returns a string of HTML text.
index = integer index (1 based);
panel = jQuery wrapped LI item this tab references
@return = Must return a string of HTML/Text
navigationFormatter: function(index, panel){
return index + " Panel"; // This would have each tab with the text 'X Panel' where X = index
}
*/
(function($){
$.anythingSlider = function(el, options){
// To avoid scope issues, use 'base' instead of 'this'
// to reference this class from internal events and functions.
var base = this;
// Access to jQuery and DOM versions of element
base.$el = $(el);
base.el = el;
alert(base);
// Set up a few defaults
base.currentPage = 1;
base.timer = null;
base.playing = false;
// Add a reverse reference to the DOM object
base.$el.data("AnythingSlider", base);
base.init = function(){
base.options = $.extend({},$.anythingSlider.defaults, options);
// Cache existing DOM elements for later
base.$wrapper = base.$el.find('> div').css('overflow', 'hidden');
base.$slider = base.$wrapper.find('> ul');
base.$items = base.$slider.find('> li');
base.$single = base.$items.filter(':first');
// Build the navigation if needed
if(base.options.buildNavigation) base.buildNavigation();
// Get the details
base.singleWidth = base.$single.outerWidth();
base.pages = base.$items.length;
// Top and tail the list with 'visible' number of items, top has the last section, and tail has the first
// This supports the "infinite" scrolling
base.$items.filter(':first').before(base.$items.filter(':last').clone().addClass('cloned'));
base.$items.filter(':last' ).after(base.$items.filter(':first').clone().addClass('cloned'));
// We just added two items, time to re-cache the list
base.$items = base.$slider.find('> li'); // reselect
// Setup our forward/backward navigation
base.buildNextBackButtons();
// If autoPlay functionality is included, then initialize the settings
if(base.options.autoPlay) {
base.playing = !base.options.startStopped; // Sets the playing variable to false if startStopped is true
base.buildAutoPlay();
};
// If pauseOnHover then add hover effects
if(base.options.pauseOnHover) {
base.$el.hover(function(){
base.clearTimer();
}, function(){
base.startStop(base.playing);
});
}
// If a hash can not be used to trigger the plugin, then go to page 1
if((base.options.hashTags == true && !base.gotoHash()) || base.options.hashTags == false){
base.setCurrentPage(1);
};
};
base.gotoPage = function(page, autoplay){
// When autoplay isn't passed, we stop the timer
if(autoplay !== true) autoplay = false;
if(!autoplay) base.startStop(false);
if(typeof(page) == "undefined" || page == null) {
page = 1;
base.setCurrentPage(1);
};
// Just check for bounds
if(page > base.pages + 1) page = base.pages;
if(page < 0 ) page = 1;
var dir = page < base.currentPage ? -1 : 1,
n = Math.abs(base.currentPage - page),
left = base.singleWidth * dir * n;
base.$wrapper.filter(':not(:animated)').animate({
scrollLeft : '+=' + left
}, base.options.animationTime, base.options.easing, function () {
if (page == 0) {
base.$wrapper.scrollLeft(base.singleWidth * base.pages);
page = base.pages;
} else if (page > base.pages) {
base.$wrapper.scrollLeft(base.singleWidth);
// reset back to start position
page = 1;
};
base.setCurrentPage(page);
});
};
base.setCurrentPage = function(page, move){
// Set visual
if(base.options.buildNavigation){
base.$nav.find('.cur').removeClass('cur');
$(base.$navLinks[page - 1]).addClass('cur');
};
// Only change left if move does not equal false
if(move !== false) base.$wrapper.scrollLeft(base.singleWidth * page);
// Update local variable
base.currentPage = page;
};
base.goForward = function(autoplay){
if(autoplay !== true) autoplay = false;
base.gotoPage(base.currentPage + 1, autoplay);
};
base.goBack = function(){
base.gotoPage(base.currentPage - 1);
};
// This method tries to find a hash that matches panel-X
// If found, it tries to find a matching item
// If that is found as well, then that item starts visible
base.gotoHash = function(){
if(/^#?panel-\d+$/.test(window.location.hash)){
var index = parseInt(window.location.hash.substr(7));
var $item = base.$items.filter(':eq(' + index + ')');
if($item.length != 0){
base.setCurrentPage(index);
return true;
};
};
return false; // A item wasn't found;
};
// Creates the numbered navigation links
base.buildNavigation = function(){
base.$nav = $("<div id='thumbNav'></div>").appendTo(base.$el);
base.$items.each(function(i,el){
var index = i + 1;
var $a = $("<a href='#'></a>");
// If a formatter function is present, use it
if( typeof(base.options.navigationFormatter) == "function"){
$a.html(base.options.navigationFormatter(index, $(this)));
} else {
$a.text(index);
}
$a.click(function(e){
base.gotoPage(index);
if (base.options.hashTags)
base.setHash('panel-' + index);
e.preventDefault();
});
base.$nav.append($a);
});
base.$navLinks = base.$nav.find('> a');
};
// Creates the Forward/Backward buttons
base.buildNextBackButtons = function(){
alert('Alahari');
var $forward = $('<a class="arrow forward">></a>'),
$back = $('<a class="arrow back"><</a>');
// Bind to the forward and back buttons
$back.click(function(e){
base.goBack();
e.preventDefault();
});
$forward.click(function(e){
base.goForward();
e.preventDefault();
});
// Append elements to page
base.$wrapper.after($back).after($forward);
};
// Creates the Start/Stop button
base.buildAutoPlay = function(){
base.$startStop = $("<a href='#' id='start-stop'></a>").html(base.playing ? base.options.stopText : base.options.startText);
base.$el.append(base.$startStop);
base.$startStop.click(function(e){
base.startStop(!base.playing);
e.preventDefault();
});
// Use the same setting, but trigger the start;
base.startStop(base.playing);
};
// Handles stopping and playing the slideshow
// Pass startStop(false) to stop and startStop(true) to play
base.startStop = function(playing){
if(playing !== true) playing = false; // Default if not supplied is false
// Update variable
base.playing = playing;
// Toggle playing and text
if(base.options.autoPlay) base.$startStop.addClass("playing");
if(playing){
base.clearTimer(); // Just in case this was triggered twice in a row
base.timer = window.setInterval(function(){
base.goForward(true);
}, base.options.delay);
} else {
base.clearTimer();
base.$startStop.removeClass("playing");
};
};
base.clearTimer = function(){
// Clear the timer only if it is set
if(base.timer) window.clearInterval(base.timer);
};
// Taken from AJAXY jquery.history Plugin
base.setHash = function ( hash ) {
// Write hash
if ( typeof window.location.hash !== 'undefined' ) {
if ( window.location.hash !== hash ) {
window.location.hash = hash;
};
} else if ( location.hash !== hash ) {
location.hash = hash;
};
// Done
return hash;
};
// <-- End AJAXY code
// Trigger the initialization
base.init();
};
$.anythingSlider.defaults = {
easing: "swing", // Anything other than "linear" or "swing" requires the easing plugin
autoPlay: true, // This turns off the entire FUNCTIONALY, not just if it starts running or not
startStopped: false, // If autoPlay is on, this can force it to start stopped
delay: 3000, // How long between slide transitions in AutoPlay mode
animationTime: 600, // How long the slide transition takes
hashTags: true, // Should links change the hashtag in the URL?
buildNavigation: true, // If true, builds and list of anchor links to link to each slide
pauseOnHover: true, // If true, and autoPlay is enabled, the show will pause on hover
startText: "Start", // Start text
stopText: "Stop", // Stop text
navigationFormatter: null // Details at the top of the file on this use (advanced use)
};
$.fn.anythingSlider = function(options){
if(typeof(options) == "object"){
return this.each(function(i){
(new $.anythingSlider(this, options));
// This plugin supports multiple instances, but only one can support hash-tag support
// This disables hash-tags on all items but the first one
options.hashTags = false;
});
} else if (typeof(options) == "number") {
return this.each(function(i){
var anySlide = $(this).data('AnythingSlider');
if(anySlide){
anySlide.gotoPage(options);
}
});
}
};
})(jQuery);
</script>
<style type="text/css">
table.table1 {width:755px;height:auto;padding:1px;border:2px solid #e0e0e0;border-bottom: 4px solid #ccc;-webkit-border-radius: 2px;-moz-border-radius: 2px;border-radius: 2px;}
.table1 tr {padding:0px;margin:0px;}
.table1 th {background-color:#E0E0E0;border:1px solid #e0e0e0;clear:both;font-size:0.95em;}
.table1 td {border:1px solid #e0e0e0;text-align:left;clear:both;font-size:0.85em;height:40px;}
.anythingSlider{width:755px; height:730px; background-color:#fff no-repeat top left;}
.anythingSlider .wrapper{width:755px; overflow:hidden; height:690px;overflow:hidden}
.anythingSlider .wrapper ul{width:9999px; list-style:none; margin:0;}
.anythingSlider ul li{display:block; float:left; padding:0; width:755px; margin:0;}
.anythingSlider .arrow, .forward {display: -moz-inline-box; display: inline-block; font-size: 60px; height: 0; position:relative; line-height: 0; vertical-align: middle; width: 0;}
.anythingSlider .arrow{display:block; height:16px; width:16px; text-indent:-9999px; cursor:pointer;}
.anythingSlider .forward{background-position:0; background:#404040; width: 0;height: 0;border-top: 11px solid transparent;border-bottom: 11px solid transparent;border-left: 11px solid ;margin:-730px 0 0 50px;} 
.anythingSlider .back{background-position:0; background:#404040;width: 0; height: 0;border-top: 11px solid transparent;border-bottom: 11px solid transparent; border-right:11px solid;margin:-730px 0 0 -60px;} 
.anythingSlider .forward:hover{background-position:-66px -22px;background-color:#333333;}
.anythingSlider .back:hover{background-position:-44px -22px;background-color:#333333;}
#start-stop{display:block; height:22px; width:22px; border:none; text-indent:-9999px; cursor:pointer;background:#404040;margin:-730px 0 0 20px;} 
#start-stop:hover{background-position:0 -22px;}
#start-stop.playing{background-position:-22px 0;}
#start-stop.playing:hover{background-position: -22px -22px;background-color:#FF0000;}
p:before { content:"\00b7";font-size:0.65em; }
</style>

<p style="padding-left:70px;">Use the arrows at the top of the page to see other months.</p>
<div class="anythingSlider">
<div class="wrapper">
<ul>








<li>
<table class="standard_table table1">
<colgroup span="7">
<col width="108">
<col width="108">
<col width="107">
<col width="108">
<col width="107">
<col width="108">
<col width="108">
</colgroup>
<thead>
<tr>
<th colspan="7">August 2013</th>
</tr>
</thead>
<tr>
<th>Sunday</th>
<th>Monday</th>
<th>Tuesday</th>
<th>Wednesday</th>
<th>Thursday</th>
<th>Friday</th>
<th>Saturday</th>
</tr>
<tr>
<td></td>
<td></td>
<td></td>
<td></td>
<td>1</td>
<td>2</td>
<td>3</td>
</tr>
<tr>
<td>4</td>
<td>5</td>
<td>6</td>
<td>7<br />
[imageStart]36923[imageEnd] Checks Mailed</td>
<td>8<br />
[imageStart]36923[imageEnd] Direct Deposit, Statements on HDVLink</td>
<td>9</td>
<td>10</td>
</tr>
<tr>
<td>11</td>
<td>12</td>
<td>13</td>
<td>14<br />
<a href="/c/105403__.aspx">Variable Annuity Conference Call</a></td>
<td>15<br />
<strong>End of Period</strong></td>
<td>16</td>
<td>17</td>
</tr>
<tr>
<td>18</td>
<td>19</td>
<td>20</td>
<td>21<br />
<a href="/c/107797__.aspx">Retirement Services Call</a></td>
<td>22<br />
[imageStart]36923[imageEnd] Checks Mailed</td>
<td>23<br />
[imageStart]36923[imageEnd] Direct Deposit, Statements on HDVLink<br/>
<a href="/c/107875_.aspx">August Scheduled Maintenance</a></td>
<td>24<br/>
<a href="/c/107875_.aspx">August Scheduled Maintenance</a></td>
</tr>
<tr>
<td>25</td>
<td>26</td>
<td>27</td>
<td>28</td>
<td>29</td>
<td>30<br />
<strong>End of Period</strong></td>
<td>31</td>
</tr>
<tr></tr>
</table>
</li>


<li>
<table class="standard_table table1">
<colgroup span="7">
<col width="108">
<col width="108">
<col width="107">
<col width="108">
<col width="107">
<col width="108">
<col width="108">
</colgroup>
<thead>
<tr>
<th colspan="7">September 2013</th>
</tr>
</thead>
<tr>
<th>Sunday</th>
<th>Monday</th>
<th>Tuesday</th>
<th>Wednesday</th>
<th>Thursday</th>
<th>Friday</th>
<th>Saturday</th>
</tr>
<tr>
<td>1</td>
<td>2</td>
<td>3</td>
<td>4</td>
<td>5</td>
<td>6</td>
<td>7</td>
</tr>
<tr>
<td>8</td>
<td>9<br />
[imageStart]36923[imageEnd] Checks Mailed</td>
<td>10<br />
[imageStart]36923[imageEnd] Direct Deposit, Statements on HDVLink</td>
<td>11<br />
<a href="/c/105403__.aspx">Variable Annuity Conference Call</a></td>
<td>12</td>
<td>13<br />
<strong>End of Period</strong></td>
<td>14</td>
</tr>
<tr>
<td>15</td>
<td>16</td>
<td>17</td>
<td>18</td>
<td>19</td>
<td>20<br />
[imageStart]36923[imageEnd] Checks Mailed</td>
<td>21</td>
</tr>
<tr>
<td>22</td>
<td>23<br />
[imageStart]36923[imageEnd] Direct Deposit, Statements on HDVLink</td>
<td>24</td>
<td>25</td>
<td>26</td>
<td>27</td>
<td>28</td>
</tr>
<tr>
<td>29</td>
<td>30<br />
<strong>End of Period</strong></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr></tr>
</table>
</li>


<li>
<table class="standard_table table1">
<colgroup span="7">
<col width="108">
<col width="108">
<col width="107">
<col width="108">
<col width="107">
<col width="108">
<col width="108">
</colgroup>
<thead>
<tr>
<th colspan="7">October 2013</th>
</tr>
</thead>
<tr>
<th>Sunday</th>
<th>Monday</th>
<th>Tuesday</th>
<th>Wednesday</th>
<th>Thursday</th>
<th>Friday</th>
<th>Saturday</th>
</tr>
<tr>
<td></td>
<td></td>
<td>1</td>
<td>2</td>
<td>3</td>
<td>4</td>
<td>5</td>
</tr>
<tr>
<td>6</td>
<td>7<br />
[imageStart]36923[imageEnd] Checks Mailed</td>
<td>8<br />
[imageStart]36923[imageEnd] Direct Deposit, Statements on HDVLink</td>
<td>9<br />
<a href="/c/105403__.aspx">Variable Annuity Conference Call</a></td>
<td>10</td>
<td>11</td>
<td>12</td>
</tr>
<tr>
<td>13</td>
<td>14</td>
<td>15<br />
<strong>End of Period</strong></td>
<td>16</td>
<td>17<br />
• <a href="/c/105516__.aspx">Advisory Quarterly Conference Calls</a> [10 a.m. CT]</td>
<td>18</td>
<td>19</td>
</tr>
<tr>
<td>20</td>
<td>21</td>
<td>22<br />
[imageStart]36923[imageEnd] Checks Mailed</td>
<td>23<br />
[imageStart]36923[imageEnd] Direct Deposit, Statements on HDVLink</td>
<td>24</td>
<td>25</td>
<td>26</td>
</tr>
<tr>
<td>27</td>
<td>28</td>
<td>29</td>
<td>30</td>
<td>31<br />
<strong>End of Period</strong></td>
<td></td>
<td></td>
</tr>
<tr></tr>
</table>
</li>



</ul>
</div>
</div>
<br />
12013-08-23 08:56:02.390NULL0140NULLNULLNULLNULLNULLGeneral InformationPublishedNULLNULLNULLNULL0123NULLNULLNULLNULLwebpage.gifwebpage2013-08-23 08:56:45.023NULLNULLNULLNULLNULLNULLNULL13HDVEST_All

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

HanShi SSC-Dedicated Points: 33513 More actions · Answer 1

You can CAST the column with datatype NTEXT to a NVARCHAR(MAX) datatype. Next you can do a replace on that column. Something like:

select replace(cast(value as nvarchar(max)), 'string_to_find', 'replacement_string')

** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

ralahari Old Hand Points: 301 More actions · Answer 2

Thanks for the replay.

I have one more issue.

I want to insert new style in that html.

can you guys please guide me on the same.

How to update Text Column in Sql server if that column contains HTML content.

Cookies on SQLServerCentral