Database Search in ASP (Full Version)

All Forums >> [Web Development] >> ASP and Database



Message


yhm2 -> 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 -> 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




Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.03125