OpenJS Grid - an Open Source JQuery Grid

rjlovealice Says:

Aug 29, 2011 - Thank you so much for taking time to answer my questions... I am truly grateful! =)i will not give up... may be i'll rewatch the video and analyze it further. Thanks!!!

joanatyu Says:

Aug 31, 2011 - I want to create a field that will auto compute the average of 7 fields.. Is that possible? Help pls.. Thanks..

optikalefxx Says:

Aug 31, 2011 - you would do it in the database query using AVG

joanatyu Says:

Aug 31, 2011 - can you tell me how?will that automatically compute the average when i enter the values in those 7 fields in the gridThanks for the reply

optikalefxx Says:

Aug 31, 2011 - I need to know your database first, then i can tell you. Email me a SQL dump of your database PM me for my email address

joanatyu Says:

Sep 4, 2011 - i have a question.. can the grid handle thousands of data?Thank you! =D

optikalefxx Says:

Sep 4, 2011 - The most I've used it with is 26 thousand rows. So yes, it can probably handle millions of rows.

mjcarraco Says:

Sep 21, 2011 - It gives me this error:string(94) " SELECT `orders`.``,orders.id FROM `orders` ORDER BY LIMIT 0, " You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 0,' at line 8What that means?Thank you

LearnThruSong Says:

Nov 10, 2011 - Hi there, you appear to have a couple of errors in the SQL:1st - You have the ORDER BY declaration but no argument... you need to tell SQL what to order (the name of the field) by or delete ORDER BY.2nd - If you put a LIMIT declaration in, it restricts the number of rows - or in your case, orders - that the query will return. By adding a LIMIT 0, no matter what you're selecting, the query will limit SQL to returning zero results.Hope this helps!!!

LearnThruSong Says:

Nov 10, 2011 - Also, do you really have a field in your 'orders' table called 'orders'? Also are you trying to concatenate the two fields where after SELECT you have "...`orders`.``,orders.id..."? 

LearnThruSong Says:

Nov 10, 2011 - ABSOLUTELY AWESOME!This provides a lot of the framework I need to make modifying some database tables cleanly and securely behind a custom ACL in PHP. I just need to work out a few details and I'll be jumping in there adding this to my site!Thanks so much for your time developing this!

optikalefxx Says:

Nov 10, 2011 - thanks man! Let me know when you work with it, I'd like to see what you come up with

MylesLeeCrampton Says:

Nov 18, 2011 - Spectacular! Can't wait to make use of it. Many thanks for sharing it :)

nathangsmith18 Says:

Nov 22, 2011 - I'm having the exact same error as mjcarraco. I've tried just about everything [my very limited programming mind] could think of and I can't get to the bottom of this. I understand the obvious sql syntax errors in the but I haven't changed the class files and have set up the index/ajax files as instructed. For some reason grid.php (or maybe grid.js) is creating some weird sql. Any advice for how I can begin to figure this thang out?

MakkeSk8 Says:

Feb 11, 2012 - u talk very fast man.. calm down

optikalefxx Says:

Feb 24, 2012 - well the click is an event ON the tr. So, $(this) refers to the tr, where $(this).attr("primary_key") is the row id

RTRTRAAA Says:

Mar 9, 2012 - I'm very new to databases so please excuse the confusion. I have connected ajax.php to my localhost server, all the table categories display on the grid, but the data doesn't populate. Instead there is a white bar across the grid which reads "loading". I noticed the downloaded ajax.php, index.php, and grid.php have the basic code from your tutorial, but also includes other code (like an additional grid table). Does the "loading" issue sound familiar or have a simple fix? Thanks for your help.

AlexGreatMK Says:

Mar 13, 2012 - Aghh... this is sooo good... too bad it's designed with PHP in mind... will be enough work for me to port to use with ASP.NET ... but regardless... good job.

TrojanSpike1 Says:

Mar 18, 2012 - That looks awesome : I'm gona have a good nosy through the code,, I'll learn a few things no dount..

BKISHANN Says:

Apr 5, 2012 - Really Cool B-)

stratussync Says:

May 22, 2012 - Thank you so much for all of these awesome videos!!! One question... I see that you can freeze rows... but can you freeze the far left column as well as the top row and allow users to scroll through the grid and be able to sort and search while keeping the aforementioned frozen? Kind of of like the Roambi superlist does?

jssumith Says:

May 27, 2012 - thanks it is very cooooooooooooool