FAQ

USING SEARCH RESULTS INDEPENDENTLY OF SEARCH FORM: NOTE : ASaP was built to have all of the pages work together in concert. The search results page will store those variables that were being searched on from the search form so that when you are later in a detail record and want to go back to your previous search then you can do so without making a new search. If you plan on using the search results page independently then you can simply provide a link to it and if you would like to narrow the search then you can place hardwired criteria within the link. example: http://www.data-asap.com/dogs/dogs_search_results.php?breed=hound .

FIELDS: NOTE : (Access Databses ONLY) Any field that is of type "memo" in your database will automatically get generated on all forms as a larger textarea box. Any field that is of type "boolean" in your database will automatically get generated as a checkbox. If you desire textarea boxes or checkboxes on your forms then it is recommended to first go into your database and make the fields of type memo or boolean accordingly.

If you are using a MySQL database then an additional page will load to give you the choice of choosing which fields from within your database are of type memo or of type checkbox. Fields you choose as memo should be of type "text" in a MySQL environment and those chosen for checkboxes should of the int or numeric type.

DSN: A system name that is given to a database. Ususally, when you want to connect to a database, you have to send a whole bunch of arguments to get the connection going. It is tedious to spell out this information again and again every time you connect to the database, especially because the information never changes. DSNs were created to fix this problem. A DSN lets you store in one place all that information you normally have and give it a name. For instructions on how to setup a DSN on your system click here

(PWS) Personal Web Server/ (IIS) Internet Information Server : A free utility from Microsoft that makes it possible for you view ASP pages from a PC. Please visit www.microsoft.com and search for either Personal Web Server or Personal Web Manager.

Are there any rules to follow when creating my Database?

See the errors page for more details on this.