|
| |
|
|
yhm2
Posts: 12
Joined: 3/14/2006
Status: offline
 |
Database Search in ASP - 3/14/2006 16:45:49
Hi,
I just built a website using FrontPage 2003 that works in conjunction with a chemical database I use in Access 2003. In the site I have created, mostly through tutorials, I have two problems.
The first is that whenever I search for a chemical, no results appear, even if the chemical is in my database. I don't see any problem with my query yet this problem recurs. I have two search pages, one on the page right after logging in (bottom divisio) and one unser the link 'search page' on the top menu.
The second problem is on the page that displays the results (top division of the first page after login). While my database has hundreds of chemicals, only 204 are displayed here. I have removed any lmits I could find but this persists.
The database is online right now at:
http://foodmicro.foodsci.cornell.edu/inventory/realinventory_interface/Inventory/editor/Login.asp?requester=database_editor.asp
The user name and password are both 'test' (no quotes), so if anyone can take a look at it I would be very grateful.
Thanks!
|
|
|
|
dpf
Posts: 7121
Joined: 11/12/2003
From: India-napolis
Status: offline
|
RE: Database Search in ASP - 3/14/2006 16:57:18
first of all - you are making your life more difficult by using frames on this site - you might reconsider that choice!!!
second, it is generally better to provide a drop down selection for searches rather than allow users to type in names. this ensures that any selection will actually be in your database and prevents spelling errors. you could populate the drop down from your database with asp
third... the frame page where your form is is details.asp
it appears that the form is submitting to itself!!!
quote:
<form BOTID="0" METHOD="POST" action="detail.asp"> which is why you arent getting any results
_____________________________
Dan
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
