Sorry, I probably should've been clearer. I do have the data in place to filter by color. The problem is I can't get the image.filenames returned in the desired order. Even if I wanted to use group_concat, I still would want them in a particular order (based on images.position).
On Wed, Nov 10, 2010 at 2:30 PM, Jim Morris <jmor...@bearriver.com> wrote: > There is no logic way to show you intended result. You need some sort > of data that can be used as a filter. > > If you want to filter by color why not add color to the item and use a > WHERE clause? Or maybe style? > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users