I incorporated this into CVS.
Thanks,
Leon
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Jon Griffin
> Sent: Sunday, December 19, 1999 8:57 PM
> To: FreeTrade
> Subject: [FreeTrade] Another enhancement
>
>
> If you change the query in item_functions to the following you will only
> get items that are in stock for the random item. This was a
> problem for my
> client but the fix was easy.
>
> select item.id from item,sku,inventory
> where item.id = sku.item and
> sku.id = inventory.sku and
> inventory.available > 0
>
>
> Thanks,
> Jon Griffin
> [EMAIL PROTECTED]
>
> Check out:
> <http://www.salsablanca.com>
> <http://www.jongriffin.com>
>
>
>
> ------------------------------------------------------------
> To subscribe: [EMAIL PROTECTED]
> To unsubscribe: [EMAIL PROTECTED]
> Site: http://www.working-dogs.com/freetrade/
> Problems?: [EMAIL PROTECTED]
>
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Site: http://www.working-dogs.com/freetrade/
Problems?: [EMAIL PROTECTED]
