RE: Time Zone Select

2000-10-03 Thread dougn 

Another approach might be to have a hidden field to store the date.  Then
when the browser loads, use JavaScript to fill that field with the date.
That date will be the PC's date.  When the form is submitted, compare that
to the server's #Now()# timestamp using DateDiff and you'll know how many
hours +/- you need to adjust the time for.  Either store that value (ex: -6)
in a members table, or use it to determine the timezone they are in and
store a timezone code.

--Doug
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Time Zone Select

2000-10-02 Thread lsellers 



 Anyone out there have a custom tag or data table that would allow me to
 easily include a select box for choosing time zone?

Make a 24-piece rollover of the earth. Then just let them click where they
are. Easire than choosing by text -- no one knows what the hell time zone
they're in. :)

--min

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Time Zone Select

2000-10-02 Thread Jaime Garza 

Long one, but here it goes.  SQL server compliant.  Missing Daylight Saving
Times.

CREATE TABLE DirTimeZone (
TimeZoneID int IDENTITY (1, 1) NOT NULL ,
Name varchar (50) NULL ,
Offset varchar (50) NULL
)
GO

insert into DirTimeZone (Name, Offset)
values ('ACT', 'GMT+09:30')
go

insert into DirTimeZone (Name, Offset)
values ('AET', 'GMT+10:00')
go

insert into DirTimeZone (Name, Offset)
values ('Africa/Abidjan', 'GMT+00:00')
go

insert into DirTimeZone (Name, Offset)
values ('Africa/Accra', 'GMT+00:00')
go

insert into DirTimeZone (Name, Offset)
values ('Africa/Addis_Ababa', 'GMT+03:00')
go

insert into DirTimeZone (Name, Offset)
values ('Africa/Algiers', 'GMT+01:00')
go

insert into DirTimeZone (Name, Offset)
values ('Africa/Asmera', 'GMT+03:00')
go

insert into DirTimeZone (Name, Offset)
values ('Africa/Bangui', 'GMT+01:00')
go

insert into DirTimeZone (Name, Offset)
values ('Africa/Banjul', 'GMT+00:00')
go

insert into DirTimeZone (Name, Offset)
values ('Africa/Bissau', 'GMT+00:00')
go

insert into DirTimeZone (Name, Offset)
values ('Africa/Blantyre', 'GMT+02:00')
go

insert into DirTimeZone (Name, Offset)
values ('Africa/Bujumbura', 'GMT+02:00')
go

insert into DirTimeZone (Name, Offset)
values ('Africa/Cairo', 'GMT+02:00')
go

insert into DirTimeZone (Name, Offset)
values ('Africa/Casablanca', 'Greenwich Mean Time')
go

insert into DirTimeZone (Name, Offset)
values ('Africa/Conakry', 'GMT+00:00')
go

insert into DirTimeZone (Name, Offset)
values ('Africa/Dakar', 'GMT+00:00')
go

insert into DirTimeZone (Name, Offset)
values ('Africa/Dar_es_Salaam', 'GMT+03:00')
go

insert into DirTimeZone (Name, Offset)
values ('Africa/Djibouti', 'GMT+03:00')
go

insert into DirTimeZone (Name, Offset)
values ('Africa/Douala', 'GMT+01:00')
go

insert into DirTimeZone (Name, Offset)
values ('Africa/Freetown', 'GMT+00:00')
go

insert into DirTimeZone (Name, Offset)
values ('Africa/Gaborone', 'GMT+02:00')
go

insert into DirTimeZone (Name, Offset)
values ('Africa/Harare', 'GMT+02:00')
go

insert into DirTimeZone (Name, Offset)
values ('Africa/Johannesburg', 'GMT+02:00')
go

insert into DirTimeZone (Name, Offset)
values ('Africa/Kampala', 'GMT+03:00')
go

insert into DirTimeZone (Name, Offset)
values ('Africa/Khartoum', 'GMT+02:00')
go

insert into DirTimeZone (Name, Offset)
values ('Africa/Kigali', 'GMT+02:00')
go

insert into DirTimeZone (Name, Offset)
values ('Africa/Kinshasa', 'GMT+01:00')
go

insert into DirTimeZone (Name, Offset)
values ('Africa/Lagos', 'GMT+01:00')
go

insert into DirTimeZone (Name, Offset)
values ('Africa/Libreville', 'GMT+01:00')
go

insert into DirTimeZone (Name, Offset)
values ('Africa/Lome', 'GMT+00:00')
go

insert into DirTimeZone (Name, Offset)
values ('Africa/Luanda', 'GMT+01:00')
go

insert into DirTimeZone (Name, Offset)
values ('Africa/Lubumbashi', 'GMT+02:00')
go

insert into DirTimeZone (Name, Offset)
values ('Africa/Lusaka', 'GMT+02:00')
go

insert into DirTimeZone (Name, Offset)
values ('Africa/Malabo', 'GMT+01:00')
go

insert into DirTimeZone (Name, Offset)
values ('Africa/Maputo', 'GMT+02:00')
go

insert into DirTimeZone (Name, Offset)
values ('Africa/Maseru', 'GMT+02:00')
go

insert into DirTimeZone (Name, Offset)
values ('Africa/Mbabane', 'GMT+02:00')
go

insert into DirTimeZone (Name, Offset)
values ('Africa/Mogadishu', 'GMT+03:00')
go

insert into DirTimeZone (Name, Offset)
values ('Africa/Monrovia', 'GMT+00:00')
go

insert into DirTimeZone (Name, Offset)
values ('Africa/Nairobi', 'GMT+03:00')
go

insert into DirTimeZone (Name, Offset)
values ('Africa/Ndjamena', 'GMT+01:00')
go

insert into DirTimeZone (Name, Offset)
values ('Africa/Niamey', 'GMT+01:00')
go

insert into DirTimeZone (Name, Offset)
values ('Africa/Nouakchott', 'GMT+00:00')
go

insert into DirTimeZone (Name, Offset)
values ('Africa/Ouagadougou', 'GMT+00:00')
go

insert into DirTimeZone (Name, Offset)
values ('Africa/Porto-Novo', 'GMT+01:00')
go

insert into DirTimeZone (Name, Offset)
values ('Africa/Sao_Tome', 'GMT+00:00')
go

insert into DirTimeZone (Name, Offset)
values ('Africa/Timbuktu', 'GMT+00:00')
go

insert into DirTimeZone (Name, Offset)
values ('Africa/Tripoli', 'GMT+01:00')
go

insert into DirTimeZone (Name, Offset)
values ('Africa/Tunis', 'GMT+01:00')
go

insert into DirTimeZone (Name, Offset)
values ('Africa/Windhoek', 'GMT+01:00')
go

insert into DirTimeZone (Name, Offset)
values ('AGT', 'GMT-03:00')
go

insert into DirTimeZone (Name, Offset)
values ('America/Adak', 'GMT-10:00')
go

insert into DirTimeZone (Name, Offset)
values ('America/Anchorage', 'Alaska Standard Time')
go

insert into DirTimeZone (Name, Offset)
values ('America/Anguilla', 'GMT-04:00')
go

insert into DirTimeZone (Name, Offset)
values ('America/Antigua', 'GMT-04:00')
go

insert into DirTimeZone (Name, Offset)
values ('America/Aruba', 'GMT-04:00')
go

insert into DirTimeZone (Name, Offset)
values ('America/Asuncion', 'GMT-04:00')
go

insert into DirTimeZone (Name, Offset)
values ('America/Barbados',

RE: Time Zone Select

2000-10-02 Thread Sean Daniels 

Thank you very much, this will work beautifully.

By the way, I liked the map suggestion too, but not practical for the GUI
implementation. Thanks.


- Sean

~~
  Sean Daniels
  Manager, Engineering
  (T): 207.439.6030
  (C): 978.764.0799
~~
  http://www.dealforce.com
  http://www.mergernetwork.com



 -Original Message-
 From: Jaime Garza [mailto:[EMAIL PROTECTED]]
 Sent: Monday, October 02, 2000 1:54 PM
 To: CF-Talk
 Subject: RE: Time Zone Select


 Long one, but here it goes.  SQL server compliant.  Missing
 Daylight Saving
 Times.

 CREATE TABLE DirTimeZone (
   TimeZoneID int IDENTITY (1, 1) NOT NULL ,
   Name varchar (50) NULL ,
   Offset varchar (50) NULL
 )
 GO

 insert into DirTimeZone (Name, Offset)
 values ('ACT', 'GMT+09:30')
 go

 insert into DirTimeZone (Name, Offset)
 values ('AET', 'GMT+10:00')
 go

 insert into DirTimeZone (Name, Offset)
 values ('Africa/Abidjan', 'GMT+00:00')
 go

 insert into DirTimeZone (Name, Offset)
 values ('Africa/Accra', 'GMT+00:00')
 go

 insert into DirTimeZone (Name, Offset)
 values ('Africa/Addis_Ababa', 'GMT+03:00')
 go

 insert into DirTimeZone (Name, Offset)
 values ('Africa/Algiers', 'GMT+01:00')
 go

 insert into DirTimeZone (Name, Offset)
 values ('Africa/Asmera', 'GMT+03:00')
 go

 insert into DirTimeZone (Name, Offset)
 values ('Africa/Bangui', 'GMT+01:00')
 go

 insert into DirTimeZone (Name, Offset)
 values ('Africa/Banjul', 'GMT+00:00')
 go

 insert into DirTimeZone (Name, Offset)
 values ('Africa/Bissau', 'GMT+00:00')
 go

 insert into DirTimeZone (Name, Offset)
 values ('Africa/Blantyre', 'GMT+02:00')
 go

 insert into DirTimeZone (Name, Offset)
 values ('Africa/Bujumbura', 'GMT+02:00')
 go

 insert into DirTimeZone (Name, Offset)
 values ('Africa/Cairo', 'GMT+02:00')
 go

 insert into DirTimeZone (Name, Offset)
 values ('Africa/Casablanca', 'Greenwich Mean Time')
 go

 insert into DirTimeZone (Name, Offset)
 values ('Africa/Conakry', 'GMT+00:00')
 go

 insert into DirTimeZone (Name, Offset)
 values ('Africa/Dakar', 'GMT+00:00')
 go

 insert into DirTimeZone (Name, Offset)
 values ('Africa/Dar_es_Salaam', 'GMT+03:00')
 go

 insert into DirTimeZone (Name, Offset)
 values ('Africa/Djibouti', 'GMT+03:00')
 go

 insert into DirTimeZone (Name, Offset)
 values ('Africa/Douala', 'GMT+01:00')
 go

 insert into DirTimeZone (Name, Offset)
 values ('Africa/Freetown', 'GMT+00:00')
 go

 insert into DirTimeZone (Name, Offset)
 values ('Africa/Gaborone', 'GMT+02:00')
 go

 insert into DirTimeZone (Name, Offset)
 values ('Africa/Harare', 'GMT+02:00')
 go

 insert into DirTimeZone (Name, Offset)
 values ('Africa/Johannesburg', 'GMT+02:00')
 go

 insert into DirTimeZone (Name, Offset)
 values ('Africa/Kampala', 'GMT+03:00')
 go

 insert into DirTimeZone (Name, Offset)
 values ('Africa/Khartoum', 'GMT+02:00')
 go

 insert into DirTimeZone (Name, Offset)
 values ('Africa/Kigali', 'GMT+02:00')
 go

 insert into DirTimeZone (Name, Offset)
 values ('Africa/Kinshasa', 'GMT+01:00')
 go

 insert into DirTimeZone (Name, Offset)
 values ('Africa/Lagos', 'GMT+01:00')
 go

 insert into DirTimeZone (Name, Offset)
 values ('Africa/Libreville', 'GMT+01:00')
 go

 insert into DirTimeZone (Name, Offset)
 values ('Africa/Lome', 'GMT+00:00')
 go

 insert into DirTimeZone (Name, Offset)
 values ('Africa/Luanda', 'GMT+01:00')
 go

 insert into DirTimeZone (Name, Offset)
 values ('Africa/Lubumbashi', 'GMT+02:00')
 go

 insert into DirTimeZone (Name, Offset)
 values ('Africa/Lusaka', 'GMT+02:00')
 go

 insert into DirTimeZone (Name, Offset)
 values ('Africa/Malabo', 'GMT+01:00')
 go

 insert into DirTimeZone (Name, Offset)
 values ('Africa/Maputo', 'GMT+02:00')
 go

 insert into DirTimeZone (Name, Offset)
 values ('Africa/Maseru', 'GMT+02:00')
 go

 insert into DirTimeZone (Name, Offset)
 values ('Africa/Mbabane', 'GMT+02:00')
 go

 insert into DirTimeZone (Name, Offset)
 values ('Africa/Mogadishu', 'GMT+03:00')
 go

 insert into DirTimeZone (Name, Offset)
 values ('Africa/Monrovia', 'GMT+00:00')
 go

 insert into DirTimeZone (Name, Offset)
 values ('Africa/Nairobi', 'GMT+03:00')
 go

 insert into DirTimeZone (Name, Offset)
 values ('Africa/Ndjamena', 'GMT+01:00')
 go

 insert into DirTimeZone (Name, Offset)
 values ('Africa/Niamey', 'GMT+01:00')
 go

 insert into DirTimeZone (Name, Offset)
 values ('Africa/Nouakchott', 'GMT+00:00')
 go

 insert into DirTimeZone (Name, Offset)
 values ('Africa/Ouagadougou', 'GMT+00:00')
 go

 insert into DirTimeZone (Name, Offset)
 values ('Africa/Porto-Novo', 'GMT+01:00')
 go

 insert into DirTimeZone (Name, Offset)
 values ('Africa/Sao_Tome', 'GMT+00:00')
 go

 insert into DirTimeZone (Name, Offset)
 values ('Africa/Timbuktu', 'GMT+00:00')
 go

 insert into DirTimeZone (Name, Offset)
 values ('Africa/Tripoli', 'GMT+01:00')
 go

 insert into DirTimeZone (Name, Offset)
 values ('Africa/Tunis', 'GMT+01:00')
 go

 insert into DirTimeZone (Name, Offset)
 values ('Africa/Windhoek', 'GMT+01