Question: What’s the syntax for outer joins in the where clause in Informix? Answer: The syntax is: SELECT c.customer_num, c.lname, c.company,c.phone, u.call_dtime, u.call_descrFROM customer c, OUTER cust_calls uWHERE c.customer_num =

Question: Using C or C++ for CGI programs, is there a way to make a CGI program that calls another CGI program, and then takes the output of that called

Question: If I have the option of using the uniqueidentifier or int data type for a primary key, will choosing the uniqueidentifier mean a significant performance degradation? Answer: The uniqueidentifier

Const HKEY_LOCAL_MACHINE = &H80000002′ Return information about the Bios (NT only)” Requires the GetRegistryValue routineSub GetBiosInfo(BiosDate As String, BiosVersion As String) ‘ These keys appear to exist only on NT

Private Declare Function GetVersion Lib “kernel32″ () As LongConst HKEY_LOCAL_MACHINE = &H80000002′ Modify the name of the registered user and organization” Requires the SetRegistryValue functionSub SetRegisteredUser(ByVal UserName As String, Optional

Const HKEY_LOCAL_MACHINE = &H80000002′ Information about the CPU’ you can pass a number 1 to the last argument to retrieve’ information on all the processors in a multi-CPU system” Returns

Const HKEY_LOCAL_MACHINE = &H80000002′ modify the value of a setting for the VB IDE from the Registry’ Important: only works with VB6” New values are effective when VB is restarted”

Const HKEY_LOCAL_MACHINE = &H80000002′ Get the path of a Windows application’ or an empty string if the application isn’t registered” this routine only works for those applications that register’ themselves

Const HKEY_LOCAL_MACHINE = &H80000002′ read the name and path of the external HTML editor’ configured for the VB environment” Requires the GetRegistryValue functionFunction GetExternalHTMLEditor() As String ‘ Note that the

Const HKEY_LOCAL_MACHINE = &H80000002′ get the list of ODBC drivers through the registry” returns a collection of strings, each one holding the’ name of a driver, e.g. “Microsoft Access Driver

Const HKEY_LOCAL_MACHINE = &H80000002′ Return information about an ODBC driver” The 1st argument must be an ODBC driver name,’ as returned by the GetODBCDrivers function’ Not all drivers return the

Const HKEY_LOCAL_MACHINE = &H80000002′ Return the number of processors” Requires the CheckRegistryKey routineFunction GetNumberOfCPUs() As Integer Dim keyName As String ‘ loop on the subkeys of HKEY_LOCAL_MACHINEHardwareDescriptionSystem ‘ CentralProcessor ‘

Const HKEY_LOCAL_MACHINE = &H80000002′ read the value of a setting for the VB IDE from the Registry’ Important: only works with VB6” Possible values for SettingName are’ AlignToGrid (returns 0/1)’

While the DIV element can be used to designate block-level elements such as paragraphs and list items, SPAN is used within a block. And while most browsers will insert a

Using the frame’s location object, you can load a number of different files into a frame at runtime. As you do when building any project using frames, first build a

Avoid putting double quotes inside of double quotes in your HTML code. You may not get a compiler error, but your script just won’t work. Instead, substitute single quotes for

We can pass variables from page to page with the following script: This snippet of ASP script will also automatically create hidden fields that will be dumped into all following

If you’re writing complex frame sets by hand, it’s easy to get lost in “spaghetti code.” To keep a handle on the situation, don’t build the entire frame set at

JavaScript does not have a built-in function for formatting floating-point numbers. However, it’s easy to create one using JavaScript’s String methods. For example: function format(expr, decplaces) { // Convert the

There are some differences in Cascading Style Sheet implementation in Internet Explorer 3 and 4. So you may want to choose which set of style sheets to load for your

Using the BrowserType object, your ASP pages can detect the type of browser being used to download the page. In addition, you can also test the browser for specific capabilities.

The following code can be used in the tag of an HTML document for automatic mouseover effects on all links on the page. The styles ‘a’ and ‘a:visited’ are used

Question: How can I use SQL to access an Informix database that’s on a remote site and connected via a VPN while connected to an Informix database locally? Both are

ServerVariables’ collection of request objects provides vital information about the client browser, HTTP header, etc. During the development of a web application, we use various variables of this collection to

Both IE and Navigator let you specify different background colors in table cells. However, IE ups the ante by supporting tiled background images in different cells or even behind an

The default setting for ScriptTimeout is 90 seconds. For IIS 3.0, it is located in the system registry where we can easily change it to another value. It is advisable

JavaScript provides a special keyword, “this”, which is a reference to the object that contains a JavaScript statement or function call. For example, if we have a text box object,

If you use frames in your page, it’s easy enough to create a link that updates one of them. But what do you do when you need to update two