Tip Bank

DevX - Software Development Resource

The hidden Collect method of the Recordset object

The ADO Recorset object exposes a hidden, undocumented member: the Collect property. This property is functionally similar to the Field’s Value property, but it’s faster because it doesn’t need a

DevX - Software Development Resource

Create a Table with Autonumbering

Question: I’ve tried to create a table (for my guestbook) with an auto increment column. Here’s my statement: CREATE TABLE guestbook(id mediumint(8) NOT NULL KEY(PRI) default(0) auto_increment, name varchar(30) NOT

DevX - Software Development Resource

Automating Backups

Question: Is there a command-line way to back up my Exchange databases without stopping the services, like the GUI can? Or, for that matter, is there any automated method of

DevX - Software Development Resource

IMC and Latency

Question: Outbound messages are being delayed randomly. You can send them to the same host—sometimes they don’t queue up long enough to even see. Other times they are there for

DevX - Software Development Resource

Date Time Values in Parameterized Queries

Question: I have a parameterized SQL statement like the following: “insert into eSession (ESessionID, eUserName, eLastActivityTime) VALUES(?,?,?)” It’s parameters are ‘bbb’,’name’ and ‘2000/01/01 22:23:25′, using an ODBC connection. I can’t

DevX - Software Development Resource

Embedding Applets in XML Documents

I came across this solution while trying to embed an applet in an XSL page I was using to transform my XML source document into HTML.If you want to cut

DevX - Software Development Resource

Let the user copy floppy disks

The simplest way to help user copy a floppy disk is display the Copy Disk system dialog. You can do this with a one-line statement: Shell “rundll32.exe diskcopy.dll,DiskCopyRunDll 0,0”