I have basically completed a management interface for one of our clients 
using zope. I have your standard product and order management. If a customer 
orders something that is out of stock I need to create a back order.

I add an order in a query called addorder, in this I need to set up an if 
statement to make sure their is enough product in stock. I have a seperate 
query called onhand, this selects a product and returns instock a field 
containing the number in stock of a product. I need to pull instock from 
this query and subtract quantity they entered in the form and find out if 
the result is greater than or equal to zero. I have the insert statement and 
everything else I just can't figure out how to call instock from the onhand 
query and quantity from REQUEST (I think it is still in request even though 
i am in a ZSQL method) and then test if the result is greater than or equal 
to 0.

If anyone could help me with this it would be greatly appreciated.
________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com


_______________________________________________
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )

Reply via email to