|
Dynamic Form and Database Driven Marquee
|
Other links at ASP > Tutorials > Database-related |
| 1. |
Running ASP in Linux and Possible Problems
|
|
|
This writing will discuss several things to do to ensure the application migration carried on in a good way, particularly for ASP Database applications and to overcome possible problems might occurred. Basically, migrating ASP to Linux means you have to convert to database supported by Linux platforms. Currently, Chili!Soft ASP is already supporting MS Access but not all web hosting companies install this feature. They prefer to use more common database in Linux such as MySQL and PostgreSQL. Pay attention to some Chili!Soft specific ADO methods and properties, since there are slight differences with IIS ASP. You might need to convert some codes in your applications to make it run in Chili!Soft ASP.
|
| 2. |
WiredNow.net: SQL Reserved Words
|
|
|
It is an often problem with database intergration when you use a reserved word. Often asked why a script does not work and it quite often comes down the the author setting a field name as a reserved word, confusing SQL and making debugging hard. To solve this problem here is a quick list of the SQL Reserved Words.
|
| 4. |
Using ASP pages to page through Recordset
|
|
|
In depth article on showing records in a page by page fashion with first page,next,back and last page links at the bottom to navigate through the records. Sample code and database available for download. Online demo also available.
|
| 5. |
Running Stored Procedures in Access Database
|
|
|
Explains everything in detail youll ever need to know about creating Stored Procedures in Access Database and then calling from within ASP. Select, Update, Insert and Delete Stored Procedures are described. Sample code and database available for download.
|
|
|
