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 <[email protected]> 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 > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
