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
Lorenzo,
That was a good suggestion (had forgotten about the between function) but
unfortunately it still complains with the following error:
Warning: SQL error: [Microsoft][ODBC Microsoft Access 97 Driver] Data type
mismatch in criteria expression., SQL state 22005 in SQLExecDirect in
test.php
Those aren't numbers remember, and need to be in single quotes.
Even so, I'll be a bit surprised if this works against Access through
ODBC...
-Zo
-Original Message-
From: Christian Sandfeld
Sent: Thu 11/15/2001 9:56 AM
To: [EMAIL
doh! ofcourse...
that actually works.
Thanks a bunch :)
/Christian
-Original Message-
From: Gonzalez, Lorenzo [mailto:[EMAIL PROTECTED]]
Sent: 15. november 2001 16:11
To: Christian Sandfeld; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Converting text fields to integer in queries
with