[ic] Re: Ebay Feed - MySQL Query Problem

Gert van der Spoel ic at 3edge.com
Sun May 14 06:39:10 EDT 2006


William Fiore writes: 

> Gert van der Spoel Writes: 
> 
>>I suggest you try the command on the mysql command line first to see if you
>>get any results. AFAIK this response means that you got an empty result set
>>returned (perhaps no products added today - no products with more than 5 in
>>stock?) ... 
>>
>>If this is the case then you will have to catch this error.
> 
> Gert, 
> 
> You were right. I changed "CurrentDate()" to "CurrentDate() -90" and I am
> getting some results. Do you have any idea how I can also only display
> sku's that are located in the "sku" column of my "orderline" table. 
> 

Untested, no guarantees: 

SELECT * FROM products WHERE sku = ANY (SELECT sku FROM inventory
WHERE quantity > 5) AND date_added >= curdate() AND sku = ANY (SELECT sku 
FROM orderline) 

CU, 

Gert 



More information about the interchange-users mailing list