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 -
