Tip Bank

DevX - Software Development Resource

Find the Path of a Project With ASP

Question: Is there any way to programmatically determine the path of the current ASP page on the server? I am trying to access a specific text that I added to

DevX - Software Development Resource

Get Count of Records in a Recordset

Question: How do I get the number of records from a “select * from dept where deptno = ..”? I want to know how many records are in my recordset

DevX - Software Development Resource

Make Variable Available to All Pages

Question: Can I use a global variable in VBScript and make it accessible from any Web page? Answer: There is no such thing as a global variable in Web pages.

DevX - Software Development Resource

Count ASP Sessions

Question: I am trying to count the number of users (sessions opened) to a given app. It easy enough to increment an Application variable with Session_Onstart and decrement it with

DevX - Software Development Resource

Leverage Office to Spellcheck RichText

Integrate Microsoft Word 97’s spellchecking capability into VB apps while maintaining formatting within a rich textbox. To test this code:1. Create a standard EXE project in VB.2. Add the RichTextBox

DevX - Software Development Resource

Handle Update Collisions in ADO Disconnected Recordsets

Data-access techniques using cached data on the client for updates is possible using disconnected recordsets. This technique generates collisions in some situations. However, the technique for dealing with collisions rows

DevX - Software Development Resource

Extracting a Number From a String

There are many applications that store numbers in strings that also contain text. For example, some databases store dates as strings in the form of “01Jan”. You can extract the

DevX - Software Development Resource

Refresh Part of a Page

Question: Is there a way to refresh or redraw part of a screen display using HTML and JavaScript without using frames? I want the top 1/4 of my screen to