Query Returns Empy Set??


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: Query Returns Empy Set??

  1. #1
    Marcos Guest

    Query Returns Empy Set??


    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



  2. #2
    Will Guest

    Re: Query Returns Empy Set??


    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





  3. #3
    Marcos Guest

    Re: Query Returns Empy Set??


    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
    >
    >
    >
    >



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center