RE: [PHP-WIN] Need SQL Help for PHP_WIN and ODBC/Access !! SOLVED
| From: | Naved, Masroor | Date: | Mon, 07 Oct 2002 20:18:29 +0000 |
| Subject: | RE: [PHP-WIN] Need SQL Help for PHP_WIN and ODBC/Access !! SOLVED | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-16233@lists.php.net to get a copy of this message | ||
Dewey,
I believe that the % wildcard is ANSI SQL requirement. I know at least
Oracle, MS SQL Server, & Sybase use it.
-Masroor
-----Original Message-----
From: Williams, Dewey [mailto:williams@email.uncc.edu]
Sent: Monday, October 07, 2002 4:08 PM
To: php-windows@lists.php.net
Subject: RE: [PHP-WIN] Need SQL Help for PHP_WIN and ODBC/Access !! SOLVED
It seems the use of LIKE in an sql statement requires the 'wild-card' %
instead of * when sending to an Access (and other?) databases. If anyone
knows WHY, I would like an explanation.
Dewey Williams
williams@email.uncc.edu
-----Original Message-----
From: Williams, Dewey [mailto:williams@email.uncc.edu]
Sent: Thursday, October 03, 2002 3:59 PM
To: php-windows@lists.php.net
Subject: [PHP-WIN] Need SQL Help for PHP_WIN and ODBC/Access
HELP!
I need the WHERE statement to use LIKE and wrap the variable $ProdVar in *
so users can do a text search on the field.
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php