You can change your query to query for the column ical instead. I designed the table om_timezones that way that the column ical is unique.
Sebastian 2012/4/23 Maxim Solodovnik <[email protected]>: > Can you please advise me what is the best way of handling user input for > timezone? > The way I have implemented in cli-admin was: > user enters GMT+2 or GMT-1 and gets the timezone. > > I can implement search in java timezones, and then try to map java timezone > with OM timezone. > In this case user can enter Berlin as timezone. > > What do you think? > > > On Mon, Apr 23, 2012 at 10:31, Maxim Solodovnik <[email protected]> > wrote: >> >> Hello Sebastian, >> I used it for Cl Admin only, I'll revert my change back and will correct >> the code in Admin to get timezone and do not affect other code. >> >> >> On Fri, Apr 20, 2012 at 20:13, [email protected] >> <[email protected]> wrote: >>> >>> Hi Maxim, >>> >>> do you remember where exactly you are using the GMT+1% query? >>> >>> Cause we have a problem that will start soon to get annoying: >>> There will be multiple GMT+1 for example, cause there is >>> GMT+1 Summer Daylight Time Europe/Berlin >>> GMT+1 (No Summer Daylight Time) Africe/Tunis for example >>> >>> There will be the same problem with other timezones. >>> Where are you currently using this query, is it only the installer at >>> the moment or are there other components using it too? >>> >>> Thanks! >>> Sebastian >>> -- >>> Sebastian Wagner >>> https://twitter.com/#!/dead_lock >>> http://www.openmeetings.de >>> http://www.webbase-design.de >>> http://www.wagner-sebastian.com >>> [email protected] >> >> >> >> >> -- >> WBR >> Maxim aka solomax > > > > > -- > WBR > Maxim aka solomax -- Sebastian Wagner https://twitter.com/#!/dead_lock http://www.openmeetings.de http://www.webbase-design.de http://www.wagner-sebastian.com [email protected]
