Question: Our Web server (NT 4.0) became inoperable over the weekend due to a SQL Server error that stated that the “applications log file is full”. From what I understand,

Question: Why don’t destructors work on global classes? Answer: Actually, destructors do work in global objects. The problem is, they are invoked after the program has ended so you don’t

Question: How do I get the TextBox to display automatically at the end of text, instead of at the begining of the text? Answer: The answer is very simple. All

Question: I need to write a script that tells me the last user_id entered on a table and then another script in order to allow me (or a user) to

Question: In Microsoft Query I can’t seem to use the Execute SQL function. I’m learning SQL from a book called The ColdFusion 4.0 Web Application Construction Kit (Macmillan, 1998). The

To programmatically display the “Shut down Windows” standard dialog box you can use the SHShutDownDialog undocumented API function, whose declaration is: Declare Function SHShutDownDialog Lib “shell32” Alias “#60” (ByVal lType

The Desktop is a window like any other window in the system, so you can hide/show and enable/disable it. The only details you need to know is how to retrieve

SHFormatDrive is an undocumented but simple API function that allows you to format a drive. This function simply opens “Format Drive” diaolog window. Being undocument you won’t find its Declare

Who said you can’t use an animated cursor with Visual Basic? Actually, it’s so simple! You just have to load your animated cursor through LoadCursorFromFile API function, then you get

The Windows’ application bar (or Startbar) is a window like any other window in the system, so you can hide/show and enable/disable it. The only thing you need to know

All recent Windows applications use a flat toolbar similar to Internet Explorer ‘s and Microsoft Word’s ones. Visual Basic 6 includes a Toolbar control that supports the flat look, but

The class java.net.InetAddress represents an Internet Protocol (IP) address. You can use this class to find the IP address of a host using the hostname. The following code demonstrates this:

The class java.net.InetAddress represents an Internet Protocol (IP) address. You can use this class to find the hostname of an IP address. The following code demonstrates this: try{ java.net.InetAddress inetAdd

Question: I’m passing a string from one ASP template to another. The string may contain spaces so I call URLEncode, which works well as far as preventing the 400 Error

Question: How do you access data on a mainframe using ASP? Answer: It depends on your mainframe application. If there is a way to connect to the data via ODBC

Question: I need a VBScript function that will format a date as mm/dd/yyyy. The FormatDateTime function does not give me this option and the CDate function wants to convert everything

Question: For my company’s intranet, I used sessions to keep track of the user. When a user clicks on the logout button, the session is abandoned. However, even though the

Question: Is it possible to force the file download box to appear through ASP? I want to create a file on the fly with the response.write method to fill its

Question: How can I read the content of an HTML page from another URL? I tried using the FileSystemObject by providing the virtual path, but it says http permission is

Question: How do I read the names of tables and fields in an Access database? I tried OpenSchema, but I got the error, “The operation requested by the application is

The SQL server date function provides an easy way to calculate the number of days in a month. To calculate the total number of days in each month in SQL

The application should try to bind columns to a program variable of the same data type as the column in the result set. If the application still needs to have

All statements executed in a stored procedure, including SELECT statements, generate an “x rows affected” message. These messages are typically not needed by the application when it is executing a

In ANSI SQL, you are always in a transaction, because there is no BEGIN TRANSACTION statement. The purpose of the SET IMPLICIT_TRANSACTIONS command in SQL 7.0 is to allow T-SQL

JavaScript has both numeric and string types, and it converts between these as it encounters them in the script. It uses “+” for both numeric addition as well as string

Underscores signify a single character in SQL language. Using LIKE for underscores will returns all values for ‘x’ whether they contain an underscore or not. Therefore, usage as shown below

You cannot include a comment in an output expression while working with server side scripts. For example, the first line that follows will work, but the second line will not,

To quickly establish a database connection from ASP, try using a file DSN. The DSN string should not contain spaces, either, before or after the equal sign (=). In this