Question: Is it possible to have subprocedures or subfunctions in Visual Basic?For example, in COM components we find properties being accessed using the following: myObject.Column(“myColumn”).Hide = True In this Column

Question: What are my options when I need to send multiple recordsets back to ASP from a single call? Which is the best for performance? Answer: You can return multiple

Question: I am having problem on restarting Informix after one of the chunks has been marked as DOWN. How do I change the status back to ONLINE? Answer: Depending on

Many programs access files either to read, write, or append data. For this the program needs to know where the physical file is located, besides the name of the file.

You can rename files through the use of the FileSystem object. The problem is that you would expect to find it in the document under a name like Rename. Actually,

One common problem with typing into Web forms is dealing with input fields and having your words go right off the right edge of the box into infinity as you

You can generate a GUID using SQL Server. All you need to do is open SQL Server Query Analyzer and execute following T-SQL statement: SELECT newid() This statement generates a

Question: I read the article ‘Obtaining Recordset From Middle-Tier COM Component’ and now am wondering why one would want to do this. As I understand it, this is only a

Question: We have ASP pages on a Web server with VB6 components that produce the majority of the HTML. These components run on the same machine as the the Web

Question: To show my SQL query results in paged fashion, I used your article as reference. This error message appeared: ADODB.Recordset error ‘800a0cb3’ The operation requested by the application is

Question: I have a website that uses ASP to access a database and display information in a table format based on information the user selects on the screen. My ASP

Question: I know some of you have had this problem: a page (or especially a frameset) loads, then it quickly flashes off and reloads itself, but then ignores the scripts

Question: I have heard from some that it is a bad idea to return recordsets from COM components and that you should populate a variant array and send that back

If you develop a complex Web application, you may find it a daunting task to keep track of the vast quantities of data on multiple domains in databases that quickly

It is possible to call two different functions when only a single event has occurred; for example, when the user has clicked on a particular button, or when your page

The code below gets the SELECT OPTION that the user has selected (from the SELECT element’s selectedIndex property) and uses that value to determine the correct branch in a case

Microsoft FrontPage makes it easy to define hot spots on a JPG or GIF image. In just a few steps, you can put a graphic to work on your page

Question: I can use VI to create a new project on the remote server, but when I want to debug the program, it raise an error: “unable to find server

Question: I want to have an image pop up, like a tool tip, when I hover over specific text. Is there any way to do this with DHTML or Javascript?

Question: I want to provide the facility to add/delete/modify Windows NT users from a remote browser. However, I don’t know how to do it. Can you kindly help? Answer: This

Question: I have a problem with the add and update query in SQL. I am trying to update the database with a string which contains one or more apostrophes. SQL

Question: I tried using the replace function as shown below, but I receive an error on using “Next i”. Function formatOutput( theText )Dim iDim sNewStringFor i = 1 to Len(theText)

Question: Is it possible to design a pull down menu that will show over an object? Every way that I’ve tried still hides the part of the menu behind the

Question: Can we call a nested procedure in ASP? Answer: Nope. This isn’t supported in any Visual Basic-variant language. Having done nested procedures before (Pascal, I think), I never saw

Question: After retrieving data into a recordset object, I want to filter this data. I tried using the objRs.filter method of ADO, but it doesn’t seem to work. This is

Often when you’re developing script, you may want to determinejust how long the code takes to run. To do so, take advantage ofASP’s built-in Timer function. As you may know,

Question: How do I use Active Server Pages to create WAP pages? Answer: By setting the MIME type, you can use ASP to write WML. This command accomplishes this: Response.ContentType

Question: When I create a spinner control and limit the upper and lower limits to specific integers, how do I wrap around the spinner to a specific integer range? For

Question: After I install this driver, I see the error message when starting Lotus Notes Application: “The application uses CTL3D32.DLL, which is not the correct version. This version of CTL3D32.DLL