AW: [Mapserver-users] Re: On-the-fly generated picklists in query-forms

[Roman Meier]

Hi

It seems, that everything is perfectly clear to you. The problem for me is
point no 2. How can I query the tables and get the values to build the form
using php/mapscript? Did you do something like this before?

Thanks for help and patience, Roman



-----Ursprüngliche Nachricht-----
Von: mapserver-users-admin at lists.gis.umn.edu
[mailto:mapserver-users-admin at lists.gis.umn.edu]Im Auftrag von
pkishor_98
Gesendet: Sonntag, 26. Oktober 2003 14:41
An: mapserver-users at lists.gis.umn.edu
Betreff: [Mapserver-users] Re: On-the-fly generated picklists in
query-forms


--- In mapserver-users at yahoogroups.com, "Roman Meier" <mapserver at g...>
wrote:
> Hi again
>
> Sorry, let me try again and give you some more informations on what I'm
> planning to do...
>
> The user of my webgis will be able to add values to the database (postgis)
> and to query the data using a form. That's why I dont want to use a common
> picklist in the form because I dont know what values have been entered by
> the user. The picklist must be generated on-the-fly.
>
> I hope, things are more clear now...


unfortunately they are not. Because your problem seems to be exactly the
same as
what you stated earlier. Let me try to break it up into its components --

1. User enters info in a database table (or tables).
2. You query those tables to get some values with which you generate a form
on the
fly.
3. User picks values from that form.
4. Query the database again to get the details on the record queried.

So where is the problem? Everything is being generated on the fly...




>
> -----Ursprüngliche Nachricht-----
> Von: mapserver-users-admin at l...
> [mailto:mapserver-users-admin at l...]Im Auftrag von
> pkishor_98
> Gesendet: Samstag, 25. Oktober 2003 22:33
> An: mapserver-users at l...
> Betreff: [Mapserver-users] Re: On-the-fly generated picklists in
> query-forms
>
>
> --- In mapserver-users at yahoogroups.com, "Roman Meier" <mapserver at g...>
> wrote:
> > Hi list
> >
> > A bit off topic maybe...
>
> really ;-)
>
> >
> > I would like to implement an unconventional picklist in my queries.
Using
> a
> > form, the user should have the possibility to select the searchstring
out
> of
> > a picklist. The picklist is generated on-the-fly(!). The function
searches
> > the table (postgis, mysql or dbf) for all items, that have been entered
> > before...
> >
> > - Did somebody do something like this before?
> > - How can I implement this using php/mapscript and postgis?
> > - Any ideas?
> >
>
> given that you are asking this, I am going to assume there is something
> specific here
> that is out of the ordinary... I mean, this is one of the commonest
devices
> one sees on
> the web, so why...?
>
> Anyway -- assuming you want to populate a form using values from a
table --
>
> 1. query the table for values and text, and create a form
>
> select values, text from table where whatever
>
> <option value=$value>$text</option>
>
> and then use the $value to query the database for the results.
>
> If you want something that focuses on the items as you type characters,
you
> can fill a
> javascript array with the $text values, and then use onkeypress to trap
the
> characters
> as they are typed, search through the array, calculate the selectedindex
and
> focus on
> the fly. Is that what you asking?
>
> If it is something else you are asking, my apologies -- I didn't
understand
> the
> question.
>
>
> _______________________________________________
> Mapserver-users mailing list
> Mapserver-users at l...
> http://lists.gis.umn.edu/mailman/listinfo/mapserver-users
>
>
> _______________________________________________
> Mapserver-users mailing list
> Mapserver-users at l...
> http://lists.gis.umn.edu/mailman/listinfo/mapserver-users


_______________________________________________
Mapserver-users mailing list
Mapserver-users at lists.gis.umn.edu
http://lists.gis.umn.edu/mailman/listinfo/mapserver-users