devxlogo

Tip Bank

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

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.

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

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

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

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

Run Time Object / Control Management

Question: Can I write statements to add/delete the control objects like command buttonsat runtime like we do in java C++ ? Iam under the assumption that once we populate a