Query Returns Empy Set??

[Marcos]

I am using an ASP page connecting to an access back end. And I have a query
running that returns an empty recordset, and I can't figure out why. The
Query is

Select * from Customers Where Customers.Name Like '*John*'

I am obviously trying to incorporate a text search. This Query runs fine
in Access, but the second I try to put it into ASP and open the recordset,
I get an empy recordset. What am I missing here?

Also just curious, what's the best way to test for an empty recordset in
ASP.?

Thanks,

Marcos

[Will]

Use this instead:
Select * from Customers Where Customers.Name Like '%John%'
(i.e. Percentage signs i.s.o. *'s)

I know its weird, but I had that same problem a couple of weeks back.

To check for an empy recordset, just check for EOF - if it's true right after
the call then the rst is empty

[Marcos]

Thanks, that was it. Appreciate it.

P2SG


"Will" <willem@trendline.co.za> wrote:
>
>Use this instead:
>Select * from Customers Where Customers.Name Like '%John%'
>(i.e. Percentage signs i.s.o. *'s)
>
>I know its weird, but I had that same problem a couple of weeks back.
>
>To check for an empy recordset, just check for EOF - if it's true right
after
>the call then the rst is empty
>
>
>
>