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

[pkishor_98]

--- 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