VP-ASP :: Shopping Cart Software

Shopping Cart Software Solutions for anywhere in the World

US/Canada(Toll Free): +1 888 587 2278
Europe/UK: +44 (020) 7193 9408
Australia/New Zealand: +61 3 9016 4497

VP-ASP Shopping Cart Customer Forum

Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 VPCart Forum
 Customization
 shopcategories, needz help!!
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

aapkajaanu
Starting Member

19 Posts

Posted - January 31 2007 :  01:10:41  Show Profile  Reply with Quote
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

Kidd
VP-ASP Super User

Australia
373 Posts

Posted - January 31 2007 :  04:57:41  Show Profile  Reply with Quote
well have you got the value of suplid set?
Go to Top of Page

aapkajaanu
Starting Member

19 Posts

Posted - February 01 2007 :  03:13:08  Show Profile  Reply with Quote
what do u mean by that? can u write the code for me? actually i cant get the subcategories against each supplier..
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000