|
 |
asp_databases thread: Returning x Number of Rows SQL
Message #1 by "Tony Yates" <tony.yates@b...> on Mon, 17 Sep 2001 15:54:11
|
|
I am trying to return x number of rows from a database query
eg
"SELECT * FROM TABLE " <<where record count = x>>
Regards
Tony
Message #2 by James Kenney <JEK@m...> on Mon, 17 Sep 2001 10:58:20 -0400
|
|
Why not rs.movenext ten times
-----Original Message-----
From: Tony Yates [mailto:tony.yates@b...]
Sent: Monday, September 17, 2001 11:54 AM
To: ASP Databases
Subject: [asp_databases] Returning x Number of Rows SQL
I am trying to return x number of rows from a database query
eg
"SELECT * FROM TABLE " <<where record count = x>>
Regards
Tony
Message #3 by Brooks_Piggott@D... on Mon, 17 Sep 2001 10:09:10 -0500
|
|
"SELECT * FROM TABLE WHERE rownum <= x"
-----Original Message-----
From: James Kenney [mailto:JEK@m...]
Sent: Monday, September 17, 2001 9:58 AM
To: ASP Databases
Subject: [asp_databases] RE: Returning x Number of Rows SQL
Why not rs.movenext ten times
-----Original Message-----
From: Tony Yates [mailto:tony.yates@b...]
Sent: Monday, September 17, 2001 11:54 AM
To: ASP Databases
Subject: [asp_databases] Returning x Number of Rows SQL
I am trying to return x number of rows from a database query
eg
"SELECT * FROM TABLE " <<where record count = x>>
Regards
Tony
Message #4 by "Drew, Ron" <RDrew@B...> on Mon, 17 Sep 2001 11:24:40 -0400
|
|
....SQL Server.....
Dim strSQL
strSQL = "set rowcount xx " ' replace xx with your number
strSQL = strSQL & "SELECT * FROM TABLE"
...Access.....
"Select TOP xx * from table"
Better not to use select *....specify the columns you want. Where and order
by can be added.
-----Original Message-----
From: Tony Yates [mailto:tony.yates@b...]
Sent: Monday, September 17, 2001 11:54 AM
To: ASP Databases
Subject: [asp_databases] Returning x Number of Rows SQL
I am trying to return x number of rows from a database query
eg
"SELECT * FROM TABLE " <<where record count = x>>
Regards
Tony
|
|
|
View Cart
