If you want to try to keep your application standards compliant try this application: Mimer ValidatorIt lets you test any SQL query for SQL-92 and SQL-99 compliance. If you do

To avoid repeating the following lines of code in every ASP page that needs a database connection: {Dim connObjSet connObj = Server.CreateObject(“ADODB.Connection”)connObj.ConnectionString = Session(“ConnectionString”)connObj.Open} You can use an include file,

You can specify an expiration date, using the setMaxTime(int) method of javax.servlet.http.Cookie. Specifying an expiration time of zero will void the cookie, and delete it from the browser. // Expire

The ProductMaster Table is in MSAccess and the productdescription Table is in SQLServer. Create the Example.mdb in C drive and Create the Below table in MDB(MSAccess). ProductMaster(MSAccess)———————–pid ProductName1 maruthi2 MercedesBenz3

By default, cookies are accessible to every HTTP request for the current directory, and any subdirectories. On most Web servers and servlet engines, servlets are located in a special directory.

There is no “IIF” function in SQLSERVER as of VB and Access.For example, say you had a table like this: StudID Subject Marks—— —— ——1 Maths 801 Physics 751 Chemistry

Open Internet Services Manager from the Administrative Tools group.Right-click on your server and select properties. From Master Properties choose WWW Services and click the “Edit…” button. Select the HomeDirectory, and

Suppose that you have the following code: String strObj; if(strObj != null) if(strObj.equals(“something”)){ // } You can use instead “something”.equals(strObj), so you don’t have to test if strObj is null.

You probably know that there are basically two methods to search a value in an array: the brute force approach (i.e. linear searching) and the binary search. Both of them

Oftentimes, we need to convert ResultSets to XML for transferring data across different applications. Here is very simple code that transforms ResultSets into XML. import java.sql.*;import java.io.*;public class XMLWriter{ public

This is a piece of my actual code. It’s rather self-explanatory. public static String quote(String symbol) { try { java.net.URL url = new java.net.URL( “http://quotes.nasdaq.com/quote.dll?page=_xml&mode=stock&symbol=” + symbol); com.borland.xml.XmlData data =

When automating Outlook from a VB application, I needed to find a way to transfer data from a RichTextBox control to an Outlook message. Unfortunately using Clipboard.SetText and Clipboard.GetText did

There is a simple way to test if a character in a string is a letter.Just by using the UCase() And LCase() functions. Public Function IsLetter(Char As String) As Boolean

When you want to send an integer through the socket from a Java application to a C application, or your Java application needs to save some integer in the file

I have created a generic function for changing the key for an object in a collection: ‘Module: Module1 Option Explicit Public Function ChangeKey(Object As Object, NewKey As String, Collection As

If you are loading Multiple ComboBoxes or ListBoxes from the same recordset, a fast way to do this is to only loop the recordset once.Here is a generic function that

The fastest way to clear a collection is just to set the variable to a new Collection object. However, if it’s necessary to free the references the collection is keeping,

You cannot make a separate location to assign one object to another. By implementing a Cloneable interface and calling the clone() method, you can make a separate location for the

This code will return the date of the next weekday that you specify.For example, assuming today is July 4th, 2001 and you need to know the date for next Monday,

SQL Server, and the SQL language in general, doesn’t support record numbers, so you can’t extract a set of records if you know their position in the resultset. This missing

CountSort is yet another sort algorithm, which can be applied only under very particular conditions but that, when such conditions are met, turns to be the fastest of the lot.

Private Declare Function RealizePalette Lib “gdi32″ (ByVal hdc As Long) As Long’ Paint a circular gradient” STARTCOLOR is the starting color (applied to the corner)’ ENDCOLOR is the ending color

‘ Retrieve the number of bytes by all the files in a directory’ (it doesn’t account for slack space, that is unused space in disk sectors)” If INCLUDESUBDIRS is true,

Private Declare Function RealizePalette Lib “gdi32″ (ByVal hdc As Long) As Long’ Paint a vertical gradient” STARTCOLOR is the starting color (applied to top border)’ ENDCOLOR is the ending color

Private Declare Function RealizePalette Lib “gdi32″ (ByVal hdc As Long) As Long’ Paint an horizontal gradient” STARTCOLOR is the starting color (applied to left border)’ ENDCOLOR is the ending color