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
Name Search & Hyperlinks to Detail
2582
Name Search & Hyperlinks to Detail
http://www.codeave.com/asp/code.asp?u_log=96
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.
ASP > Tips and Tutorials > Database-related
Oct 10, 2006
Write a Review
Add to My Favorite
Refer it to Friend
Report Broken Link
| |
|
||
| Bookmark Name Search & Hyperlinks to Detail: |
|||
Other links at ASP > Tips and Tutorials > Database-related
Active Server Pages allow us an easy means of querying and updating a database from a webpage. This article describes the basics of using this technique in a nutshell. The examples given here utilize a Microsoft Access database, but the principles elucidated apply equally well to ASP integration with other databaes. (Access has been selected because it is widely familiar, easy to use, and adequate for many small to medium-sized projects.)
Category:
Multiple Recordsets - the ability to stuff multiple SQL query results into one Recordset - is an ADO feature that's few developers are aware of. In this article, we are going to take a look on what a Mutliple Recordset is, exactly, and how it can make your development life easier (and your code more efficient). But before we start examining Multiple Recordsets, let's look at a common task in ASP and how it is handled without using Multiple Recordsets.
Category:
We can use several providers to open DBF files usind ADODB. Basic way is to use ODBC data source (DSN or DSNless), there is several samples published on web. But how to open DBF files without ODBC? There are two other OLEDB providers, using which you can work with DBF files. One of them is Microsoft.Jet.OLEDB.
Key property to work with DBF files is "Extended Properties" - there is no much info about this parameter in documentation. This parameter has similar meaning as connect parameter in DAO OpenDatabase method. First work is to open connection to DBASE IV files:
Key property to work with DBF files is "Extended Properties" - there is no much info about this parameter in documentation. This parameter has similar meaning as connect parameter in DAO OpenDatabase method. First work is to open connection to DBASE IV files:
Category:
When you're querying a Db typically you're looking for an exact match (=), less than (<), greater than (>), less than or equal to (<=), greater than or equal to (=>), or not equal to (< >). Which give you quite a number of ways that you can display your data, but with these operators a partial match is not allowed. In order to facilitate a partial match the like operator must be used and it's entirely up to you how that match is made. The example db contains most of the Titles, AirDates and What Bart Simpson writes in the blackboard at the beginning of The Simpson's (TM).
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:
Main Category
200
2047
830
286
175
1804
1573
913
1177
7596
70
919
60
2247
175
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: 20048
Categories: 1275
Registered Users: 789
Mailing List Subscribers: 2049
Unique Outgoing Hits: 234591
Pagerank Statistics
PHP News