November 10, 1999

Variable Length Ordered Lists Using XSL

Question: I’m attempting to create an ordered list every time the Sequence attribute of a Para element has been set to ‘Begin’. The list should continue until it reaches a paragraph with the Sequence attribute set to ‘End’. The problem arises because the and are not being properly matched within

Including XML Element in URL

Question: I have the XML structure: …….. I use this segment in an XSL template to create a list of hyperlinks that take me to the product page where [orderno] needs to be inserted at that point from the orderno element.: How can I insert the orderno element value into

Advantage of Using GET Method in ASP Forms

We all are familiar with disadvantages of GET method when compared to POST method. However, there is a real advantage of using GET when you are creating a link that access CGI scripts. It is easy to retrieve as the data is sent as name value pair at the end

Right Place to Free up Resources

It is always recommend to free all object and variables at the end of a procedure. This can be done using the syntax MyVariable = Nothing. However, you should use this statement to free up resources when your function is done with the variable, and should not wait till at

Performance Tuning in SQL Server 7.0 by Efficient Data Retrieval

Database Programmers using interfaces APIs like ADO, DAO etc. must remain aware of the result sets they are building. One should try to reduce the size of the result set by eliminating columns in the select list that do not have to be returned, or by returning only the required

Construct Proper SQL Queries to Improve Performance

Use of inequality operators in SQL queries force databases to use table scans to evaluate the inequalities. These queries generate high I/O if they run regularly against large tables. You should avoid SQL query that is using expression with NOT in it. If these queries must be run, then restructure

Use Escape Key to Close Your AWT Dialogs

It has become customary for Microsoft Windows users to close an active window by pressing the escape key. It is not that easy to intercept key events in Java. This is because key events go directly to the component having the focus. You can always add your Dialog instance as

Take Care When Using File Based Databases with ASP Environment

When you use Access database or other file based database with Active Server Pages (ASP), you should make sure that the directory in which the database resides is marked as writeable for the user ID used by the IIS process (that is the user ID under which the process is