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
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
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:
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:
/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
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
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
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
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]
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
10 matches
Mail list logo