View Full Version : How do I create an update form, in a search.asp page.

06-02-2006, 03:51 PM
I have a search.asp page which when submitted transfers to the results.asp page. In the search I would like to also create an insert statement. The search.asp page has the following.

Form: searchForm (Post)
Text Field: KeywordSearch
List Menu: CategoryTable
List Menu: Location
Button: Search

When a client enters data in the search.asp page, I would like for the data, to be submitted to a database at the same time it searches the database. This using an insert statement. The reason for this is so that we can see what everyone is searching for.

The database/table we created has the following.

Table: tblSearches
Field: idSearch (Auto Number)
Field: location (Text)
Field: category (Text)
Field: user (Text)
Field: keyWord (Text)

At the moment I cant create an insert form because of the form that already exists in the search.asp page.

Can anyone suggest what to do.

Ideally it would be good to be able to combine two forms into one, but I am told that this is not possible.