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
Browse a Listing
Top > ASP > Tips and Tutorials > Database-related
Popular Tags
Free Script links
I actually had some trouble naming this article. I started out with something like "It Don't Mean A Thing If You Ain't Got That String" since quite often people have everything else in their code fine, but can't get connected. I decided that wouldn't work since I wanted you to be able to tell what the heck the article was going to cover and I wasn't sure people would get the Duke Ellington reference. Then I started thinking about something along the lines of "Get Yourself Connected." Again I found the lack of descriptiveness (if that's a word) troublesome and I didn't want people who don't get HBO to miss all the Sopranos references I would have been forced to make.
Write a Review
Add Favorite
Refer it to Friend
Report Broken Link
Date Added: Oct 10, 2006 Hits: 1 Rating: 0.00 Votes: 0
Category:
Write a Review
Add Favorite
Refer it to Friend
Report Broken Link
Date Added: Oct 10, 2006 Hits: 1 Rating: 0.00 Votes: 0
Member Reviews
Visitor Ratings 
Google PR
Searching a data base to display hyperlinked summaries that can be clicked on to display detail data provides an excellent way to navigate through your data. The following example will search our test input db of names from our example on Database Input and Display which contains last name (lname), first name (fname) and unique id (unique_id a counter of all names as they are added to the db). The user will can search the first or last name and click on any of the results to reveal the detail data (the unique id, which is all the data we have in this db) all in the same active server page. Note: The db on the server contains data primarily created by users of CodeAve.com, as a consequence some of the data contained in the db may be questionable.
Write a Review
Add Favorite
Refer it to Friend
Report Broken Link
Date Added: Oct 10, 2006 Hits: 2 Rating: 0.00 Votes: 0
Category:
Write a Review
Add Favorite
Refer it to Friend
Report Broken Link
Date Added: Oct 10, 2006 Hits: 2 Rating: 0.00 Votes: 0
Member Reviews
Visitor Ratings Google PR
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.)
Write a Review
Add Favorite
Refer it to Friend
Report Broken Link
Date Added: Oct 10, 2006 Hits: 1 Rating: 0.00 Votes: 0
Category:
Write a Review
Add Favorite
Refer it to Friend
Report Broken Link
Date Added: Oct 10, 2006 Hits: 1 Rating: 0.00 Votes: 0
Member Reviews
Visitor Ratings Google PR
Microsoft Index Server is a built-in feature of Windows 2000. It provides a service for automatically indexing documents such as HTML, text, and Office documents. The Index Server search facilities can then be used to quickly locate a document.
Write a Review
Add Favorite
Refer it to Friend
Report Broken Link
Date Added: Oct 10, 2006 Hits: 1 Rating: 0.00 Votes: 0
Category:
Write a Review
Add Favorite
Refer it to Friend
Report Broken Link
Date Added: Oct 10, 2006 Hits: 1 Rating: 0.00 Votes: 0
Member Reviews
Visitor Ratings Google PR
There are a great many statistics that you can perform on your data with simple sql. Sum, Average, Max, Min, and Count can be derived nearly as easy as showing the complete detail of your data. The following example utilizes our db (trade date, closing price and daily volume) of EPOS (@PointofSale.com) stock trading performance. Each of the statistics are available in a dropdown menu and the sql that is used on the daily volume is displayed.
Write a Review
Add Favorite
Refer it to Friend
Report Broken Link
Date Added: Oct 10, 2006 Hits: 4 Rating: 0.00 Votes: 0
Category:
Write a Review
Add Favorite
Refer it to Friend
Report Broken Link
Date Added: Oct 10, 2006 Hits: 4 Rating: 0.00 Votes: 0
Member Reviews
Visitor Ratings Google PR
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
Write a Review
Add Favorite
Refer it to Friend
Report Broken Link
Date Added: Oct 10, 2006 Hits: 1 Rating: 0.00 Votes: 0
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:
Write a Review
Add Favorite
Refer it to Friend
Report Broken Link
Date Added: Oct 10, 2006 Hits: 1 Rating: 0.00 Votes: 0
Member Reviews
Visitor Ratings Google PR
By centralizing database code within ActiveX DLL's, you can simplify your development efforts, and decrease the learning curve for new developers. In this article, we will create a Visual Basic ActiveX DLL that controls database functionality for our Active Server Page (ASP) demo.
Write a Review
Add Favorite
Refer it to Friend
Report Broken Link
Date Added: Oct 10, 2006 Hits: 1 Rating: 0.00 Votes: 0
Category:
Write a Review
Add Favorite
Refer it to Friend
Report Broken Link
Date Added: Oct 10, 2006 Hits: 1 Rating: 0.00 Votes: 0
Member Reviews
Visitor Ratings Google PR
Presenting a large set of data in readable pages is a standard task for Web- application developers. Applications that need to produce search results in a digestible manner need to apply paging algorithms. This article will compare the three ways in which paging can be achieved for an ASP/SQL Server 7 application. The first uses ActiveX Data Object (ADO) paging; the second uses getrows and an array; and the third uses a SQL Server 7 stored procedure. Of those, the third is the most efficient because it returns the minimum set of data from the database server to the Web server
Write a Review
Add Favorite
Refer it to Friend
Report Broken Link
Date Added: Oct 10, 2006 Hits: 2 Rating: 0.00 Votes: 0
Category:
Write a Review
Add Favorite
Refer it to Friend
Report Broken Link
Date Added: Oct 10, 2006 Hits: 2 Rating: 0.00 Votes: 0
Member Reviews
Visitor Ratings Google PR
In Active Server Pages, all strings are enclosed in double quotes ("). For example, if you wanted to pull in all orders from the database, the SQL string would look like this:
Write a Review
Add Favorite
Refer it to Friend
Report Broken Link
Date Added: Oct 10, 2006 Hits: 1 Rating: 0.00 Votes: 0
Category:
Write a Review
Add Favorite
Refer it to Friend
Report Broken Link
Date Added: Oct 10, 2006 Hits: 1 Rating: 0.00 Votes: 0
Member Reviews
Visitor Ratings Google PR
code required for this page is very simple. A database connection is established and the database is queried for the record with the passed in ID. Then, the document's content-type is set to "image/gif" to let the browser know to interpret the coming data as an image. Finally, the Response.Binarywrite method is used to output the binary data from the database. Note how this is actually used in an IMG tag of an HTML page
Write a Review
Add Favorite
Refer it to Friend
Report Broken Link
Date Added: Oct 10, 2006 Hits: 7 Rating: 0.00 Votes: 0
Category:
Write a Review
Add Favorite
Refer it to Friend
Report Broken Link
Date Added: Oct 10, 2006 Hits: 7 Rating: 0.00 Votes: 0
Member Reviews
Visitor Ratings Google PR