can i use the cfgrid-lucee ongithub for my stored ...
# lucees
Simone
03/27/2023, 8:06 PMcan i use the cfgrid-lucee ongithub for my stored procs, which i am calling using cfquery, i am not doing any pagination or sorting in there, so what could be best approach without modifying teh spx
s
sknowlton
03/27/2023, 8:08 PMthe answer to 'can I use cfgrid' is 'no'
👍 1
sknowlton
03/27/2023, 8:09 PMunsupported tag using an obsolete version of datatables to do something there are many modern libraries out there to do for you (including datatables)
s
Simone
03/27/2023, 8:18 PMu are cfgrid-lucee is using old datatatbles
s
sknowlton
03/27/2023, 8:18 PMlast commit = 6 years ago
s
Simone
03/27/2023, 8:19 PMits using datatables 1.10.3
s
sknowlton
03/27/2023, 8:20 PMreleased on october 9, 2014
s
Simone
03/27/2023, 8:20 PMeven if i use 1.13.4, i am sure its not going to break because its backward compatible
Simone
03/27/2023, 8:20 PMand what other alternative i have if i do not use this
s
sknowlton
03/27/2023, 8:21 PMyou didn't say what you were trying to do, but presumably it's 'displaying a bunch of stuff from a database,' in which case the answer is: you can use HTML tables, you can use datatables if you're cool with relying on jQuery, or you can use one of the many alternatives to datatables out there
s
Simone
03/27/2023, 8:22 PMand what are those alternatives
s
sknowlton
03/27/2023, 8:22 PMI just came to say that the answer to the question 'can I use (this coldfusion UI tag that Adobe long since dropped and Lucee never added to begin wtih) was 'no' in 2019 and it's 'definitely no' today
sknowlton
03/27/2023, 8:23 PMI'd suggest you start with datatables and then locate alternatives based on what you don't like about datatables
s
Simone
03/27/2023, 8:23 PMi never mentioned i am using cfgrid, i mentioned a custom build functionality named as cfg5rid using datatables
but if there is something better out there, would love to explore, please suggest
s
sknowlton
03/27/2023, 8:24 PMdatatables is used all over the place and is an excellent library that we used for years. The only reason we don't still use it is because we moved away from jQuery a couple years ago
sknowlton
03/27/2023, 8:24 PMbut lots of people still use jQuery
sknowlton
03/27/2023, 8:25 PMthere is not a coldfusion-specific answer to this question because CF is a back-end application engine and is in the business of supplying data to libraries that handle visual displays, rather than displaying the data itself
s
Simone
03/27/2023, 8:26 PMi know u taking about(guess i am not wrong) about vue / react/ node which are far better than old jquery, but for legacy products, i think this is the best
s
sknowlton
03/27/2023, 8:27 PMjquery gets the job done for sure, just make sure you're using a current version and not whatever some github project from several years ago makes you use
j
John Wilson
03/27/2023, 8:28 PMs
sknowlton
03/27/2023, 8:28 PMyeah we use qtables, though they mostly make me miss datatables. 🙂
s
Simone
03/27/2023, 8:28 PMyeah, hear about it a lot, but for modern ui work, i use element ui
j
John Wilson
03/27/2023, 8:29 PMthey do lack in some areas but quick and easy
s
Simone
03/27/2023, 8:29 PMmaybe ut element ui plus is accessibility enabled so that is helful for me
Simone
03/27/2023, 8:30 PMsince my question went unanswered,
can i still use SPX with datatables without modifying the SPX to pass the sorting etc etc
s
sknowlton
03/27/2023, 8:31 PMdatatables is a front end UI library for displaying tabular data. it has nothing to do with stored procedures
sknowlton
03/27/2023, 8:32 PMif you're asking whether datatables will handle sorting from (some data source, like maybe a stored procedure), the answer is yes, but datatables doesn't care that it's a stored procedure, it just wants an array of stuff to display
💯 1
s
Simone
03/27/2023, 8:33 PMThanks
4 Views