Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Posts
    1

    Unanswered: Strange Access problem

    I am writing an application using access and ASP. Here is the (weird)problem: when I send this query through ASP, it doesn't return any record. However, if I try the query from Access, it works perfectly and returns several records.
    This is the query:
    SELECT id_organisation from FULL_VIEW WHERE organisation_name like '**' AND contact_name like '**' AND contact_position like '**' AND business like '**' AND country like '*t*' AND marketing like '**' AND interest like '**' AND AOI like '**' AND AONI like '**'

    I guess the wildcards or the like clause are causing problems, becase when I try a WHERE clause using the = operator against an integer, it works fine,

    Anybody help me please, it related to my work and I can not continue without this!!
    thanks,

  2. #2
    Join Date
    Sep 2003
    Location
    T.O.
    Posts
    326
    Because this is not an ASP forum, I don't have specialized knowledge for your problem. You MAY want to try replacing the * with % when going through ASP.
    All code ADO/ADOX unless otherwise specified.
    Mike.

Posting Permissions

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