October 6, 1999

Display Queries in an Excel Workbook

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 results of my queries in Microsoft Excel 97. The queries that I have are pretty complex, so I’m trying to

What Is an XML Server?

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 is a Web server program that accepts or receives XML. An example could be an object-oriented database server that will

Sending Many Database Rows with XML

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? Doesn’t repeating the same metadata for each row create huge overhead? Answer: Typically, depending upon the server that you’re working

Apply an XSL Filter to an XML Document

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 had to use a script and the object tag in HTML, and I had to get something from a CAB

Set Tab Order in a Hurry

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, VBPJ April 1999], it’s listed as one of the top five things people hate most about VB. I’ve never understood

Extend the Timeout of an ASP

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 value. This could result from intensive file I/O, complex business rules including database access, automation of other Web pages, or

Treat the User to Consistency Between Sessions

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 ofjava.util.Hashtable, the Properties class represents a persistent set ofproperty pairs that can be written to, and read from a stream.

Coping With Warning Messages Regarding Identifier’s Length

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 thousands of characters. Although you wouldn’t normally use more than a dozen characters as an identifier’s name, remember that during

Add a Document Name to Your Printouts

I wanted to distinguish between different print jobs. I tried to find a way to set the print job name that appears in the printer queue, but even some nasty API calls didn’t work well. I found a simple trick, though it works only after compiling to an EXE: Dim

No more posts to show