John Brotherton's blog

Replace SQL

I need your help. I have been tasked with a project of updating Address_1 and Address_2 in the Name_Address table. I found some script that will work but ran into a snag and need some help.

On a test table, I ran the following script to correct an address of 105 Drake Dr

UPDATE tempjohncross
SET Address_1=(
REPLACE (Address_1,
'Dr',
'Drive'));

The script fixed the record as 105 Driveake Drive

Adding Java to ContentArea1

Below is Java Script that my organization would like to add to our website. It is nothing fancy just links to print, post to facebook , email content, etc. I can get this to work in plain html, but fails to work when I put this in WCM editor. Any help would be greatly appreciated.

<!-- AddThis Button BEGIN -->
<div class="addthis_toolbox addthis_default_style ">
<a class="addthis_button_preferred_1"></a>
<a class="addthis_button_preferred_2"></a>
<a class="addthis_button_preferred_3"></a>
<a class="addthis_button_preferred_4"></a>
<a class="addthis_button_compact"></a>
<a class="addthis_counter addthis_bubble_style"></a>
</div>
<script type="text/javascript" src="http://s7.addthis.com/js/250/addthis_widget.js#pubid=xa-4df60b4b7cf5b867"></script>
<!-- AddThis Button END -->

Syndicate content