hi, Anyone know if I want two criteria including tradename and weight these two criteria to search.
Then you can see the line syntax of
" tradename.name like '"& inparam &"' and " & _
Now, I want to add one more let say
" tradename.name, weight.name like '"& inparam &"' and " & _
for the sql syntax. Then I created a single search button called by
criteria search. Once I input tradename on the by item category and
I also input the weight on the by weight textbox and press the single
search button on the bottomneath. What will be the correct snipple code
The url is : http://internal.quickentextiles.com.hk/sampleroom/byall.asp?searchtype='Alph'
searchtradenameAZSQL = "select products.name as ProductName, suppliers.name as SupplierName, weight.name as WeightName, color.name as ColorName, twill.name as twillName, " & _
" tradename.name as TradeName, suppliers.ID as SupplierID " & _
" from products, tradename, suppliers, weight, color, twill, pointers where " & _
" tradename.name like '"& inparam &"' and " & _
" pointers.Productid = products.id and " & _
" pointers.supplierid = suppliers.id and " & _
" pointers.weightid = weight.id and " & _
" pointers.colorid = color.id and " & _
" pointers.twillid = twill.id and " & _
" pointers.tradenameid = tradename.id order by weight.name, tradename.name, color.name, twill.name, products.name"
My killer sig came courtesy of bb "El Jefe" mayo.
The Forum Rules You Agreed To!http://forums.afterdawn.com/thread_view.cfm/2487 "And there we saw the giants, and we were in our own sight as grasshoppers, and so we were in their sight" - Numbers 13:33
This message has been edited since posting. Last time this message was edited on 7. September 2004 @ 11:42
