RE: [PHP-DB] Converting text fields to integer in queries with ODBC connection to an MS Access file

2001-11-15 Thread Gonzalez, Lorenzo
Some of the databases I work with would support this as 'between' on two text fields that are sortable alphabetically - I'd give that a try. -Lorenzo -Original Message- From: Christian Sandfeld Sent: Thu 11/15/2001 7:55 AM To: '[EMAIL

RE: [PHP-DB] Converting text fields to integer in queries with ODBC connection to an MS Access file

2001-11-15 Thread Gonzalez, Lorenzo
was this: WHERE PARTNUMBER.PARTNUMBER BETWEEN 37010 AND 5); So, any other suggestions on how I can circumvent this problem? Brgds, Christian -Original Message- From: Gonzalez, Lorenzo [mailto

RE: [PHP-DB] About Berkeley DB2 Databases

2001-11-14 Thread Gonzalez, Lorenzo
I thought '--with-db2' meant you'd get a DB2 (IBM) driver... what has DB2 got to do with Berkeley? An I suffering a bit of confusion between IBM's DB2 product, and Berkeley database tables, and PHP's support of these? -Lorenzo -Original Message- From:

RE: [PHP-DB] About Berkeley DB2 Databases

2001-11-14 Thread Gonzalez, Lorenzo
Thanks for the clarification of --with-db2 vs. --with-ibm-db2 ... silly me! To list your libraries: ldconfig -p Cheers, Lorenzo -Original Message- From: Ricardo Núñez Sent: Wed 11/14/2001 3:56 PM To: Pierre-Alain Joye Cc:

RE: [PHP-DB] SQL query

2001-11-12 Thread Gonzalez, Lorenzo
/ANSI_diff_Sub-selects.html -Original Message- From: Pierre Sent: Mon 11/12/2001 12:20 AM To: Gonzalez, Lorenzo; [EMAIL PROTECTED] Cc: Subject: Re: [PHP-DB] SQL query Thanks but I think subselect

RE: [PHP-DB] SQL query

2001-11-11 Thread Gonzalez, Lorenzo
in other RDBMs this is easily done with a subselect - don't know if it's doable in MySQL or not, someone else can confirm, or you can try it yourself... select * from table1 where table1.id not in (select table2.id); -Lorenzo -Original Message- From: Pierre

RE: [PHP-DB] searching for zipcode: where to start?

2001-11-10 Thread Gonzalez, Lorenzo
full-text index that field in MySQL, - then query ordered by weight with a limit 3. Wonderful stuff. -Original Message- From: dean james Sent: Sat 11/10/2001 7:27 PM To: [EMAIL PROTECTED] Cc: Subject: [PHP-DB] searching for

RE: [PHP-DB] JOIN operations

2001-11-09 Thread Gonzalez, Lorenzo
select n.name, c.city, c.ID from table_name n, table_city c where c.ID = n.ID_city No sweat. -Lorenzo -Original Message- From: Carlo Loiudice Sent: Fri 11/9/2001 5:01 PM To: PHP DB Cc: Subject: [PHP-DB] JOIN

RE: [PHP-DB] Automatic JOIN

2001-11-09 Thread Gonzalez, Lorenzo
MySQL does not enforce foreign key relationships. So while I believe you can still do a natural/automatic join, the fieldnames and datatypes must match. -Lorenzo -Original Message- From: Carlo Loiudice Sent: Fri 11/9/2001 5:11 PM To: PHP DB Cc: Subject: [PHP-DB]

RE: [PHP-DB] XML coming out from MySQL

2001-11-09 Thread Gonzalez, Lorenzo
I've never parsed XML with PHP, but it might help if you can show the document that's breaking the parser, and also let us know if other documents are working fine... -Lorenzo -Original Message- From: Tomas Garcia Ferrari Sent: Fri 11/9/2001 5:14 PM