Open Source Datagrid

As promised last week (and reminded by a post on Remote Synthesis) here is the next piece of useful open source code.

CF Datagrid - it converts queries to a nice presentable datagrid which has support for paging, filtering and sorting.

We use it internally and it happily handles querys of around 100,000 records.

It is available under the CPL 1.0 and I hope you find it useful.

If you find any bugs or issues please post a note on this blog.

Show me the code! | Show me what it looks like!

Update: Added new zip file with build 22 of the datagrid. It includes the missing files.

Comments
Brian Rinaldi's Gravatar Looks interesting. What would be nice would be if you combined the additional features of your datagrid with the sortable table code of my sortable tables custom tag (http://www.remotesynthesis.com/blog/index.cfm/2006...) - which handles the proper sorting of string, date and numeric data types without page reloads :)
# Posted By Brian Rinaldi | 8/8/06 10:59 AM
Mark's Gravatar Hi Brian,

It's something that I'd love to be able to do but I haven't found a nice solution to make it work yet. The reason it won't work is that in the interests of performance the datagrid handles paging on the server side. This means that if we put any client side sorting on it then the sort would only be sorting the available items instead of the entire query sort.

As I mentioned in the post one of our internal uses of it involves throwing a 100,000+ record at it and the datagrid handles the paging very quickly.

There could be a nice way to do it with ajax, but I need to spend a bit of time to get it working with a nice clean interface.

Cheers,
Mark
# Posted By Mark | 8/8/06 11:50 AM
Douglas Knudsen's Gravatar was trying this out. seems something is missing from the zip file
<cfimport prefix="msg" taglib="/net/redbd/customtags/msg/">
fails. FYI

looks nice though!

DK
# Posted By Douglas Knudsen | 8/9/06 1:37 AM
Douglas Knudsen's Gravatar core.cfc.utility is also being referenced


DK
# Posted By Douglas Knudsen | 8/9/06 1:39 AM
Lucas Sherwood's Gravatar Looks like we missed those ones.

The cfimport statment loads our simple message handler (to bo open sourced soon) but I am not sure what the utility cfc has it it... Stay tuned for an update
# Posted By Lucas Sherwood | 8/9/06 6:21 AM
Mark's Gravatar Hi Douglas,

Thanks for that - I did test it on my machine but forgot to remove the mappings so I had all the dependencies.

I've added a new file which should have everything that you need.

Let me know how you go.

Cheers,
Mark
# Posted By Mark | 8/9/06 10:49 AM
Douglas Knudsen's Gravatar Ok, now we are playing with a full deck! Nice. One thing I will suggest is replacing this
<cfimport prefix="msg" taglib="/customtags/net/redbd/customtags/msg">
with
<cfimport prefix="msg" taglib="../msg">
This will make the code more portable.

Also, the cfimport tag is cool for sure, but in our case our customtags directories are not under the webroot. I switched to using the old-fashioned customtag call of
<cf_datagrid >

Ever see GridMonger?
http://mysecretbase.com/GridMonger_Home.cfm
I prefer a customtag approach you guys are using, but gridmonger has been around for a few years.

DK
# Posted By Douglas Knudsen | 8/10/06 12:00 AM
Mark's Gravatar Hi Doug,

1st suggestion is a very good one - I'll look at doing that.

For the second one though - our customtags directory are also not under the webroot - we have mappings set up for /net which allows us to map the custom tags in very neatly.

The Readme.txt should describe the easy way (slap it all in the webroot) and the secure "right" way which involves a non webaccessible folder mapped in via a CF mapping.

I haven't seen grid monger - I'll check it out though.

Keep the comments coming.
Mark
# Posted By Mark | 8/10/06 12:26 AM
kiasportagecar's Gravatar Hi Brian,

It's something that I'd love to be able to do but I haven't found a nice solution to make it work yet. The reason it won't work is that in the interests of performance the datagrid handles paging on the server side. This means that if we put any client side sorting on it then the sort would only be sorting the available items instead of the entire query sort.
# Posted By kiasportagecar | 6/13/07 7:05 AM
seo's Gravatar It's something that I'd love to be able to do but I haven't found a nice solution to make it work yet. The reason it won't work is that in the interests of performance the datagrid handles paging on the server side. This means that if we put any client side sorting on it then the sort would only be sorting the available items instead of the entire query sort.
# Posted By seo | 3/24/08 8:17 PM
dave's Gravatar hi,Your blog is very useful,You can free add it to pr4 directory http://www.qxiu.net
# Posted By dave | 9/16/08 9:01 PM
NEW battery's Gravatar the most convenient and cheap replacement battery online shop in uk. We specialize in http://www.batteryfast.com laptop batteries,laptop AC adapters. All our products are brand new, with the excellent service from our customer service team.
the most convenient and http://www.batteryfast.co.uk cheap replacement battery online shop in uk. We specialize in laptop batteries,laptop AC adapters. All of batteries are brand new, with the excellent service from our customer service team, you can feel free to purchase on laptop battery!
# Posted By NEW battery | 9/22/08 12:35 PM
warhammer gold's Gravatar Open Source Datagrid
# Posted By warhammer gold | 10/9/08 7:32 PM
Prescription's Gravatar Online Without Prescription http://www.24onlinedrug.com
# Posted By Prescription | 10/24/08 11:48 PM
?????'s Gravatar t.....
# Posted By ????? | 10/30/08 6:47 PM
warhammer gold's Gravatar <A href="http://www.vipwarhammergold.com/" target=_blank><FONT =4><B>warhammer gold</B></FONT></A> <FONT =4></FONT><A href="http://www.vipwarhammergold.com/news/news.html" target=_blank><FONT size=4><B>buy warhammer gold</B></FONT></A><BR><A href="http://www.bestwarhammer.com/" target=_blank><FONT size=4><B>warhammer gold</B></FONT></A><FONT size=4></FONT> <A href="http://www.bestwarhammer.com/news/news.html" target=_blank><FONT size=4><B>buy warhammer gold</B></FONT></A><BR><A href="http://www.aocsale.com/" target=_blank><FONT size=4><B>aoc gold</B></FONT></A> <FONT size=4></FONT><A href="http://www.aocsale.com/aoc-news/" target="_blank">http://www.aocsale.com/aoc-news/" target=_blank><FONT size=4><B>age of conan gold</B></FONT></A><BR><A href="http://www.game4power.com/" target=_blank><FONT size=4><B>wow gold</B></FONT></A> <FONT size=4></FONT><A href="http://www.game4power.com/news/" target="_blank">http://www.game4power.com/news/" target=_blank><FONT size=4><B>buy wow gold</B></FONT></A><BR><A href="http://www.wowgoldone.com/" target=_blank><FONT size=4><B>wow gold</B></FONT></A> <FONT size=4></FONT><A href="http://www.wowgoldone.com/" target=_blank><FONT size=4><B>buy wow gold</B></FONT></A><BR><A href="http://www.game4power.com/" target=_blank><FONT size=4><B>world of warcraft gold</B></FONT></A> <FONT size=4></FONT><A href="http://www.wowgoldone.com/" target=_blank><FONT size=4><B>world of warcraft gold</B></FONT></A><BR><A href="http://www.gamelevelup.com/" target=_blank><FONT size=4><B>wow power leveling</B></FONT></A><BR><A href="http://itemstores.com/" target=_blank><FONT size=4><B>wow item</B></FONT></A>
# Posted By warhammer gold | 11/20/08 12:57 PM