Okay, let's take a step back. (Examples from a table in my db that works.) Why don't you query for the whole list of agencies, using the "order by upper(agency)" clause. This will get you the list in alphabetical order.
SELECT title FROM bep_resource WHERE 1 = 1 ORDER BY UPPER(title) Dump it in a page. Does it look right? If it does, good. Now, take it the next step, and add the outer clause with the rownumber. SELECT t.*, ROWNUM AS RN FROM ( SELECT title FROM bep_resource WHERE 1 = 1 ORDER BY UPPER(title) ) t Still good? Next Step: SELECT * FROM ( SELECT t.*, ROWNUM AS RN FROM ( SELECT title FROM bep_resource WHERE 1 = 1 ORDER BY UPPER(title) ) t ) Final step: SELECT * FROM ( SELECT t.*, ROWNUM AS RN FROM ( SELECT title FROM bep_resource WHERE 1 = 1 ORDER BY UPPER(title) ) t ) WHERE rownum >=1 AND rownum <=10 Where do thinks go wonky? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:192074 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
