Sometimes, SQL failure that I am, I just dump it all in a variable and look through it using LiveCode. It depends how big although LiveCode is pretty quick.
On Tue, Jan 25, 2011 at 9:07 AM, Tiemo Hollmann TB <toolb...@kestner.de>wrote: > Hello, > > I have seen this feature before, but have no idea what approach is behind > the scenes since I am not that deep in SQL. > > I have a SQL select with multiple search criterias. After selecting a > criteria, I get the resulting records and can go on narrowing my search > with > selecting one or multiple other criterias. So far nothing special. What I > am > interested in is, how do you show (and disable) one or multiple search > criterias, if they would be inaffective for further searches, because there > is no content left to narrow the search with this criteria. > > > > I could think of looping through the result for each criteria after having > made one selection and if there is nothing left to search for then disable > the search criteria. But with multiple search criterias, each with multiple > options, I don't know if this would be "state of the art" to keep a good > performance, or if there are more sophisticated approaches to let the user > just make click-click-click narrowing his search with simultaneous showing, > what other selection makes sense and what not. > > > > Hoping you understood what I mean J > > Thanks for any idea > > Tiemo > > > > > > _______________________________________________ > use-livecode mailing list > use-livecode@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode > -- http://www.bluewatermaritime.com _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
