- Remote Scripting (Part 3)
Learn how to query databases and returning values without leaving the page. This 3rd tutorial on Remote Scripting shows how to do this, and cache all relevant data.
http://bio-mechanical.net/v5/Article.asp?id=13
(Rating: 0.00 Votes: 0)
Rate It
Review It
- Search Database
This example / tutorial explains how to use the LIKE operator to perform a partial match on an Access database.
http://www.codeave.com/asp/code.asp?u_log=45
(Rating: 0.00 Votes: 0)
Rate It
Review It
- Search db by Field
Providing search capabilities to a db enables users to query on whichever element you target them to. However allowing users to target which portion of the db they would like to query gives extra value. In this example, utilizing our db of US States (state, statename, and capital) the user can search in any of three fields (by dropdown menu input) rather than the application targeting one specific table element. Note: The db only has 50 observations in it, so it is better to search on single or double letter combinations.
Price: Free
http://www.codeave.com/asp/code.asp?u_log=102
(Rating: 0.00 Votes: 0)
Rate It
Review It
- Search Within Search Results
Want to add value to your current search\? Allow your users to search from within search results. As databases grow the necessity for the user to continually narrow a search to the item that they truly want will grow also. The following example utilizes a db on U.S. State capitals. Upon the first search two radio buttons will appear indicating a search (default) or a search within the current results. Searching within the current results will take the first search and add it to the new search and so on.
Price: Free
http://www.codeave.com/asp/code.asp?u_log=97
(Rating: 0.00 Votes: 0)
Rate It
Review It
- Simple Table Display With Where Clause (Hard Coded)
Displaying specific subsets of data from a database is easy to accomplish in .asp. The following example utilizes an Access database of Mark "The Bird" Fidrych and displays all of his season statistics for 1976 contained in the database rather than displaying the entire db.
Price: Free
http://codeave.com/asp/code.asp?u_log=36
(Rating: 0.00 Votes: 0)
Rate It
Review It
- Simple Web-Database System Application
This article will show how to connect an Access database to your Active Server Pages using Microsoft FrontPage. This is a beginning-level article with plenty of screen shots to show how to connect via ODBC, generate a SQL query in Access and construct the Active Server Page.
Price: Free
http://www.15seconds.com/issue/990318.htm
(Rating: 0.00 Votes: 0)
Rate It
Review It
- SQL: Sum, Average, Max, Min, Count, Detail
This example shows how to perform a variety of statistics on your data using simple SQL such as Sum, Average, Max, Min, and Count. It uses stock trading performance of EPOS as an example.
http://www.codeave.com/asp/code.asp?u_log=22
(Rating: 0.00 Votes: 0)
Rate It
Review It
- Turn foreign keys into list boxes
The author writes "CoverYourASPs original database administration tool didn look for foreign keys, and just displayed a confusing list of primary key values. Now, its been improved with automatically generated list boxes." This tutorial explains how to turn those foreign keys into list boxes automatically.
Platform: ASP 2.0 (JavaScript)
http://CoverYourASP.com/ForeignKeys.asp
(Rating: 0.00 Votes: 0)
Rate It
Review It
- Two Table Join
Outputting data from two tables is almost as easy as displaying from one. This example utilizes twotables with state information on them. The first table (state_order) contains state abbreviations (state), state names (statename) the year each state was admitted into the union (year) and the numeric order they entered in (entered). The second table (state_capitals) contains state abbreviations (state), state names (state) and state capitals (capital). The where statement looks to make a match on the field that each table has in common to ouput the correct capital with all the info from the state_order table.
Price: Free
http://www.codeave.com/asp/code.asp?u_log=20
(Rating: 0.00 Votes: 0)
Rate It
Review It
- Using Functions to Connect to Multiple Databases
This is a little script that will allow you to place multiple database connections in the same script without executing them (which would waste server resources). How this works is that you make up a setup file that contains all your connections in functions. In this file you can also contain some global variable values such as the color of certain text or any other general universal variable.
Version: 1.0
Platform: Win NT
http://www.leenas.net/asp/articles/funct_conn_db.asp
(Rating: 0.00 Votes: 0)
Rate It
Review It
|
