a='MyWheels', c='MIS', f='get_data'. So, {{=URL('MIS','get_data')}} should work. But I do not get the data in dataTable. ---Vineet
On Jun 25, 11:13 pm, Anthony <abasta...@gmail.com> wrote: > Is MIS your app name, or the controller name? If it's the app name, your URL > call also needs the controller name, or it will think MIS is the controller > and the Ajax call will fail. > > > > > > > > On Saturday, June 25, 2011 1:02:50 PM UTC-4, Vineet wrote: > > I tried doing like this:-- > > > In controller-- > > > def get_data(): > > custdata = db.executesql(qry, as_dict=True) > > return response.json(custdata) > > > And in View, > > > ....other code is as earlier (hence omitted) > > "sAjaxSource": "{{=URL('MIS','get_data')}}", > > > Still, the dataTable is blank. > > Pl. help. > > > ---Vineet > > > On Jun 24, 5:56 pm, Vineet <vineet....@gmail.com> wrote: > > > As suggested by the community, I am trying to export json data to > > > dataTable. > > > But only blank dataTable is rendered (with desired formatting, search > > > box, etc.) > > > Pl. introspect into my code as to where I have a mistake. > > > Data is not displayed (as returned by "get_data" method). > > > I have made sure that the tables in MySQL have been populated. > > > > ------------------- > > > Controller > > > ------------------- > > > def show_data(): > > > return dict() > > > > def get_data(): > > > custdata = db.executesql(qry, as_dict=True) > > > return dict(mydata=custdata) > > > > # For testing purpose, I returned response.json(custdata) in a > > > separate method & validated the output on "jsonlint.com". > > > It is valid json. > > > But, here the returned value is dict(mydata=custdata). > > > How do I reference the custdata object in View? > > > Already tried {{=mydata}} in <script> tag in View > > > > ------------------- > > > View (show_data.html) > > > ------------------- > > > {{extend 'layout.html'}} > > > > <script> > > > $(document).ready(function() { > > > var oTable = $('.smarttable').dataTable( { > > > "sScrollY": "200px", > > > "sAjaxSource": "{{=URL('MIS','get_data.json')}}", > > > "sDom": "frtiS", > > > "bDeferRender": true > > > } );} ); > > > > </script> > > > > # html table tags go here > > > > <h1>Customer Database</h1> > > > <br /> > > > <table class="smarttable"> > > > <thead> > > > <tr> > > > <th>Customer Name</th><th>Vehicle No</th>....etc. > > > </tr> > > > </thead> > > > <tbody> > > > > </tbody> > > > </table> > > > > # This link is for testing json data returned. > > > <a href='{{=URL('MIS','get_rows.json')}}'>my_json</a> > > > > Thanks, > > > Vineet > > > > On Jun 22, 1:51 am, "contatog...@gmail.com" > > > > <contatog...@gmail.com> wrote: > > > > It can paginate data? > > > > _____________________________________________ > > > > *Gilson Filho* > > > > *Web Developerhttp://gilsondev.com*-Hide quoted text - > > > > - Show quoted text -