devxlogo

The Latest

Displaying Excel Information in ASP Pages

Question: How can ASP query an Excel sheet and get all the books’ names that reside in that Excel document using ADO (or any other way)? I want to display

Connecting to Databases from Web Servers

Question: In Visual InterDev I have successfully added a data connection. In the Data View I can see all my tables, fields, etc. My database resides on a SQL 7

Running Session_OnStart in the Global.asa File

Question: My Web site does not seem to be doing anything with the Session_OnStart procedure I have written. Any thoughts as to why? Answer: Many times programmers place the Global.asa

Use a Hyperlink as a Submit Button

If your page design includes attractive and colorful fonts, you may not want to use an ordinary HTML Submit button on your form. Sometimes you may want to submit the

Get a Free Grip on the Output of the Process Object

There are times when you have to use the exec(…) method of java.lang.Runtime class to launch a program. For example: public void some_method()…String[] commandArray = new String[1];commandArray[0] = “some_program”;java.lang.Runtime rt

How to Set Up the Properties Class

roperty lists are a convenient means of storing user preferences andapplication configuration information in a file.The java.util.Properties class makes managing property lists easy.It is a Hashtable intended only to store

Building a Network Service Object

bjects you build don’t always have to be related to a database entity. In fact, some of the best objects are pure service objects that know how to talk to

Managing Repetitive Jobs Without Cursors

hile lurking on the SQL List server, I happened upon a suggestion that eliminates the need for writing your own cursors to accomplish common database administration tasks. These tasks apply

Determine Server With ServerVariables

Question: We have users coming into our homepage from two different servers. I would like to differentiate what gets shown (text, links, and so forth) based on the server that

Using Integral Types With Explicit Sizes

The actual size of the built-in integral types are machine dependent (see also the Tip Standards Provide Guarantees Regarding the Sizes of Integral Types): //built-in integral types with machine-dependent sizeschar

Consistent Project Descriptions

Always set the Description property of your ActiveX projects (found in Properties) to be prefixed with your company name or initials. That way, all your internal objects and components will

Clean Up Your Objects—In the Right Order

Although Microsoft Internet Information Server (IIS) eventually removes your unused database objects (called garbage collection), poor coding can squander the server’s resources. If your Web server drags or even fails

ASP & MS Excel

Question: I can start excel on my server from an ASP script and then create and save a document. When I’m done, Excel doesn’t shutdown. I’ve tried various commands to

Creating a CWnd Class for Printing, Not Viewing

Question: After significant development time, a wonderful class derived from CWnd was created by our team to pull together text, graphics, etc. in a Paintbrush type of application. Now, we’d

VB DHTML Input Field Handling

Question: I have a DHTML form that is dynamically generated based on a user’s selection from a list box. It generates a table line for product information which includes text

Handling Session Timeouts

Question: When a user accesses an application on my site, a sessionID is generated. After the application is accessed the user leaves the machine alone until the session times out.

Resize the Browser On-the-Fly

If your Web page is formatted to look best in a certain size of window, you can try resizing the visitor’s browser using the resizeTo() method. Do this when the

Copying char array to integer

Question: I have a char array, for example: char orig_amt [20]. I need to convert this to an int orig_amt so I can do some calculation. Is there a command

WHERE Clause and Query Performance

Question: As a rule of thumb, a query that does a join will run faster if the table with the least number of rows is referenced first in the FROM-clause

Deleting Listbox Items

Question: How can I delete more than 1 Item from the listbox at once? Answer: I don’t believe the Windows list box allows you to delete more than one item

Software Engineering (C++ a bad choice?)

Question: I am working on an assignment that asks us to determine why using C++ is a bad choice, from a software engineering perspective.So far, I have found that C++

Attach Table

Question: I have 2 databases in SQL7. I need to attach one table, TB1, from DB1 to DB2, to run a join query. My query uses TB1 from DB1 and

Command Line Arguments

Question: I have a small console program that requires I pass arguments for it to run specific functions. I want to change the code so it automatically runs a set

File I/O

Question: How do I read in both a character string and int value from a file? The data I am trying to read looks like this: Name1 10 10 10Name2

Application Termination

Question: I have a message box that comes up to warn the user that they are terminating the application as it normally should be left running. I want to know