RE: [PHP-DB] data format problem in MS Access
| From: | CJ Romberger | Date: | Fri, 07 Jul 2000 16:01:38 +0000 |
| Subject: | RE: [PHP-DB] data format problem in MS Access | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-953@lists.php.net to get a copy of this message | ||
Using like on a number? why not just = ?
or like on a string with a %? (like '6280%')
CJ
"No other personal quality contributes to success more than relentless
persistence in the pursuit of one's goals."
-----Original Message-----
From: Teodor Cimpoesu [mailto:teo@digiro.net]
Sent: Friday, July 07, 2000 10:48 AM
To: php-db@lists.php.net
Subject: Re: [PHP-DB] data format problem in MS Access
Hi Vojt?ch!
On Fri, 07 Jul 2000, Vojt?ch Dvo?ák wrote:
> Hi,
> I have a problem with very basic thing.
> When I will use this statement: "SELECT RANumber, DateCall, ProductType,
> ModelNumber
> FROM TabTest
> WHERE RANumber like '6280' "
>
> Everything works fine if "RANumber" is in Text format in MS Access. When I
> change "RANumber" to Number format it gives me this message: "ODBC Error:
> 22005: [Microsoft][ODBC Microsoft Access 97 Driver] Data type mismatch in
> criteria expression."
>
> Ok, I can change format type of this column in my database, but isn't
there
> any other solution?
WHERE RANumber = 6280 ?
-- teodor
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net
For additional commands, e-mail: php-db-help@lists.php.net
To contact the list administrators, e-mail: php-list-admin@lists.php.net