> You can still do it in one query, returning both the total
> record count and just the "window" of records you are
> interested in (example for oracle):
<snip>
> you then have a single "small window" query with an extra
> column (TotalRecords) that tells you how many rows are in
> the "big" query (which you left on the db server.
> This would be a good approach if the problem with the
> dataset is the cost of bringing it over, not the cost of
> calculating it.
Ahh cool... Oracle only solution I think... I have some vague
recollection of seeing that syntax for some other Oracle query... but
I've never seen it (or anything like it) for any other db. At least
not that's worked... I saw something similar in a SQL Server example
today where somebody was querying from a UDF...
SELECT * FROM dbo.myUDF('arg1','arg2')
But although I was able to create the UDF in one of our SQL 2K
databases, I wasn't able to get the select statement to work.
s. isaac dealey 954.522.6080
new epoch : isn't it time for a change?
add features without fixtures with
the onTap open source framework
http://www.fusiontap.com
http://coldfusion.sys-con.com/author/4806Dealey.htm
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:217048
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
