Question: I am with a large Fortune 500 company looking for a training management solution to produce CBT courses, organize, and report on skill-based courses and instructor-led courses on our

Question: I just installed SQL 7 on my server and have an Access database that contains a lot of information. How do I create a SQL database? Also, is there

Question: What is the difference between two dates, date1 and date2, when date2 is in the next record? Answer: Use this code: select datediff(laterone.date1, earlierone.date1) from table earlierone, table lateronewhere

Question: From a previous version of SQL Server 7.0 I saved only contract_Data.MDF and contract_Log.LDF. How can I insert this file in my current SQL Server 7.0? Answer: Here are

You can improve performance of your ADO applications by properly selecting the Cursor and Lock Types while opening the recordsets. Cursor Type indicates the type of the cursor the provider

You can use Clone() method of ADODB.Recordset object to create a duplicate recordset object from an existing recordset object. An important advantage of this method is that instead of creating

You can initialize variables of fundamental types by invoking their constructor: int n = int(); /* zero initialized */ char c = char(); /* ditto */ short *ps = new

As ASP programmers, we use the Request variable to retrieve information from our Web users. In a previous Web tip I showed how we could extract the values from a

Sun changed swing naming convention from com.sun.java.swing to javax.swing.This created a bit of confusion, but you can exploit it to see what versionof swing is installed in a browser, or

To compare dates in Java you have two choices:1. Create java.util.Date objects based on the dates that you’d like tocompare. use “public long getTime()” method of each date object to

There are many ways to help you manipulate your way through the VID MDI child code windows. Here are a few shortcut keys that can help. Ctrl-Up Arrow: Scroll up

The following site offers a slightly outdated version the C++ standard free of charge: ftp://ftp.research.att.com/dist/c++std/WP/CD2/. The differences between this version and the latest version of the standard are mostly editorials

XML4C is a validating XML parser written in C++. It enables an application to read and write XML data. Two shared libraries provide classes for parsing, generating, manipulating, and validating

There are many special characters that must be encoded to be viewed in HTML. Examples of these are:& (&), ” ("), < (<), and > (>)It is easy to hardcode

You can use javax.swing.JTextPane to display simple HTML page. JTextPane jTxtPane = new JTextPane();JScrollPane jScrollPane = new JScrollPane();jScrollPane.getViewport().add(jTxtPane);try { URL url = new URL(“http://www.mysite.simplepage.html” ); jTxtPane.setPage(url);} catch (Exception e) {

One can use the dbcc memusage command in both SQL Server 6.5 and 7.0 to determine which databases are using the most of the server’s memory. You can run dbcc

We often design HTML forms to gather information. The data is later stored in a database backend such as SQL Server. In such databases, you have to specify the length

In a Command Prompt window, you can start the SQL server in minimal configuration mode by typing: sqlservr -c -f This command also starts the SQL server in single-user mode.

This may seem a bit off-topic, but it has been a fertile source of guesses and flame wars in C++ newsgroups for years: how to pronounce the name of C++

Improper use of objects and object references can cause your application’s objects to stay resident in memory. Such “memory leaks” often causes system performance degradation and prevents your application from

R++ is an extension to C++ that supports rule-based programming. Thus, programs written in R++ have all the facilities of C++ plus a new programming construct: a rule. A rule

In the past, VB allowed an app to have only one icon. However, resource files expose any contained icons to Windows. Simply add the icons you wish to show to

Question: I’ve developed an application using JavaScript to access Oracle database and display results in sets of tables on an HTML page. Recently, I got a request to place the

Question: What is an XML server and how would I use it? Answer: There are a number of possible answers, depending upon the specific product. However, typically an XML server

Question: Is there a way to select a structure of a database row and send it once from a server to a client and after that send thousands of rows?

Question: I copied an XML document and an XSL document out of my XML for Dummies book. It said that to make the XSL document affect the XML document, I

Setting up the control tab order can be unruly-a sore point with many VB developers. In fact, in Jeff Hadfield’s recent editorial, “Five Things You Hate About VB6” [Editor’s Note,

It is possible to set a default timeout value for your Web application via Internet Service Manager. However, there are occasions when an ASP might process longer than this default

It is common for an application to retain user preferences between sessions.In Java, the java.util.Properties class provides you with a simple, elegantmechanism for storage and management of properties. An extension

Unlike C, C++ does not impose any restrictions on the length of identifiers. Implementations set their own limits, but these are so high that identifiers can consist of tens of