Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2002
    Posts
    3

    Unhappy Unanswered: What's wrong with my query in ACCESS2000?

    I used ADO method to load ACCESS2000

    =========================================
    Directly DEBUG in ACCESS

    select count(*) from user where name like '%q%' Cont't query the resultŁ¨But It can before)

    select count(*) from user where name like '*q*' Can get the correctly result

    select count(*) from user where name like '%%q%%' Cont't query the resultŁ¨But It can before)

    ==========================================
    In my ASP web

    select count(*) from user where name like '*q*' memory overflowed

    select count(*) from user where name like '%q%' memory overflowed

    select count(*) from user where name like '%%q%%' memory overflowed

    ==========================================
    What's wrong with this?

  2. #2
    Join Date
    Feb 2002
    Location
    North Wales, UK
    Posts
    114
    Can you post the exact error message you received from the ASP code?
    J^ - web | email
    newsASP Developer

  3. #3
    Join Date
    Feb 2002
    Posts
    2,232
    What are you trying to do ? How big is the database/table you are querying ?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •