[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