[web2py] Re: Catch rows in Javascript

2012-08-19 Thread Alan Etkin
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


-- 





Re: [web2py] Re: Catch rows in Javascript

2012-08-19 Thread Mathias Van Daele
Hello Alan, Anthony

Thanks both for your reply !!!

In the meantime I also discovered that I have to use JSON for this specific
situation.

I did it like this :

*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 spame...@gmail.com:
 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

 --




-- 





[web2py] Re: Catch rows in Javascript

2012-08-17 Thread Anthony


 How can I catch rows in Javascript code ?


What does this mean? Can you give an example? 

--