There is often a need to get a date in the furure or the past, like exactly a month ago or 7 days from now etc.
By: Julia Bright | 08 June 2009 | ASP |
| |
This is the code for updating and adding new records to a database.
By: Julia Bright | 08 June 2009 | ASP |
| |
When deleting records it is good enough just to build the SQL statement and call oConn.Execute
By: Julia Bright | 08 June 2009 | ASP |
| |
If you know you are gonna loop through a lot of records ( like when displaying a table of all articles in the system ) then use CacheSize to the drivers optimize their memory allocations and therefore make the call much faster. I bet you have some idea on how many rows your query might return ( 1 single, maybe 100 or maybe 10000 ). Set the CacheSize pretty high, since it will then lower the times the drivers need to reallocate memory.
By: Julia Bright | 08 June 2009 | ASP |
| |
This is the connection function and the usage for access database connection in ASP.
By: Julia Bright | 08 June 2009 | ASP |
| |
ADO can be used via ODBC or OLEDB drivers. OLEDB drivers generally gives somewhat better performance.
By: Julia Bright | 08 June 2009 | ASP |
| |
This way could be very difficult, since you have a lot of options you could specify in the connection string. However, the simple connection string I present to you here is actually all you need for adequate performance in most cases.
By: Julia Bright | 08 June 2009 | ASP |
| |
This code checks if a specified file exists in the server.
By: Julia Bright | 08 June 2009 | ASP |
| |
This is the code for getting last modified date of a file.
By: Julia Bright | 08 June 2009 | ASP |
| |
This is an easy, not much to say about, way of exporting data from a webpage to Excel. It makes use of the fact that Excel can read HTML tables and I wont explain it a lot more cause it's pretty straight forward...
By: Julia Bright | 08 June 2009 | ASP |
| |
We are here gonna create a three page website - all pages should use a "template" for layout. This will enable us to easily keep a consistent layout for all our pages and also, it sure brings structure to your code.
By: Julia Bright | 08 June 2009 | ASP |
| |
These functions can be used on certain pages you want password protected.
By: Julia Bright | 08 June 2009 | ASP |
| |
This function can be used to have a random password generated. It allows you to specify valid characters as well as specifying number of characters.
By: Julia Bright | 08 June 2009 | ASP |
| |
The example in this article is very similar to the example on Saving HTML Form Data to XML. However, instead of creating a new file each time that the form is submitted, we will check to see if the file already exists, and if it does, we will append to it. Using this type of technique, we are creating a data construct similar to a data base table.
By: Alex Madley | 01 June 2009 | ASP |
| |
Usually form submissions in ASP are written to some sort of database management system. However, if you need your form submission data to be more portable, it can be written to an XML file. This is especially useful when the data you are gathering on your Web site will be sent to applications on non-Windows platforms. Since XML is completely portable across all platforms the data will not need to be converted.
By: Alex Madley | 01 June 2009 | ASP |
| |
XML@ASP is a simple script, formatting a recordset as an XML document. Its usage is very simple, all you have to do is assign some database result set to the script and you get an XML document at hand. Code: ASP 1.0 & VBScript
By: Alex Madley | 01 June 2009 | ASP |
| |
A simple Atom client written in Microsoft ASP using MSXML. See www.atomenabled.org for specification.
By: Alex Madley | 01 June 2009 | ASP |
| |
This article is the final installment in a series of articles on manipulating XML data with ASP.
By: Alex Madley | 01 June 2009 | ASP |
| |
