Tip Bank

Question: How do I retrieve all the table names from an Access database using ASP? Answer: Make sure you have an ODBC DSN to point to your database. Then use

Question: How do I create a directory in ASP? Answer: Use the ‘CreateFolder’ method of the FileSystemObject object. Set fs = Server.CreateObject(“Scripting.FileSystemObject”)fs.CreateFolder (“foldername”) Obviously, you need to have proper permissions

Question: How do I strip off leading zeros from data displayed from an ASP page? Answer: Use the FormatNumber function.If value = “0000046” Then FormatNumber(value,0) will result in 46. FormatNumber(value,2)

Question: I want to display the “Enter Network Password” box when a user accesses my site. I can display an ActiveX control on my HTML page (ObjectID Tag) but it

Question: I am using Visual InterDev to create a data-driven Web application. How do I create an instance of a user-defined ActiveX component in Visual InterDev? I have created an

Question: How do I generate numbers at the server end? I have an application in which I am accessing data from an Access database and I want to define each

Question: I have been testing the delivery of ASP pages versus HTML pages and found that there is a considerable difference (ASP = 1 per sec / HTML = 187

Question: I have a session variable that keeps track of a user name and is set through a login page. Every page in the application first checks for the session

Question: I am querying an Oracle field that comes back in the format of 25.5. Because this is a currency field, I’d like to manipulate it so that it shows