So you’ve been playing with jQuery for a while now, you’re starting to get the hang of it, and you’re really liking it! Are you ready to take your jQuery knowledge to level two? Today, I’ll demonstrate twenty functions and features you probably haven’t seen before! 1 after() / before() Sometimes you want to insert…
Software Development Life Cycle [SDLC]
video by:Iman Louis music (Technologic) by: Daft Punk illustrations adopted by Mina Isaac from: unknown
How to run ASP on the Mac
I have an old web app that’s using Active Server Pages, and I want to run it on my (Intel) Mac. This is basically not a big deal, because you can simply use Microsoft IIS under Parallels. But I wanted to use IIS only for ASP files, and let Apache handle the rest. And here’s…
Read Text File (.txt) Using JSP / Java
<% BufferedReader input = new BufferedReader(new FileReader(“text2read.txt”)); String line = “”; while ((line = input.readLine()) != null) { out.println(line); } output.flush(); input.close(); %> Source: http://experts.about.com/q/JSP-Java-Server…xt-file-JSP.htm Additional example http://www.jguru.com/forums/view.jsp?EID=536740
Valid styles for converting datetime to string
I wrote this little table and procedure to help me remember what style 104 did, or how to get HH:MM AM/PM out of a DATETIME column. Basically, it populates a table with the valid style numbers, then loops through those, and produces the result (and the syntax for producing that result) for each style, given…
Use CAST (or CONVERT) to handle Null Date values in Microsoft SQL Server
In an SQL Server View, a problem is that the DateTime field has many Null values which is causing a problem with the parsing of the data in MSAccess. How to I use CAST (or CONVERT) to handle Null Date values in my SQL Server view? There is a way to use CAST or CONVERT…
MS SQL Server / SELECT clause with a CASE expression
In SQL Server, if you have a column which has NULLs and instead of nulls, if you want to display ‘Nothing’, what would you do? The following query SELECT CASE Dept_Name WHEN NULL THEN ‘Nothing’ ELSE Dept_Name END Dept_Name FROM Inventory would still display the nulls and not ‘Nothing’. Workaround:
SQL SELECT INTO Statement
The SQL SELECT INTO statement can be used to create backup copies of tables. The SQL SELECT INTO Statement The SELECT INTO statement selects data from one table, creates a new table with the exact structure and size and inserts automatically the selected data into the new table. SQL SELECT INTO Syntax We can select…
JBoss in Action
This book is divided into four parts, containing 15 chapters and two appendices. Chapter 1: The JBoss Application Server If you are using JBoss than you can simply skip Chapter 1. This chapter gets you up and running with JBoss by describing the directories and files that are part of JBoss AS, how to start…
How to create an auto-incrementing column in MS SQL Server 2000
Unlike Microsoft SQL Server 2005 and 2008, MS SQL Server 2000 does not have a ROW_NUMBER() function which applies only to the results of a SELECT query as it doesn’t store any permanent value in the DB. The way it works is in keeping with the principles of relational databases. There is no implict ordering…