Tip Bank

DevX - Software Development Resource

Side-by-side Tables

Question: I have noticed that some sites have tables that sit side-by-side. I can never duplicate this behavior with my HTML scripts. Do you have any suggestions? Answer: Positioning two

DevX - Software Development Resource

The Type-name Keyword

A type-name is merely a placeholder that has to be substituted with a proper type. For example: template T min( const T& first, const T& second); //T is a type-name,

DevX - Software Development Resource

Make Sure Data is Safe Before Unloading

To decide when it is safe to exit your program, use a DataUnsafe function. Set the DataModified variable to False when you load or save data, or when you start

DevX - Software Development Resource

SQL order by count

Question: I need to know how to order by the count of the selected field. For example: Select xxx count(xxx)from prod-tableorder by xxxI’d like to order/rank field xxx highest to

DevX - Software Development Resource

adding records but not using primary key

Question: Is there any other way apart from using the INSERT INTO command that allows you to append a line to a database? I have a primary key “ID,” but

DevX - Software Development Resource

query

Question: I have a table like this: name cat1 cat2—- —— —–A 1 orangeA 1 orangeB 1 appleB 1 appleB 1 appleC 2 bananaC 2 bananaC 2 bananaC 2 banana

DevX - Software Development Resource

using COUNT and GROUP BY with zero-values

Question: I’m trying to query our Human Resources database to find the number of temporary employees in each department. I’m using the following SQL statement: select count (*)from employeewhere status

DevX - Software Development Resource

Creating Flexible Reports

Question: I have a problem making reports flexible. Let us assume we have a standard report, but it changes according to the situation. How can I allow users to change