[ic] Re: Ebay Feed - MySQL Query Problem

["Gert van der Spoel" <suppressed>]

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 

_______________________________________________
interchange-users mailing list
suppressed
http://www.icdevgroup.org/mailman/listinfo/interchange-users