Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › PowerStore › Powerstore General / Announcements › Combining 3 databases in cart

Combining 3 databases in cart

Thread began 7/28/2009 9:18 pm by danjen | Last modified 7/29/2009 9:42 am by Ray Borduin | 1199 views | 1 replies |

7/28/2009 9:18 pm | #1 danjenBeta Tester

Combining 3 databases in cart

I am pulling from 3 different product databases in the shopping cart. I used the default products table for one of the databases and I want to validate the stock levels for this table only. For the other 2 databases that I am using in the cart I do not want it to use the stock validation as all of this product is considered unlimited. How can I have the shopping cart and confirm page only validate the stock levels of the items in the products table and ignore the other 2 tables.

Thanks

7/29/2009 9:42 am | #2 Ray BorduinWebAssist

You would have to update the logic and/or query that validates the stock on the cart, checkout, and confirm pages.

You might be able to save some work by adding a view with a union join so that it appears as if it comes from one table and just write the view such that the ProductUnlimited field is set to 1 for the other two tables.

Did this help? Tips are appreciated...

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.