| |
| |
How do I get the Unique ID or Auto ID of the record I just entered? The solution is really quite simple.
|
|
|
| |
| |
Ever wondered how to create a table, view or procedure with MS Access? This article shows us how to create all three and work with them from an ASP script.
|
|
|
| |
| |
Learn how to delete records with an SQL instead of a Recordset. Here are two examples. One will use a query string and the other gets the info from a form. Both examples include an example of a DSN-LESS connection.
|
|
|
| |
| |
There are a few different ways to connect to an Access database using a DSN-LESS connection. You can use the Access driver, an OLEDB provider connection, a physical path or a virtual path. Here is an example of each as well as a DSN-LESS SQL Server connection.
|
|
|
| |
| |
Learn how to edit records with an SQL statement instead of a Recordset. Here are two examples. One will use a query string and the other gets the info from a form. Both examples include an example of a DSN-LESS connection.
|
|
|
| |
| |
Learn how to add records with an SQL statement instead of a Recordset. Here are two examples. One will use a query string and the other gets the info from a form. Both examples include an example of a DSN-LESS connection.
|
|
|
| |
| |
Dropdowns or combo boxes are an excellent way to get input from a user. One of the biggest problems with user input is spelling and formatting. Here is how to use and populate dropdowns from a database.
|
|
|
| |
| |
Use an include file for your database connection. Here's the reason why. Before I wised up to this, I was placing the connection on every page. Then there were some configuration changes and none of the pages worked. This meant that every page had to be edited.
|
|
|
| |
| |
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.
|
|
|
| |
| |
When faced with learning a new technology, it's common to try and reproduce the basic functionality you're used to in the old one. In doing that with ADO.NET and trying to reproduce the basics or the recordset object, this article discusses the new and many uses of ADO.NET's DataView object.
|
|
|
| |
|
