Archive for March, 2010

Granting execute permissions to all stored procedures in a database for MSSQL

Wednesday, March 24th, 2010
I had this problem today when coding up an application that uses stored procedures to operate tasks. Most database admins like keeping their security locked down. So here's a way to allow execute stored procedure commands while keeping basic reader/writer permissions. SQL2005 /* CREATE A NEW ROLE */ CREATE ROLE db_executor /* GRANT EXECUTE TO THE ROLE */ GRANT EXECUTE TO db_executor…
  • Share/Bookmark

How to set CLASSPATH in Linux

Wednesday, March 24th, 2010
Below are two types of commands to set CLASSPATH in linux. There's a few different types of shells to execute this command below explains how to work out the difference. The syntax for setting your classpath is slightly dependent on which shell you are using. The default shell for RedHat 5.x and 6.x is the bash shell. Two other popular shells are tcsh and and csh called "t shell" and "c… Continue reading
  • Share/Bookmark

java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver

Tuesday, March 23rd, 2010
Had this error come up while building a java app. Common problem when trying to connect to mssql database. Install the Microsoft SQL Server JDBC Driver and extract it to somewhere useful like C:\Program Files\... Add the following path to the System variables in your Environment Variables for Windows (My Computer > Properties) C:\Program Files\Microsoft SQL Server 2005 JDBC Driver\sqljdbc_1.2\enu\sqljdbc.jar This should work... If you're using an IDE - you'll need to add the CLASSPATH into the… Continue reading
  • Share/Bookmark

How does tracking in email work?

Tuesday, March 2nd, 2010
Had a great question from a customer this morning, about how tracking in emails work. I did some digging around and found some pretty interesting stuff that even I didn't know about. In emails an invisible graphic is included at the bottom of HTML emails which are known as web beacons. Each time someone opens the unique graphic it returns the information back to the server monitoring your email campaigns and… Continue reading
  • Share/Bookmark

Adding a watermark to original images on the fly

Monday, March 1st, 2010
Found this great piece of code that will allow you to prevent users or atleast stop them a little... from downloading your images. Using the cfimage tag! Simply use cfimage to call you're first two images, then using ImagePaste() to mash them together, and write to the browser calling '#image#'. See how you go. <cfimage source=”img_2566.jpg” name=”image”> <cfimage source=”watermark.png” name=”watermark”> <cfset ImagePaste(image, watermark… Continue reading
  • Share/Bookmark