Question: I need your assistance to solve the following: I am using an RDO connection to connect to a SQL 7.0 database, and I am using the server-side cursor technique

Question: How do I merge two values from separate fields using SQL? An example would be taking the LastName field and placing it before the FirstName field like this: “LastName,

Question: How do I do a “group by” SQL statement? I want to return all rows and columns with ** records. Here is the data sample: columnA columnB columnCAAA 2334

Question: I am having trouble getting the following type of join to work. I have three tables: Application, College_hist, and School_Info. Application has student ID numbers that identify the person

Question: I have upgraded from Outlook Express to Outlook 98. Previously I was able to leave messages to a particular e-mail recipient on the server. With Outlook 98 I no

Question: I need to know how to write SQL to ask for a date range and run the query on that range. Can you help me? Answer: I think it

Question: I have a SQL database on our production NT server and need to move the database to another NT server. I used the Database/object transfer in Enterprise Manager to

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