View Single Post
Old 01-12-08, 01:10 AM   #2
Sycario
Registered User
 
Join Date: Nov 2006
Location: St. Louis, MO
Posts: 363
Send a message via AIM to Sycario
Default Re: MySQL SORT by Column and LIMIT Rows using classic ASP

have you tried:
Set oRS = oConn.Execute("SELECT * FROM `tracking` ORDER BY `model` LIMIT " & startRecord & "," & endRecord)
__________________

Comp Specs:
Intel Q9650 @ 3.95Ghz
Asus Rampage Extreme
2x2GB Mushkin DDR3-1600 @ 6-6-6-17
eVGA GTX 280 SSC
BFG ES-800 PSU
Sycario is offline   Reply With Quote