RE : Re: RE : Re: [GENERAL] database design ...

2006-11-14 Thread Desmond Coughlan
X-No-Archive: true Excellent.. thank you for that!   D.Shane Ambler <[EMAIL PROTECTED]> a écrit : Desmond Coughlan wrote:> X-No-Archive: true> > Just had a thought. If you see .. > > http://www.chez.com/desmondcoughlan/unix/cdi_gt.sqlWith the ISBN number you may want t

RE : Re: RE : Re: [GENERAL] database design ...

2006-11-14 Thread Desmond Coughlan
X-No-Archive: true   A really weird thing.  This ..   http://www.chez.com/desmondcoughlan/unix/bibliotheque.sql   .. works almost perfectly.  Except for this error ..   'psql:/usr/local/pgsql/bibliotheque.sql:54: ERROR:  relation "titles" does not exist'   I wrote   http://www.chez.c

RE : Re: RE : Re: [GENERAL] database design ...

2006-11-14 Thread Desmond Coughlan
X-No-Archive: true   More tables and fewer columns in the tables?  I *like* it!  It hadn't occurred to me do it that way.   Will this work ?   http://www.chez.com/desmondcoughlan/unix/bibliotheque.sql   I haven't tested it yet, which brings me to two questions...   a. will it work even

RE : Re: [GENERAL] database design ...

2006-11-14 Thread Desmond Coughlan
first table?  That way, every single item in the building has its own unique ID, but the different copies of the various media are divided across tables?   D.Raymond O'Donnell <[EMAIL PROTECTED]> a écrit : On 14 Nov 2006 at 19:34, Desmond Coughlan wrote:> I reckon we're not

RE : Re: [GENERAL] database design ...

2006-11-14 Thread Desmond Coughlan
ture, then your lifewill be made much easier by splitting the books into two tables.--Ray.On 15 Nov 2006 at 0:47, Desmond Coughlan wrote:> I have to confess the second model has me confused. Why can't the> first one, i.e a single integer column for the number of copies, allow> as much

RE : Re: [GENERAL] database design ...

2006-11-14 Thread Desmond Coughlan
g all the data you'll need in a way that makes it easy for you to use.On Tue, 14 Nov 2006, Desmond Coughlan wrote:> X-No-Archive: true>> Hi,> Thanks for all the help: we have our postgreSQL server on a 'backend' machine, and the client on a webserver.>> The application

RE : Re: [GENERAL] database design ...

2006-11-14 Thread Desmond Coughlan
re six or seven copies of each.  Does each one have an unique stock_id?    And our ultimate aim is for a barcode reader to be used by the librarian.  Any good sources to learn about that ?   Thanks again.   D.Shane Ambler <[EMAIL PROTECTED]> a écrit : Desmond Coughlan wrote:>

[GENERAL] database design ...

2006-11-14 Thread Desmond Coughlan
X-No-Archive: true   Hi, Thanks for all the help: we have our postgreSQL server on a 'backend' machine, and the client on a webserver.   The application I want to develop is a school library, and as this is new to me, I come looking for ideas.  Here's what I've done: on the backend, two users

RE : Re: [GENERAL] Trying to Install PhP-4 Module for PostgreSQL from

2006-11-14 Thread Desmond Coughlan
X-No-Archive: true   That's exactly what it was, thanks!  7.4 installed now, and I have ¨PhP support!!   D.Walter Vaughan <[EMAIL PROTECTED]> a écrit : Desmond Coughlan wrote:> Hi. As title. I'm getting a host of syntax errors, the last ten lines > of which are ...&

[GENERAL] RE : Trying to Install PhP-4 Module for PostgreSQL from Ports

2006-11-12 Thread Desmond Coughlan
X-No-Archive: true   Sorry, I should have mentioned: the machine is FreeBSD 5.5-RELEASE, and I'm running make install clean in the port for PhP 4.   D.   Desmond Coughlan <[EMAIL PROTECTED]> a écrit :X-No-Archive: true   Hi.  As title.  I'm getting a host of syntax erro

[GENERAL] Trying to Install PhP-4 Module for PostgreSQL from Ports

2006-11-12 Thread Desmond Coughlan
X-No-Archive: true   Hi.  As title.  I'm getting a host of syntax errors, the last ten lines of which are ...   NV_READ' undeclared (first use in this function) /usr/ports/databases/php4-pgsql/work/php-4.4.4/ext/pgsql/pgsql.c:1937: error: `INV_WRITE' undeclared (first use in this function) /us

RE : Re: [GENERAL] first steps in PhP and PostgreSQL

2006-11-09 Thread Desmond Coughlan
X-No-Archive: true   Yep...   192.168.0.254 - - [07/Nov/2006:10:12:57 +0100] "GET /php_experimental/base.php HTTP/1.1" 200 - "-" "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)" D.Ben <[EMAIL PROTECTED]> a écrit : Have you checked your webserver er

RE : Re: RE : Re: [GENERAL] first steps in PhP and PostgreSQL

2006-11-09 Thread Desmond Coughlan
k the error log.On Tue, 7 Nov 2006, Desmond Coughlan wrote:> X-No-Archive: true>> Yep...>> 192.168.0.254 - - [07/Nov/2006:10:12:57 +0100] "GET /php_experimental/base.php HTTP/1.1" 200 - "-" "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)">> D.>&g

[GENERAL] first steps in PhP and PostgreSQL

2006-11-06 Thread Desmond Coughlan
X-No-Archive: true   Hi, I'm sure that it's a typo or something, but as I'm getting into PhP and PostgreSQL for the first time, I can't be sure.   I have a db, called 'cdi' ..   A 'SELECT * FROM stock;' gets me this in psql ..   cdi=> SELECT * from stock ;-[ RECORD 1 ]-+-

[GENERAL] .

2006-11-05 Thread Desmond Coughlan
. Découvrez une nouvelle façon d'obtenir des réponses à toutes vos questions ! Profitez des connaissances, des opinions et des expériences des internautes sur Yahoo! Questions/Réponses.