NEW LISTINGS 
HOT LISTINGS
TOP RATED
EDITOR PICK
ADD A LISTING
UPDATE A LISTING
GET RATED
UPGRADE A LISTING
HOT LISTINGS
TOP RATED
EDITOR PICK
ADD A LISTING
UPDATE A LISTING
GET RATED
UPGRADE A LISTING
Display Table Script Writer
2583
Display Table Script Writer
http://www.codeave.com/asp/code.asp?u_log=62
Displaying an Access or SQL Server database is as easy as entering the variable names and the name of the table into the fields below. Copy the output code into an asp document on your web server and your db is ready to be displayed on the web. The DSN connection requires that you register the DSN for the db prior to executing the code. (Note: G.I.G.O Garbage In Garbage Out applies here, be certain all table elements entered appear in your db. Table elements must be entered in the select field * will not work here.)
ASP > Tips and Tutorials > Database-related
Oct 10, 2006
Write a Review
Add to My Favorite
Refer it to Friend
Report Broken Link
| |
|
||
| Bookmark Display Table Script Writer: |
|||
Other links at ASP > Tips and Tutorials > Database-related
1. ADO Connection, Command, and RecordSet object with simple SQL statements with ASP (Active Server Pag
Learn how to use the ADO Connection, Command, and RecordSet object with simple SQL statements with ASP (Active Server Pages).
Category:
Several State and Federal contracts that I have worked on in the past have wanted to keep track of all changes to a particular record, such as who modified the record, what kind of modification took place, and when the record modification occurred. I decided to solve this problem with triggers because I wanted to capture every action that occurred on a particular table. For those unfamiliar with triggers, a trigger is a database-event that fires when a particular action occurs. For example, an INSERT trigger would fire when a particular database table has a record inserted. For a more in-depth examination of triggers, be sure to read
Category:
DSN Connections
In my earlier article on Accessing the database from ASP I explained connecting to database via DSN in a step by step mannner. So there is no need to repeat that again, you can see it from there.
DSN stands for 'Data Source Name'. It is an easy way to assign useful and easily rememberable names to data sources which may not be limited to databases alone e.g Excel spread sheet etc.
I will now skip the steps of creating and assigning DSN to a database, you can see them by clicking here. Once you are done creating a DSN for your data source ( database lets say ), you can connect to it using following code
In my earlier article on Accessing the database from ASP I explained connecting to database via DSN in a step by step mannner. So there is no need to repeat that again, you can see it from there.
DSN stands for 'Data Source Name'. It is an easy way to assign useful and easily rememberable names to data sources which may not be limited to databases alone e.g Excel spread sheet etc.
I will now skip the steps of creating and assigning DSN to a database, you can see them by clicking here. Once you are done creating a DSN for your data source ( database lets say ), you can connect to it using following code
Category:
This article is an overview of SYSTEM DSN's, DSN-LESS Connections, and any permissions that may need to be set on the server.
This article only applies to using Access Database's.
I have written this article because these issues appear to be a very confusing for people just learning ASP
This article only applies to using Access Database's.
I have written this article because these issues appear to be a very confusing for people just learning ASP
Category:
sample code below and edit the tables to match yours.
You can store images in a Database to later access them. To do that,
you have to use the following code to get the image from the database.
You can store images in a Database to later access them. To do that,
you have to use the following code to get the image from the database.
Category:
Main Category
194
2041
824
286
175
1802
1238
913
1163
7489
70
909
59
2222
174
Join Mailing List
Joining mailing list will entitle you
to receive occasional emails informing you of news and
updates to the site and any special offers that may be
of interest to you.
Top 10
Directory Statistics
Links: 19539
Categories: 1275
Registered Users: 750
Mailing List Subscribers: 2046
Unique Outgoing Hits: 228066
Pagerank Statistics
PHP News