|
aapkajaanu
Starting Member
19 Posts |
 Posted - January 31 2007 : 01:10:41
|
Hi, i am using the following statements for display categories and sub categories on supplier id, but this returns me all the subcategories, can anyone help...plz
SQL="Select * from categories "
sql = Sql & " where highercategoryid=" & highercategoryid
if Request("suplid")<>"" then
if Request("id")<>"" then
sql=sql & " and (highercategoryid in (select ccategory from products where supplierid="& Request("suplid") & ")) "
else
sql=sql & " and (categoryid in (select ccategory from products where supplierid="& Request("suplid") & ")) "
end if
end if |
|
All Forums
shopcategories, needz help!!
New Topic
Printer Friendly
Topic 
TrustGuard - PCI Security Scanner
