SELECT TOP x..
However..
MS SQL Server does not support select range type quries.
If your table does not contain lot of data.. look at CFOUTPUT controls..
otherwise.. SQL StoredProc would give you good results..
Nick Baker wrote:
MS SQL
CFMX 6.1
How do you limit the score of info returned?
or
The equivalent of MySQL
LIMIT #StartRow#, #NumberRows#
Thanks,
Nick
--
Umer Farooq
Octadyne Systems
+1 (519) 489-1119 voice
+1 (519) 635-2795 mobile
+1 (530) 326-3586 fax
WEB SOLUTIONS FOR NON-PROFIT ORGANIZATION:
http://www.Non-ProfitSites.biz
WARNING: --- The information contained in
this document and attachments is confidential and intended only for the
person(s) named above. If you are not the intended recipient you are
hereby notified that any disclosure, copying, distribution, or any other
use of the information is strictly prohibited. If you have received
this document by mistake, please notify the sender immediately and
destroy this document and attachments without making any copy of any kind.
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:193144
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54