Controller :

def locations():
    locations=db(db.value.cat==2).select().as_list()
    import gluon.contrib.simplejson
    return gluon.contrib.simplejson.dumps(locations)

In the script from the view, I could catch the locations like this :

VIEW:

 var locations;

...

 $.getJSON('/cascade/default/locations',
      function(data){ locations=data;
      var select = document.getElementById("reaction_value");      
      select.options.length = 0; // clear out existing items
      for(var i=0; i < locations.length; i++) {
                var d = locations[i];
                select.options.add(new Option(d.val,d.id));
                 }                
             });

....

Best regards,

Mathias





2012/8/19 Alan Etkin <spametki-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>:
> Do you want to access DAL Row objects in the browser with javascript?
>
> I think that the simplest way is to convert a Rows object to dict and do a
> json dump of it, then assign the data to a js variable in the view
>
> controller
>
> import simplejson
> myrows = db(query).select().as_dict()
> return dict(data=simplejson.dumps(myrows))
>
> view
>
> {{=SCRIPT("var mydata = %s;" % data)}}
>
>
>
> El viernes, 17 de agosto de 2012 08:52:56 UTC-3, Mathias escribió:
>>
>> Hi,
>>
>> How can I catch rows in Javascript code ?
>>
>> Thanks
>>
>> Mathias
>
> --
>  
>  
>