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]
