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

In several occasions, C++ requires the use of integral constant expressions, for instance: array bounds, case expressions, bit-field lengths, and enumerator initializers must all be integral constant expressions. An integral

Another set of typedef names for integer types defined in < inttypes.h > is called “fastest minimum-width integer types.” Each of these typedef names designates aninteger type that is usually

The newly approved C99 standard defines a new header file called < inttypes.h >, which defines sets of typedef names for integer types. One of these sets defines integer types

Question: How do I dynamically convert HTML to WML? I would like to take data from, say, a stock-quote page, strip it, and display the info in WML. Answer: Some

Question: Can the ORACLE database talk with XML like SQL Server can? Answer: An XML parser is available in Oracle8i. Oracle is developing a product called Messenger that will allow

Question: Can I send an e-mail via WAP, handheld PC or other units when I’m on the go? Answer: There are lots of possibilities. You can set up a WML/ASP

Question: What is the range of data transfer bandwidth? Answer: In GSM, the usual data transfer rate is 9.6Kbps. Under High Speed Circuit Switched Data (HSCSD), you can get around

Question: Will doing an HTTP redirect via Response.redirect cause a problem for WAP? Answer: It all depends on what SDK you use, as well as exactly how you write your

Question: How do I capture the voice streaming from a mobile phone? I am working on mobile phones that run on a PC card (PCMCIA). Answer: Several software companies currently

Question: We have implemented a technology resource policy that includes the following: “5.5 Automatic Deletion of Stored E-mail. All e-mail stored on (Company Name) servers will be automatically deleted after

Question: I have a domain with a PDC server and a BDC server. I want to replace the PDC, where I have Exchange 5.5SP2, with a bigger server and basically

Question: I have a column in a grid that is of the data type date. In the InteractiveChange event, I have a code that takes the value entered in the

Question: How do I make a control keep the focus until a value within a specified range is entered? The control in question is a text box. Answer: The simplest