Search This Blog
Wednesday, December 30, 2009
Saturday, December 26, 2009
Tuesday, December 22, 2009
Friday, December 18, 2009
SQL REPLACE
Update tbl_mytbl
Set [Content]=convert(ntext,REPLACE(convert(varchar(8000),[Content]),'ddd/pdf/','Documents/'))
where Content LIKE '%ddd/pdf/%'
REPLACE for nTEXT datatype
Update mytable
Set [Content]= cast(replace(cast([Content] as nvarchar(max)),'myfolder/pdf/','Documents/') as ntext)
where Content LIKE '%myfolder/pdf/%'
Wednesday, December 16, 2009
TFS Team Foundation Build
Publish website using team build:
http://blogs.msdn.com/nagarajp/archive/2005/10/21/483697.aspx
http://social.msdn.microsoft.com/Forums/en-US/tfsgeneral/thread/bf3da82d-6eda-4f36-9753-b63e98a72909
OTHER":
http://blogs.msdn.com/buckh/archive/2007/08/14/tfs-2008-a-basic-guide-to-team-build-2008.aspx
http://blogs.msdn.com/angelab/archive/2008/03/03/more-how-do-i-videos-for-tfs-2008.aspx
Tuesday, December 15, 2009
Monday, December 14, 2009
URL Rewriting in .NET
Thursday, December 10, 2009
Using relative urls in stylesheets
The urls in the stylesheet are with reference to the css file
http://stackoverflow.com/questions/940451?sort=oldest#sort-top
Wednesday, December 9, 2009
String or binary data would be truncated.
I was getting this error when i was trying to delete some rows from the table.
Monday, December 7, 2009
Use relative paths in Master pages
do the same for js files etc. e.g
<script src="<%=XYZ.ABC.DRR.Settings.SiteStandardRoot%>WebMods/Themes/MyTheme/scripts/AC_RunActiveContent.js" type="text/javascript"></script>Wednesday, December 2, 2009
SMTP setup on Win 2k8 server
http://stackoverflow.com/questions/226655/setting-up-smtp-under-iis-7-on-windows-server-2008
In SMTP server:
- Access tab
- Authentication > Anonymous
- Connections > All except the list below (list is empty)
- Relay > All except the list below (list is empty)
Suppress Javascript errors from showing up
function stoperror()
{ return true; }
window.onerror=stoperror;