querying database through a html form [message #36118] |
Tue, 06 November 2001 09:47 |
Dan Maranan
Messages: 1 Registered: November 2001
|
Junior Member |
|
|
This should be a simple script, but I am having difficulty figuring out how to do it.
Basically I want to query a database column through PL/SQL via the web.
For example, lets say a user wants to find all instances of “computer, keyboard, and mouse” in my database. I want to be able to search through a column and find all instances where those terms exist.
On a form in html users input their search parameters (computer keyboard mouse).
Those parameters are than passed to a variable (search_param = computer keyboard mouse);
Finally a search is done based on those parameters in SQL:
SELECT *
FROM table_computer
where column_hardware in (search_param);
Unfortunately this doesn’t work. Any ideas?
----------------------------------------------------------------------
|
|
|
|
|