PDA

View Full Version : Can i view only 1 result

caa
09-11-02, 23:21
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 ?
JonathanB
09-12-02, 06:08
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.