- 1,251 categories
- 40,829 scripts
- 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.
- Categories
- Platforms
- Licenses
- Adding a record from a database table is a simple task. Fill out the form below and click submit. The sql statement will be generated for you.
- Categories
- Platforms
- Licenses
- Delete a record from your database quickly and easily without having to use a recordset. Deleting a record from a database table is a simple task. Answer four questions below and click submit. The sql statement will be generated for you.
- Categories
- Platforms
- Licenses
- It is somewhat ironic that the most confusing part of creating and executing a SQL statement from ASP is determining where to put the quotes. When is a single quote used? When is a double quote used? When are they used together? Which takes precedenc...
- Categories
- Platforms
- Licenses
- Allowing multiple choices of data observations enables people to customize views of your data and adds value to your applications. This example utilizes our db on the career statistics of Hammerin Hank Greenberg. The years he played are available to...
- Categories
- Platforms
- Licenses
- This is a brief and very useful tutorial on creating and using stored procedures with your asp applications. A stored procedure is nothing more than an sql statement stored inside a database. The database can be SQL Server or MS Access as well as oth...
- Categories
- Platforms
- Licenses
- Allowing multiple choices of data elements enables people to customize views of your data and adds value to your applications. In this sample code, user inputted choice(s) are added to the basic sql statement to draw them from the db. Since the input...
- Categories
- Platforms
- Licenses
- This page demonstrates the capabilities how to write an ASCII comma-delimited file from a SQL statement using ASP.
- Categories
- Platforms
- Licenses
- ASP Express allows you the extreme flexibility of an HTML text editor, while giving you the automation of a great ASP and ASP.Net text editor. Key features include: Open your files directly from your web site with built in FTP services, Treeview of A...
- Categories
- Platforms
- Licenses
- SqlFun is a Java program/applet that allows you to experiment with SQL statements (hopefully) without having to install a SQL server or database program. All you need is Java and Windows ODBC (or any other database server that supports JDBC). Startin...
- Categories
- Platforms
- Licenses
Page: