Question: I need to extract information using WHERE on fields in two different tables: one a text field, the other a numeric field. Both hold only numeric data. How can

Question: I’m writing a select statement to make a table name a variable whose value is set according to a condition: Var tablename;tablename := emp tableselect * from tablename; But

Question: How do I find out if a user has disabled cookies? Answer: To find out if a user has disabled cookies, follow these steps: Set a cookie. Redirect to

Question: Does Informix have a data type similiar to SQL Server’s image or ntext to input paths to link images? Answer: I’d use a CHAR(25) or a VARCHAR field for

Question: Why, after deleting an object I allocated dynamically, is the pointer still there? What exactly have I deleted and what would happen if I assigned a new value to

Question: Does WAP have a concept of IP address? Answer: You can get the gateway IP address and the terminal IP address using HTTP headers. WAP 1.1 currently has no

Question: I have a table in which the key field has a value stored with a percent sign, like ‘1234%’.Using this value, I want to select from another table that

Question: I have installed the version 9.2 of ESQLC, and when I try to run the program in the following manner: esql -e crdb.ec cc -c -I/home/informix/incl/esql crdb.c cc -ocrdb7.exe

Question: How do I concatenate a value in Stored Procedures (e.g., select * from mytable, where mytable.field1 = field that I concatenate)? Answer: If you want to match field1 to

Question: My base class contains this constructor: class Parent { Parent(int a, int b, char* c);}; My derived class contains this constructor: class Child : public Parent { Child(int a);};

Instead of using a META tag to re-direct a URL, simply place this code in place of the old page and a visitor will instantly be taken there. This piece

When you plan your queries, you should avoid the use of wildcard keyword * – which means “retrieve any field” – mainly because it may decrease performances, since the engine

Thanks to the SQL-DMO object model, it’s very easy to list all the available SQL Server 7.0 installations. For example, this code loads all the SQL Servers registered on the

The DateSerial function has an interesting feature: it doesn’t raise errors when you pass it an invalid month or day number. Instead, it evaluates the date as if the arguments

Using the SQL-DMO object model you can programmatically start, stop, pause, and continue the main SQL Server service. In the following code snippet the server is “MyServer”, and “sa” /

Statistic functions – that is MAX, MIN, SUM, AVG, VAR, VARP, STDEV and STDEVP – don’t take Null values into account. Usually this isn’t a problem with the SUM function,

Sometimes Microsoft documentation can be, well lacking is a kind word, and one is reluctant to call tech support when they smoke your credit card first, and ask questions later.My

The standard way to test whether two object variables point to the same object is through the Is operator, as in: If obj1 Is obj2 Then … However, when both

The SELECT TOP N query always return exactly N records, and arbitrarily drops any record that have the same value as the last record in the group. To see what

If you omit the ALL clause in an UNION statement, SQL Server must delete duplicate values, which in turn means that it has to sort the two sub-resultsets that have

The SQL language offers a simple and effective way to quickly move all records from a table to another table with same field structure, that is same fields’ name, type

Through its java.util.zip package, Java provides you with an easy mechanism to compress/decompress files. Here is a method called zipDir, that shows how to recursively zip a directory structure. Note

This is a Class to perform rotr and rotl as known in standard C implementations and a rotate with carry implementation. The technique used is to determine which bits within

You can access Java system properties within your queries (most useful when running in embedded mode; in server mode, you will see the server’s properties, not the client’s). VALUES (CLASS

This example shows how to create a method, and then an alias for that method, to act like the Sybase-style SUBSTRING built-in function. (Note that you can also perform methods

Java’s exception handling mechanism provides developers with an elegant, easy-to-use way to handle exceptional situations in their programs. For example, if there is a file operation to be performed, one