November 17, 2001

Use ASP Include Files for Database Connectivity

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,

How to Void a Cookie and Delete it from the Browser

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

IIF Command in SQL Server

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

Use ASP in your .js, .vb, and .css Files

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

String Comparing

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.