Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2001
    Posts
    12

    Unanswered: Interbase data type: DATE & ASP

    I'm new with InterBase database. I have InterBase 6.5 and EasySoft ODBC driver installed. I'm try to write ASP to get data from InterBase 5.x.

    When I used this command in ASP, IBAdmin, IBAccess, IBView and InteractiveSQL, it wouldn't show data but I know for fact that that data is in the database:

    select lastmodified
    from visit
    where lastmodified = '4/10/2002'

    Lastmodified define as timestamp. I read in the book, it sound like correct but I do not know why the data not show up.

    Please help,

    CM

  2. #2
    Join Date
    Apr 2002
    Location
    England
    Posts
    21

    Re: Interbase data type: DATE & ASP

    I'm not familiar with InterBase, but the first thing I would try is running your query outside of ASP (straight through the DB) and see if it is working there. If it is not then we will need to modify the query, if it is then we need to look at the ASP.

    Let us know how things go

    Dan

  3. #3
    Join Date
    Oct 2001
    Posts
    12
    Actually, I did all that before I post the message. I even run query directly from InteractiveSQL on IBConsole (I assume it's like MS Query Analyst). But it still won't show. That field is TIMESTAMP. I'm not sure if it's need specify format to do it. But thank you anyway.

  4. #4
    Join Date
    Apr 2002
    Location
    England
    Posts
    21
    Try changing your WHERE statement to

    where lastModified >= '4/10/2002' and lastModified < '5/10/2002'

    I'm treating the first digit as the day although you may want to increase the second one instead depending on your date format (e.g. 4/11/2002 for the second date).

    Hope this helps

    Dan
    Last edited by pickledAvenger; 10-11-02 at 08:57.

  5. #5
    Join Date
    Oct 2001
    Posts
    12
    Thank you. I'll try that.

    Originally posted by pickledAvenger
    Try changing your WHERE statement to

    where lastModified >= '4/10/2002' and lastModified < '5/10/2002'

    I'm treating the first digit as the day although you may want to increase the second one instead depending on your date format (e.g. 4/11/2002 for the second date).

    Hope this helps

    Dan

Posting Permissions

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