The Latest

DevX - Software Development Resource

Take Advantage of ADO Optimizations

A common user scenario in a development environment is where the code typically opens a connection, executes a row or non-row returning command, processes results, and closes the connection. For

DevX - Software Development Resource

Avoid File DSN Usage Whenever Possible

The File DSN usage should be avoided whenever possible. Instead, use System DSN; it is, on average, twice as fast. Also, File DSN is less secure because the database name,

DevX - Software Development Resource

Select Maximum Five Result

Question: How do I find out the top-five best sale items? I want the maximum five items to be listed. Answer: In version 7, SQL Server has conveniently provided the

DevX - Software Development Resource

Query Performance Comparison

Question: What is faster: two LIKE statements or one BETWEEN? ((MyData LIKE ‘02105_’) OR ((MyData LIKE ‘02106_)MyData BETWEEN ‘021050’ AND ‘021069’ Please advise. Answer: When trying to decide which is

DevX - Software Development Resource

Refer to Members of a Collection With the Full Name

You can access all variables directly by calling Request(variable) without the collection name. In this case, the Web server searches the collections in this order: QueryString Form Cookies ClientCertificate ServerVariables

DevX - Software Development Resource

Windows 2000 Boot Disk

Question: I have installed Windows 2000 on my laptop. I would like to create an emergency start disk akin to Windows 98. My current partition is FAT32. I created a

DevX - Software Development Resource

Dual Processor Support

Question: Does Microsoft plan on implementing dual processor support in Windows “Millenium” and will it be based on NT? I’m just trying to decide whether I should upgrade my Win98

DevX - Software Development Resource

NT Workstation 4.0 Home Network

Question: I have two PCs at home which are used by various members of my family. I want to connect them as a small network. Can I do this by

DevX - Software Development Resource

Schedule a Batch File

Question: I need to schedule a batch file to automatically run at night. I have tried every variation of the “AT” command from a command line on the Windows NT

DevX - Software Development Resource

Object Containment and Member Initialization

Question: I would like to know for containment (having objects as data member), what is meant by “if the inner class object’s constructor requires parameters, the initialization syntax must be

DevX - Software Development Resource

Defining an Array of Strings

Question: I have 20 predefined strings that I want to put into an array of strings. Here is my idea: #include static std::string array[20]; If I do just this, I

DevX - Software Development Resource

Using the Assert Macro

Question: I am not sure if it is good when I use the assert macro in the following code: int sum(int number)// Precondition: number => 1// Postcondition: return sum from

DevX - Software Development Resource

ReplaceWordEx – Replace whole words, with your choice of delimiters

Option Explicit’————————————————————————‘ This enum is used by both InstrWordEx and ReplaceWordEx” It uses a binary value to determine what separator characters are allowed’ bit 0 = allow spaces’ bit 1

DevX - Software Development Resource

InstrWordEx – Find a whole word, with your choice of delimiters

‘————————————————————————‘ This enum is used by both InstrWordEx and ReplaceWordEx” It uses a binary value to determine what separator characters are allowed’ bit 0 = allow spaces’ bit 1 =

DevX - Software Development Resource

Contact List in Public Folder

Question: I’m looking to make an online contact list without creating a whole new ASP page for my company. I was thinking that I could simply put the Outlook contact

DevX - Software Development Resource

Copying Table Rows

Question: I have two databases and two tables in them have the same structure (same columns etc.). How do I copy some rows from one database to another? Both tables

DevX - Software Development Resource

SMTP Mail Send Problem

Question: We are sending over 50K of outgoing e-mails an hour. Today the queue fills and we can only handle about 20K an hour. At some point the mail server

DevX - Software Development Resource

Microsoft SQL Server 7.0 DTS and Informix

Question: I’m curious if you or anyone else has successfully created a data warehouse in SQL Server 7.0, using DTS to import/extract info from Informix, running Elite time/billing application? Answer:

DevX - Software Development Resource

Send on Behalf Of/Reply Problem

Question: If I set up a delegate and they send a message on my behalf, the reply goes to my delegate. How can I force the reply to come to