From: Ethan Rosenberg eth...@earthlink.net
To: rquadl...@googlemail.com, Ethan Rosenberg eth...@earthlink.net
Cc: php-db-lists.php.net php-db@lists.php.net
Sent: Thursday, October 28, 2010 4:55:34 AM GMT +01:00 Amsterdam / Berlin /
Bern / Rome / Stockholm / Vienna
Subject: Re: [PHP-DB
/ Vienna
Subject: Re: [PHP-DB] Incrementing Primary Key
At 10:10 AM 10/27/2010, Richard Quadling wrote:
On 27 October 2010 14:11, Ethan Rosenberg eth...@earthlink.net wrote:
Dear List -
Thanks for all your excellent help.
I am setting up a database for medical
research, which
, October 28, 2010 4:55:34 AM GMT +01:00 Amsterdam / Berlin
/ Bern / Rome / Stockholm / Vienna
Subject: Re: [PHP-DB] Incrementing Primary Key
At 10:10 AM 10/27/2010, Richard Quadling wrote:
On 27 October 2010 14:11, Ethan Rosenberg eth...@earthlink.net wrote:
Dear List -
Thanks for all your
-lists.php.net php-db@lists.php.net
Sent: Thursday, October 28, 2010 4:55:34 AM GMT +01:00 Amsterdam / Berlin
/ Bern / Rome / Stockholm / Vienna
Subject: Re: [PHP-DB] Incrementing Primary Key
At 10:10 AM 10/27/2010, Richard Quadling wrote:
On 27 October 2010 14:11, Ethan Rosenberg eth...@earthlink.net
: Re: [PHP-DB] Incrementing Primary Key
At 01:17 PM 10/28/2010, Bastien Koert wrote:
On Thu, Oct 28, 2010 at 1:00 PM, Ethan Rosenberg eth...@earthlink.net
wrote:
At 03:40 AM 10/28/2010, Max E.K wrote:
From: Ethan Rosenberg eth...@earthlink.net
To: rquadl...@googlemail.com, Ethan Rosenberg
-lists.php.net; rquadl...@googlemail.com
Subject: Re: [PHP-DB] Incrementing Primary Key
At 01:17 PM 10/28/2010, Bastien Koert wrote:
On Thu, Oct 28, 2010 at 1:00 PM, Ethan Rosenberg eth...@earthlink.net
wrote:
At 03:40 AM 10/28/2010, Max E.K wrote:
From: Ethan Rosenberg eth...@earthlink.net
: Thursday, October 28, 2010 2:02 PM
To: Bastien Koert
Cc: Max E.K; php-db-lists.php.net; rquadl...@googlemail.com
Subject: Re: [PHP-DB] Incrementing Primary Key
At 01:17 PM 10/28/2010, Bastien Koert wrote:
On Thu, Oct 28, 2010 at 1:00 PM, Ethan Rosenberg eth...@earthlink.net
wrote:
At 03:40 AM
I think having a table for each site would be sufficent
-Original Message-
From: Ethan Rosenberg [mailto:eth...@earthlink.net]
Sent: Wednesday, October 27, 2010 9:11 AM
To: php-db-lists.php.net
Subject: [PHP-DB] Incrementing Primary Key
Dear List -
Thanks for all your excellent help.
Just set the primary key to AUTO_INCREMENT on each field and you won't have
to worry about it
-Original Message-
From: Ethan Rosenberg [mailto:eth...@earthlink.net]
Sent: Wednesday, October 27, 2010 9:11 AM
To: php-db-lists.php.net
Subject: [PHP-DB] Incrementing Primary Key
Dear List -
Hi Ethan,
in this case, you should manage the keys by your application, and
store the used ids in aonther table,
similar to a sequence in Oracle or Postgresql.
Thats so if you want all the records un one table (a field for the
letter, and the other for the numeric part).
Otherwise, having a table
for PHP every time you want to
use a different database.
I use the PDO mysql adapter, what do you use?
-Original Message-
From: Andrés G. Montañez [mailto:andresmonta...@gmail.com]
Sent: Wednesday, October 27, 2010 9:19 AM
To: Ethan Rosenberg
Cc: php-db-lists.php.net
Subject: Re: [PHP-DB
Hi Ethan,
I am working currently as clinical developer and have developed multi site
databases for clinical trials.
I would say the approach you take will depend on number of factors.
How is the site connectivity?
I had a scenario where sites had erratic and slow connectivity so i had to
-
From: Andrés G. Montañez [mailto:andresmonta...@gmail.com]
Sent: Wednesday, October 27, 2010 9:19 AM
To: Ethan Rosenberg
Cc: php-db-lists.php.net
Subject: Re: [PHP-DB] Incrementing Primary Key
Hi Ethan,
in this case, you should manage the keys by your application, and store the
used ids
On 27 October 2010 14:11, Ethan Rosenberg eth...@earthlink.net wrote:
Dear List -
Thanks for all your excellent help.
I am setting up a database for medical research, which will be conducted at
various sites. The sites will be identified by a letter {A,B,C }. The
medical record number
- Original Message -
From: Richard Quadling rquadl...@gmail.com
To: Ethan Rosenberg eth...@earthlink.net
Cc: php-db-lists.php.net php-db@lists.php.net
Sent: Wednesday, October 27, 2010 4:10:52 PM GMT +01:00 Amsterdam / Berlin /
Bern / Rome / Stockholm / Vienna
Subject: Re: [PHP-DB
At 10:10 AM 10/27/2010, Richard Quadling wrote:
On 27 October 2010 14:11, Ethan Rosenberg eth...@earthlink.net wrote:
Dear List -
Thanks for all your excellent help.
I am setting up a database for medical research, which will be conducted at
various sites. Â The sites will be identified
16 matches
Mail list logo