Tip Bank

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

Question: How can I show a ‘Loading…’ message till my ASP page loads? Answer: Use the following code to create a “pgLoading.asp” page. Pass to it as a parameter the

Question: When I create an ASP page that gets sent to the browser, if users press the refresh button they get a message asking to repost from old data. How

Question: I have a date field on my ASP page. I want to restrict the user for entering only the dates in his Windows 95 machine’s date format. How can

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