Andrey Subbotin <[EMAIL PROTECTED]> wrote:
> I want to supply a query form on a web page that would contain these
> parameters as selectable lists of unique values. Should be smth. like
> this:
>
> * Choose articles you want to be listed:
> Name: <a concrete name> or <all>
> Color: <a concrete color> or <all>
> Price: <a concrete price> or <all>
>
> Using SQL I'd issue the following queries, to obtain the corresponding list
> values:
>
> SELECT distinct name FROM article;
> SELECT distinct color FROM article;
> SELECT distinct price FROM article;
>
> These queries would be quite fast and I even could apply a desired
> ordering using ORDER BY to them...
After all I think that You could simply use articles, topics objects
with some class which extends midgard objects.
That way You have all midgard functionality and own functions.
Managing with new class object You may simple call for own functions like
get_my_car_color("red"); with custom mgd_get_article() at the same time.
BTW , I think that midgard needs some kind of extended midgard objects clases
repository
which would be helpfull with writing own applications.
Piotras
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
