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

2006-11-14 Thread Desmond Coughlan
X-No-Archive: trueThat'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 ... NV_READ' undeclared (first use

[GENERAL] database design ...

2006-11-14 Thread Desmond Coughlan
X-No-Archive: trueHi, 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] database design ...

2006-11-14 Thread Desmond Coughlan
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: X-No-Archive: true Hi, Thanks for all the help

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

2006-11-14 Thread Desmond Coughlan
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 I want to develop is a school library, and as this is new to me, I come

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

2006-11-14 Thread Desmond Coughlan
.--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 information to be stored? After all, each copy will be identical (some more worn out than others

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

2006-11-14 Thread Desmond Coughlan
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 going to split stock into two tables, but your point raises an important question

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

2006-11-14 Thread Desmond Coughlan
X-No-Archive: trueMore 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.sqlI haven't tested it yet, which brings me to two questions... a. will it work even if I

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

2006-11-14 Thread Desmond Coughlan
X-No-Archive: trueA 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

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 to look at contrib/isn - this adds

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

2006-11-12 Thread Desmond Coughlan
X-No-Archive: trueHi. 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)

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

2006-11-12 Thread Desmond Coughlan
X-No-Archive: trueSorry, 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: trueHi. As title. I'm getting a host of syntax errors, the last ten lines

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

2006-11-09 Thread Desmond Coughlan
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. Ben <[EMAIL PROTECTED]>a écrit : Have you check

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

2006-11-09 Thread Desmond Coughlan
X-No-Archive: trueYep... 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 error lo

[GENERAL] first steps in PhP and PostgreSQL

2006-11-06 Thread Desmond Coughlan
X-No-Archive: trueHi, 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.