How to disable Windows and Windows programs sounds
April 12th, 2010
The sounds in Microsoft Windows and the sound in many of the Microsoft Windows programs such as Internet Explorer, MSN, Instant Windows Messenger, NetMeeting, etc. is all controlled through the sound properties in Control Panel. To adjust these settings follow the below steps.
Click Start, Settings, and Control Panel.
In Control Panel double-click the Sound and Audio Devices icon.
Within the Sound and Audio Devices Properties window locate the sound you wish to… Continue reading
Granting execute permissions to all stored procedures in a database for MSSQL
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…
How to set CLASSPATH in Linux
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
java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver
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
How does tracking in email work?
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
Adding a watermark to original images on the fly
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
How to charge clients?
February 28th, 2010
Trying to work out how much you're worth charging for web development work? I this question come up on a forum - here's my comments on the subject:
How many pages? If it's 3-5 pages, no worries there's no point charging this. If they want 30-40 pages and expect you to do it all - charge them! Now days CMS's are more common, so the client will do the pages themselves… Continue reading
Query of Queries
February 28th, 2010
Query of Queries (QoQ) is great little concept, for a while I never knew when I would ever use this up until a few months ago. Web services generally return strings, but more commonly xml. Then you have some minority that return query results. This is where QoQs work perfect, check out the code snippet below:
// Let's say qryResults has 4 columns - (Name, Address, Phone, Email)
SELECT Name, Address, Phone… Continue reading
I/O Error: Cannot run program “javac”: CreateProcess error=2
February 24th, 2010
Ever got this error while building a BB JDE (BlackBerry Java Development Environment) Project?
Building
C:\Program Files\Research In Motion\BlackBerry JDE 4.3.0\bin\rapc.exe -quiet import="..\..\..\..\..\Program Files\Research In Motion\BlackBerry JDE 4.3.0\lib\net_rim_api.jar" codename= .rapc warnkey=0x52424200;0x52525400;0x52435200 C:\\.java
I/O Error: Cannot run program "javac": CreateProcess error=2, The system cannot find the file specified
Error while building project
First check that you have JDK properly installed on your computer. Go to Control Panel -> Add/Remove Programs.
If all that's sweet -… Continue reading
Creating a Blackberry Launcher
February 20th, 2010
I found this great article on how to create your own blackberry launcher to open a web page. Check out this article: http://crackberry.com/how-create-blackberry-launcher…