Daniel, It is possible within the same query to return the count of rows within that same query.. SELECT * FROM ( SELECT d.*, ROWNUM r, COUNT(docid) OVER() AS rowcount FROM DOCUMENTS d ORDER BY title ) WHERE r > 1 AND r < 10
Using count() over () as an analytic function instead of as an aggregate function we can return that value.. This creates a column you can reference 'rowcount' and for every row will have the total count of rows. You can do it this way or run a whole new query. Seeing that you'll only be returning 25-50 rows, using the count() over() shouldnt create too much overhead. Have fun.. GM On Fri, 21 Jan 2005 07:56:59 -0400, daniel kessler <[EMAIL PROTECTED]> wrote: > >> Does making sure that it's a varchar do the same thing? IOW, is > >> it making sure that it's not some sort of run statement? > > > >Yes, it simply tells the database server that the value is just that - a > >value rather than an SQL command. > > ah great, thanks for the clarity. I have alot of retro-fitting to do on DBs > that I worked on in the past. > > >I haven't seen the original query that you're working with (presumably it's > >somewhere within a previous message), but all you have to do is replace your > >literal values with CFQUERYPARAM tags - you shouldn't have to change your > >conditional logic around to accommodate this, I don't think. > > yeah, I build the WHERE into a long string > <cfset the_where = "WHERE mycolumn = myvalue"> > <cfset the_where = "#the_where # AND mycolumn = myvalue"> etc. > > The new way, I just CFIF the actual column and values into the SQL statement > - like in your example on the MM page. > > Thanks for the help. Hope you like this weekends snow - looks to be a good > one. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware: 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:191363 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