Question: Is there an API that I can use to sense that the system is shutting down? Answer: Up until just recently the answer was no. But Sun keeps on

Question: How can I change the form used to print tasks? I would like it to print more than one line of notes. Answer: The standard form for printing a

Question: Are there any guidelines for what the directory structure of a Java-based project should be? Answer: The only real guidelines govern the layout of your source code. Yourdirectories should

Question: Can you point me at or come up with a generic class that allows date manipulation and storage without running into OS-specific or February 29 or Y2K issues? Answer:

Pop-up menus in normal HTML pages are usually implemented using Layers (DIV tag). However, the leading browser applications in the market have this known problem with layers: if a pop-up

The fastest way to do mouseover/mouseout image changes for hyperlinks would be the following: You can see that when your mouse goes over and off of the hyperlink, it changes

Question: I have seen a lot of XML editors coming out, and there are some that are very good. For me at least, developing the XSL has been more difficult

Question: Error 208 appears regularly on my IBM RS6000 running Informix 7.3. The onconfig setting for shared mem is 0 ( no limit). What do I do about this? Answer:

Question: I have an ASP application that retrieves several rows from a database using ADO. For those users who have a slower connection, I would like to know if there

Question: If my SQL Server has the following specs: 6.05.02 SQL-DMO6.50.252 DB-Library Which version do I have? And which service pack version do I have? Answer: If you want to

Question: I’m trying to retrieve the “firstname” and “lastname” fields from a SQL Server database, place them into a column called “fullname” using the AS statement. When I simply retrieve

Question: I would like to build a stored procedure that will receive a table name as a parameter. It then will select the data I want into whatever table name

Question: How do I send an e-mail to myself if a field reads “SEND_MAIL?” For example, a user wants more info on a product, so he clicks on the Send

Question: How do I create a new table? Answer: The DLL syntax for creating a table intuitively is the CREATE TABLE command. You can specify all the options for the

Question: I noticed that MSDN contains sp_OAStop, which shuts down the OLE environment that starts inside SQL Server the first time you call sp_OACreate. But I can’t figure out what

Question: How do I compare two values when one value(data type) is char and the other is an integer? Answer: For this you can use the CONVERT function. Since you

Question: I keep getting a syntax error on the last part of this statement: “SELECT DISTINCT [Company Name], [Street Address] FROM ” & d & ” WHERE[Street Address] !=” Maybe

Question: How do I get the average of three columns for each row of a table that has four columns of information? Answer: Let’s say you have a table called

At times you may need to access the command line passed to the application from within an ActiveX DLL. Unfortunately, when inside a DLL the Command$ function returns a null

By defining a Public Enum and using it as a parameter type to yourproperty or function, client applications are presented with a drop down list of values to use. Unfortunately,

By default IIS 4 doesn’t permit to use the Server.CreateObject command with an out-process ActiveX EXE component. To do so, you must manually create the AllowOutOfProcCmpts registry value under the

When you pass a non-existing key to the WriteProperty method of the PropertyBag object you get an error 327 “Data value named ‘namekey‘ not found”. This is more or less

While determine whether the current program is running as interpreted or compiled code is relatively easy, determine whether an ActiveX DLL is serving an interpreted or compiled application is a

As explained elsewhere in this knowledge base, you are suggested not to rely on the OnStartPage method to get a reference to the main ASP objects, if your component is

Before going to production, you should ensure that the server-side script debugging is off for your ASP application. In fact, not only does server-side debugging slow down your application, it

When an interpreted client running in the IDE enters debug (break) mode, all the ActiveX DLL it’s using continue to be in run mode as usual, even though you won’t

Postfix operators, namely ++ and –, are less efficient than their prefix counterparts because the compiler usually creates a temporary copy of the object before applying the operator to an

Many programmers still use the non-standard, platform dependent BOOL typedef instead of using bool. There are many good reasons why you shouldn’t use BOOL; one of them has to do