Re: [PHP-WIN] Validation of Primary Key Datetime variable

2005-02-28 Thread graeme
[mailto:[EMAIL PROTECTED] Sent: 28 February 2005 13:31 To: S.D.Price Subject: RE: [PHP-WIN] Validation of Primary Key Datetime variable Simon, Why not use a varchar datatype and populate it yourself. It can then be modified, but the data can still be displayed in the way you want, by being a bit more

Re: [PHP-WIN] Validation of Primary Key Datetime variable

2005-02-28 Thread Randy Clamons
Just a thought... Using a primary key that is controlled by the user rather than your db system is risky, especially if the user can change the value after adding the record. Why not use an auto_increment field as your primary key and an indexed datetime column to list rows in the order you wish

RE: [PHP-WIN] Validation of Primary Key Datetime variable

2005-02-28 Thread Mike
OTECTED] > Sent: Monday, February 28, 2005 9:17 AM > To: php-windows > Subject: RE: [PHP-WIN] Validation of Primary Key Datetime variable > > Thanks for this George. I am populating the datetime field > from user input, and users can change the date if they need to. > > The

RE: [PHP-WIN] Validation of Primary Key Datetime variable

2005-02-28 Thread S.D.Price
sure what. Steven -Original Message- From: George Pitcher [mailto:[EMAIL PROTECTED] Sent: 28 February 2005 13:31 To: S.D.Price Subject: RE: [PHP-WIN] Validation of Primary Key Datetime variable Simon, Why not use a varchar datatype and populate it yourself. It can then be modified, but