Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Location
    Minnesota
    Posts
    7

    Unanswered: Access returns blank results on localhost

    I am running a sql query against a access database and when I run it under localhost or from a access query it does not return any records However if I run the same query using something like table editor or run the same query with the same page on the server it returns a full recordset.

    Here is the query if that might help:

    SELECT * FROM Rings WHERE Date Like '" & mid(Date,1,Instr(Date, "/")-1) & "%" & mid(Date,InstrRev(Date, "/")+1) & "' and Display = True ORDER BY Date Desc, ID Desc

    Any help is greatly appreciated.
    Thanks
    -Scott

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Different dates?

    -PatP

  3. #3
    Join Date
    Mar 2004
    Location
    Minnesota
    Posts
    7
    I am trying to select all records from the current month from the db. Basically a new uploads list for users that will select all records for the current month and year but as I said does not return anything when run locally.

    When the query runs it looks something like this:

    SELECT * FROM Rings WHERE Date Like '11%2004' and Display = True ORDER BY Date Desc, ID Desc

Posting Permissions

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