If you look at your page source can you see what is being rendered for
[[=results]] in your script section?
Jim
On Thu, Dec 23, 2021, 6:38 PM Dave S <snidely....@gmail.com> wrote:
>
> On Tuesday, December 21, 2021 at 1:05:08 PM UTC-8 Jim S wrote:
>
>> I wish I could help, but I'm not javascript guru. That's why I've moved
>> to py4web, grid and htmx.
>>
>> Do you have the datatables .css and .js files loaded?
>> jquery.dataTables.min.js is not all that you need.
>>
>> cdn.datatables.net/1.11.3/css/jquery.dataTables.min.css
>> cdn.datatables.net/1.11.3/js/jquery.dataTables.min.js
>>
>> -Jim
>>
>>
>
> Thank you, that was a useful clue. I am now able to get it to draw the
> table. Next, figuring out why the data isn't showing.
>
> /dps
>
>
>
>
>> On Monday, December 20, 2021 at 10:01:32 PM UTC-6 snide...@gmail.com
>> wrote:
>>
>>> Jim? Other datatable gurus?
>>>
>>> /dps
>>>
>>>
>>> On Thursday, December 2, 2021 at 4:30:20 AM UTC-8 Dave S wrote:
>>>
>>>> That's the error I'm getting, according to Chrome's console.
>>>>
>>>> The view code is pretty simple:
>>>>
>>>> <script>
>>>> var table;
>>>> $(document).ready(function(){
>>>> table = $('#tableXactions').DataTable( {
>>>> "data": {{=results}} ,
>>>> "columns": [
>>>> /* { data: 'xaction.PostDate'}, */
>>>> { data: 'xaction.Id' },
>>>> { data: 'xaction.Amount' },
>>>> { data: 'xaction.Expense' },
>>>> { data: 'xaction.Tag' }
>>>>
>>>> ]
>>>>
>>>> });
>>>>
>>>> });
>>>> </script>
>>>>
>>>> <table id="tableXactions" >
>>>> <thead>
>>>> <tr>
>>>> <th>Id</th>
>>>> <th>Amount</th>
>>>> <th>Expense</th>
>>>> <th>Tag</th>
>>>> </tr>
>>>> </thead>
>>>> <tbody></tbody>
>>>> </table>
>>>>
>>>> The console shows that jquery.dataTables.min.js (and the css) is loaded
>>>> from the datatables.net cdn (1.10.19, not the latest but close). Both
>>>> my debug code and the console show that my results are as expected, so I
>>>> don't think the controller is where I messed up.
>>>>
>>>> The actual console message is
>>>>
>>>> listing:96 Uncaught TypeError: $(...).DataTable is not a function
>>>> at HTMLDocument.<anonymous> (listing:96)
>>>> at i (jquery.js:2)
>>>> at Object.fireWith [as resolveWith] (jquery.js:2)
>>>> at Function.ready (jquery.js:2)
>>>> at HTMLDocument.K (jquery.js:2)
>>>> (listing is my view/default/listing.html)
>>>>
>>>> I get this error even if I have no options in the DataTable() call.
>>>> (And I should be using DataTable(), not the dataTable() version, right?
>>>> Equivalent, but different return types....)
>>>>
>>>> I have Roger's example, but it's much more complex than I'm ready for.
>>>> The sample on web2pyslices.com is about right, but uses a much older
>>>> version. The examples on datatables.net are snippets that they assume
>>>> you know where to put them.
>>>>
>>>> What's the fix for my mistake (or at least, what's my mistake?)
>>>>
>>>> /dps
>>>>
>>>> --
> Resources:
> - http://web2py.com
> - http://web2py.com/book (Documentation)
> - http://github.com/web2py/web2py (Source code)
> - https://code.google.com/p/web2py/issues/list (Report Issues)
> ---
> You received this message because you are subscribed to a topic in the
> Google Groups "web2py-users" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/web2py/L6M5EBRE1kM/unsubscribe.
> To unsubscribe from this group and all its topics, send an email to
> web2py+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/web2py/b7bb9aa4-968e-4431-9daf-1b4dab898c80n%40googlegroups.com
> <https://groups.google.com/d/msgid/web2py/b7bb9aa4-968e-4431-9daf-1b4dab898c80n%40googlegroups.com?utm_medium=email&utm_source=footer>
> .
>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/web2py/CAERBpoCU26YU_ttx7TmCw9c9deCufDepRKV1pQsZqYh5MCNM9w%40mail.gmail.com.
