Products ASPProc
where can i download this products ?ASPProc / ASPWait from ServerObjects ?or exist other products like them ?
View Replies
ADVERTISEMENT
Absolute Products The Best For ASP!
I recently stumbled across a great company with wonderful products for easy integration within ASP pages. I've even created a community forum to support the products on my site.
View Replies View RelatedGetrows For Categories Then Products
im developing a Product configurator (just like alienware use) where in my database i have
(systems table) a list of PC systems
systemID
(categories table) a list of PC product categories (ie. CPU, RAM...)
categoryID
(products table) a list of all products
productID, catID
(link table)
sysID and prodID
Now before i put the code ive done so far, let me explain that the first page lists all systems wich then gives the systemID for the link table. Once this page loads it needs to go through each category then list the products available to that category where sysID = systemID. Now a query i put together to list all products for that sysID is:
select * from PRODUCTS inner join link on link.prodID = PRODUCTS.productID where link.sysID=systemID
Now this query works great and lists all of the products for that systemID, but what im unable to do is (using GetRows()) have the category name listed as a title then have each product under the respected category. Code:
Add/delete Products From Catagories In Admin System For Shopping Cart
I have a problem with adding and deleting the categories that a product is added to within a shopping cart administration system. My tables are designed as follows:
Table: Products
Uid: autonumber
Name: text
etc
Table: ProductCategory
Uid: autonumber
ProductID: number
CategoryID: number
Table: Category
Uid: number
Name: text
Etc
When I add a product to the database I also add the same product to different categories i.e. I insert product info into Products and the product unique ID into the ProductCatgory table, which links to the Category table. The ProductCatgory is the table that links both the Products and the Category table together when I construct queries. This all works fine and I am able to add a product to multiple categories and then display the categories/product accordingly in the actual shopping cart. Code: