Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Location
    Aotearoa
    Posts
    5

    Wink Unanswered: ...WHERE value LIKE '*';" -- just wont work?

    How come, now this is a kicker, "...WHERE value LIKE '*';" -- just won't work? Has it gone completly mad? I just don't get it.

    Hook your database to a ODBC SOURCE, won't allow that vital SQL Command, filter or (what ever pretty name we wanna call it), won't work.

    Here is the strangest problem.

    Setup a ADODB object, connection and what have you. To a DSN source kinda like the following
    "DSN=MyDB;uid=admin;pwd=;database=DB"

    Of course its registered with ODBC Data Sources through control panel.

    then comes the big crunch.

    "SELECT * FROM Jobs WHERE JobName LIKE 'D*';" or even * by itself.
    No records get returned?

    Anyone know how to solve this problem, or give a clue to aleast what the problem is caused by?

  2. #2
    Join Date
    Sep 2003
    Posts
    1

    Re: ...WHERE value LIKE '*';" -- just wont work?

    I think that you should be using '%' instead of '*'. '%' is the SQL wild card for one or more characters. _ (underscore) is the wild card for a single character.

    So your SQL statement should be

    ...WHERE value LIKE '%'



    Originally posted by Ului
    How come, now this is a kicker, "...WHERE value LIKE '*';" -- just won't work? Has it gone completly mad? I just don't get it.

    Hook your database to a ODBC SOURCE, won't allow that vital SQL Command, filter or (what ever pretty name we wanna call it), won't work.

    Here is the strangest problem.

    Setup a ADODB object, connection and what have you. To a DSN source kinda like the following
    "DSN=MyDB;uid=admin;pwd=;database=DB"

    Of course its registered with ODBC Data Sources through control panel.

    then comes the big crunch.

    "SELECT * FROM Jobs WHERE JobName LIKE 'D*';" or even * by itself.
    No records get returned?

    Anyone know how to solve this problem, or give a clue to aleast what the problem is caused by?

  3. #3
    Join Date
    Sep 2003
    Location
    Aotearoa
    Posts
    5

    Re: ...WHERE value LIKE '*';" -- just wont work?

    That is amazing! I'm sure I tried that, out of despration, all the charactors on the keyboard. I just tried it and it works!

    Thanks!!!!!!!

Posting Permissions

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