ODBC Query of Access 2000 db using LIKE

[Jahmil Richardson]

Attempting to query MS Access database with the ODBC drivers for PHP. When
using the LIKE statement no records are returned.

Example:

$query = " Select * From Dispatch Where Customer Like '*A*' ";
$result = odbc_prepare($db,$query);
odbc_execute($result);

Does anyone out there know the syntax that I should be using for the Like
statement in the Where clause? When I do a normal query, it works
fine....Just using wildcards it does not work....

[Daniel Tryba]

Jahmil Richardson <ja****@thehelpesk.com> wrote:

$query = " Select * From Dispatch Where Customer Like '*A*' ";

Does anyone out there know the syntax that I should be using for the Like
statement in the Where clause? When I do a normal query, it works
fine....Just using wildcards it does not work....

It works perfectly, you are just to lazy to search for a correct
example:
http://www.google.com/search?q=sql+l...ldcard+example

First link explains it all.

--

Daniel Tryba

[Geoff Berrow]

I noticed that Message-ID: <c6**********@news.tue.nl> from Daniel Tryba
contained the following:

Jahmil Richardson <ja****@thehelpesk.com> wrote:

$query = " Select * From Dispatch Where Customer Like '*A*' ";

Does anyone out there know the syntax that I should be using for the Like
statement in the Where clause? When I do a normal query, it works
fine....Just using wildcards it does not work....

It works perfectly, you are just to lazy to search for a correct
example:
http://www.google.com/search?q=sql+l...ldcard+example

That's unfair. Access databases use the asterisk as a wild card.

I've not written a LIKE query with my ODBC setup so I can't help I'm
afraid.

It may be an idea to try the % though.

--
Geoff Berrow (put thecat out to email)
It's only Usenet, no one dies.
My opinions, not the committee's, mine.
Simple RFDs http://www.ckdog.co.uk/rfdmaker/

[Daniel Tryba]

Geoff Berrow <bl******@ckdog.co.uk> wrote:

$query = " Select * From Dispatch Where Customer Like '*A*' ";

Does anyone out there know the syntax that I should be using for the Like
statement in the Where clause? When I do a normal query, it works
fine....Just using wildcards it does not work....

It works perfectly, you are just to lazy to search for a correct
example:
http://www.google.com/search?q=sql+l...ldcard+example

That's unfair. Access databases use the asterisk as a wild card.

If that is correct, that I appologize to the OP.

--

Daniel Tryba

[Doug Hutcheson]

Sadly, that IS correct. Access hath its quirks.
IIRC, Access needs the token string to be surrounded by double quotes, so
perhaps the OP could try rewriting the query as:
$query = 'Select * From Dispatch Where Customer Like "*A*"';

HTH
Doug

--
Remove the blots from my address to reply
"Daniel Tryba" <ne**************@canopus.nl> wrote in message
news:c6**********@news.tue.nl...

Geoff Berrow <bl******@ckdog.co.uk> wrote:

$query = " Select * From Dispatch Where Customer Like '*A*' ";

Does anyone out there know the syntax that I should be using for the Like statement in the Where clause? When I do a normal query, it works
fine....Just using wildcards it does not work....

It works perfectly, you are just to lazy to search for a correct
example:
http://www.google.com/search?q=sql+l...ldcard+example

That's unfair. Access databases use the asterisk as a wild card.

If that is correct, that I appologize to the OP.

--

Daniel Tryba

[Doug Hutcheson]

Ooops.. typo..
$query = 'Select * From Dispatch Where Customer Like \"*A*\"';
"8-{
--
Remove the blots from my address to reply
"Doug Hutcheson" <do*****************@nrm.blot.qld.blot.gov.blot.au > wrote
in message news:XK******************@news.optus.net.au...

Sadly, that IS correct. Access hath its quirks.
IIRC, Access needs the token string to be surrounded by double quotes, so
perhaps the OP could try rewriting the query as:
$query = 'Select * From Dispatch Where Customer Like "*A*"';

HTH
Doug

--
Remove the blots from my address to reply
"Daniel Tryba" <ne**************@canopus.nl> wrote in message
news:c6**********@news.tue.nl...

Geoff Berrow <bl******@ckdog.co.uk> wrote:

>> $query = " Select * From Dispatch Where Customer Like '*A*' ";
>>
>> Does anyone out there know the syntax that I should be using for the Like>> statement in the Where clause? When I do a normal query, it works
>> fine....Just using wildcards it does not work....
>
>It works perfectly, you are just to lazy to search for a correct
>example:
>http://www.google.com/search?q=sql+l...ldcard+example

That's unfair. Access databases use the asterisk as a wild card.

If that is correct, that I appologize to the OP.

--

Daniel Tryba