 
		
		  
		   | This is an overview of SYSTEM  Dropdowns or combo boxes are  Compact and repair your  Allowing multiple choices of  DSN's, DSN-LESS Connections,  an excellent way to get  access database online from  data elements enables people  and any database permissions  input from a user. One of  ASP code. This is example  to customize views of your  that may need to be set on  the biggest problems with  code of how this can be done.   data and adds value to your  the server. Helpful for  user input is spelling and  applications. In this sample  people just learning ASP as  formatting. Here is how to  code, user inputted  well as people with some  use and populate dropdowns  choice(s) are added to the  experience.  from a database.  basic sql statement to draw  them from the db. Since the  input from the dropdown menu  comes through comma  delimited it is simply  written into the statement  without modification. Two  simple for next loops  determine which elements are  part of the record set and  displays them accordingly.  Date: Mar, 22 2001 Date: Aug, 05 2002 Date: Jan, 23 2002 Date: Aug, 06 2000 | 
| The purpose of this article  An article on connecting to  Storing frequently used  Multiple level select boxes  is to show how to get  database via ASP using both  lookup data in a database is  tackled with hierarchical  records from an html form  DSN and DSN less  a great idea (e.g. order  data! This sample  and submit that form to an  connections. Explains uses  status codes, state names,  illustrates the concept  ASP page. This ASP page will  of each. Learn using  etc.) that saves tremendous  using a hierarchy consisting  then use SQL to enter the  connection strings.  amounts of time in design  of geographical region,  records into the database.  and maintenance. However,  country, and state data. The  retrieving that data from  code expects a system DSN by  the database every time it  name "Hierarchy"  is needed is very  and accesses the database  inefficient. This article  using the user id  describes how to use  "sa" with a blank  Application variables to  password. The database is  cache frequently used lookup  created in SQL Server 7.0.  data in memory to achieve  lightning fast access times.  Date: Jun, 11 2000 Date: Dec, 03 2000 Date: Jun, 28 2000 Date: Jun, 13 2000 |