You can mark an ASP page with a transaction support property, just as you can do with a registered MTS component. An ASP scripting object thus can serve either as

Question: I’m having a problem writing a SELECT statement that will compares a date stored in a table against the current time. This is for a calendar on a Web

Question: I am using Exchange Server 5.5 and Outlook 97 on about 30 workstations. I use a public folder to store shared contact info. On all but two of the

Question: In Microsoft Access you can use a query as the source for a select in a second query. Additionally, you can use two queries as the source by utilizing

Question: I have a Visual Basic project about a video store, for which I have to produce a report that includes the following: Top 10 movies last month Number of

Question: I have a Web page that lets the user query my database and return results in groups of 50 records. I know how to do the first SQL statement

Question: How do you list available tables and their schemas from an SQL query? Answer: There is an owner in the database called INFORMATION_SCHEMA who has a bunch of objects

Question: How do I convert a character string into a time field? Data is being read in as 12:10 and I need to calculate response times based on this field.

Question: If I just want to see some data from a table, is there some SQL syntax to prevent 2 million rows from coming back without adding conditions on the

Question: Could you please give me a simple explanation to what stacks are? How do they work and what are their related features? Answer: Stacks are temporary resting places for

Question: I have a table below: Name idJohn 40Mary 50Peter 15John 40Peter 15John 40 How can I query to get who appeared most of the times in the table? (In

Question: I can’t remember the reason for the efficiency of the SQL query. I thought that the results of the query are sent to a “client,” as opposed to the

Question: I am writing a Visual Basic app that is all about a database created in Access 97 with about 500 records. I want to be able to filter things,

Question: Is there a “best” way to design VB/ASP apps to deal with SQL (7.0) security? For example, in a WAN environment and a Web application where the app needs

Question: Microsoft naming conventions for Visual Basic (Hungarian notation) is well documented and widely used. Is there a similar/well-known standard for variables used in SQL Server stored procedures? Answer: Not

Question: The Enterprise Manager (or whatever it’s called now) shows all the systems tables when you navigate down to the tables in a database. How do you hide the system

Question: I have a statement to submit a form: This JavaScript will validate entries in different textboxes placed on the form: FormCheck(this.form, ”, ”) When the user clicks the enter

Question: I recently bought a book that includes the XML specification as well as some commentary. Much to my surprise, I found that after authoring an XML document, the browser

Question: Does using the recordset.filter variable slow down response time greatly? For example: rsObj.filter = “sCat = 1” I am using it to filter my recordset object so that I

You can increase the speed of download by reducing the number of bits each page needs to be displayed. One way to shrink the download size is to reuse components

ASP strips out white space between the closing delimiter of a statement and the opening delimiter of the following statement. If there is a need to preserve the white space

If an IIS application needs to rely on the session state, then you should try to avoid putting large data in the session object and session states. Session tracking maintains

The Java servlet below demonstrates how to use compressed output fromservlets. You can compress big chunks of data before sending and they will be decompressed on the fly in the

To debug an MTS component in Visual Basic 6.0, make sure that the MTSTransactionMode property on MTS Objects (VB 6.0 Classes) is set to a value other than 0-NotAnMtsObject. When

Some classes in the Standard Library do not have a virtual destructor or virtual member functions by design. These classes include std::string, std::complex, and all STL containers. The lack of

When trying to navigate through a complex class hierarchy from any given instance of an object, it’s useful to be able to reference its parent. But how do you clean

Many applications have an option to show the toolbars as text and image or text-only. I have seen programmers handle this with two toolbars and show them based on the

Passing a derived object by value to a function that takes a base object by value may cause a problem known as “object slicing”; every additional data member declared in

You can protect the server from a crashing application by running the Web applications in their own memory space. To configure IIS to do this, launch the Internet Service Manager

This little routine demonstrates how easily you can determine the number of substrings within a string, given any specified separator character(s). Pass the string to be parsed, and the separator,