This
might seem like a stupid suggestion but try changing the order you pass the
parameters in so the number of records you are retrieving is first and the id is
second.
If you
look at the generated queryit uses P1 and P2 and if they standard for
parameters they are the wrong way around.
Hellu,
I solved it. Appearantly you can't give an argument
to the top command of Ms SQL. I solved ti through SET ROWCOUNT.
Eddie
- Original Message -
From:
Eddie
To: Orion-Interest
Sent: Monday, October 08, 2001 8:52
PM
Subject: Query help please ??
Hellu,I