Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2002
    Kuala Lumpur

    Unanswered: Can i view only 1 result

    Hai ..

    I am trying to use select method to view the access database result using ASP

    My problem is :

    I am searching a book title "intro"

    There is a book (the same book) but different ID number

    Can result only show one result and by clicking the result it will show all the book ID ?

    Can I ?

  2. #2
    Join Date
    Feb 2002
    North Wales, UK
    I'm not entirely sure what you mean but if you just want to return one using select:

    select top 1 * from <tablename> where <field> = <filter>

    Hope this helps.
    J^ - web | email
    newsASP Developer

Posting Permissions

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