hi, Anyone know how to solve, I have a program as follows: However, it only can search one by one. However, if I want to do multiple criteria search as according program.
YOu can see the result page on the url:
Once I input "15" on the textbox under by weight and two more criteria such as I input "streaky" under item category and "blue-yellow" under color column. Now all together 3 criteria. The result will only display
as follows with very precise search in 3 inputted criteria, it can be type in.
However, the following code only can do one by one search. For instance,
I input "15" on the by weight, it sort all of the "15" of the weight of the entire database. It can't be multiple criteria to search. How can I work it out with following source code of SQL.
It appears to me that your problem is viewing the page as presenting six different searches, each one of which is based on a single column. What you seem to want is one search, with zero (or maybe one) to six columns.
The way to get to that point is to have a single search button, that triggers code to look at the six different values that the user can specify, and generates a query based on those specifications. You can use the following snippet of code as a start, but you'll have to add some conditional processing to manage how you want the user's selections handled:
searchtradenameAZSQL = "select " & _
" products.name as ProductName, suppliers.name as SupplierName," & _
" weight.name as WeightName, color.name as ColorName," & _
" tradename.name as TradeName, suppliers.ID as SupplierID" & _
" FROM pointers" & _
" JOIN products ON (products.id = pointers.Productid)" & _
" JOIN tradename ON (tradename.id = pointers.tradenameid)" & _
" JOIN suppliers ON (suppiers.id = pointers.supplierid)" & _
" JOIN weight ON (weight.id = pointers.weightid)" & _
" JOIN color ON (color.id = pointers.colorid)" & _
" WHERE " & _
" weight.name like '"& inparam &"' and " & _
" order by weight.name"