Is it possible to use web2py language in javascript file (.js)?

Question

I'm trying to use AJAX with web2py language but I have a problem My code is:

javascript

$(document).ready(function(){
    $(".className").click(function(){
      jQuery.ajax({
      type:'POST', 
      url:'getName',
      data:{
       itemName:'a'
      },
      timeout: 20000,
      success: function(msg) {
         alert(msg);
      },
      error: function(objAJAXRequest, strError){
         alert( "Error:" + strError );
      }
    });
});

default.py

def getName():
    itemName=request.vars.itemName
    return "Name: " + itemName

The thing is I want to use the data from the database, but is it possible to use

{{for item in tableName:}}
var name={{=item.name}}

like this?

I'm not sure how to extract data from DB in javascript. Can you help me a bit? Cheers

It's not clear what you are trying to do. Is getName supposed to return a string or Javascript code? Where are you wanting to put {{for item in tableName}}? What is item.name? — Anthony
– Anthony, Commented Oct 17, 2011 at 15:26
I want to return a name variable which is string. and I wanna put {{for ....}} into javascript before itemName: is located. Finally item.name is for all the names in the name field. Is it possible?? if it is not is there any alternative? — Web2py user
– Web2py user, Commented Oct 17, 2011 at 15:37
Sorry, still don't quite get it. Maybe open this up on the mailing list and show some more code. You can use the web2py views to generate JS, but it has to be done on the server side -- you can't mix web2py template code with JS that is running on the client side (the browser won't know what to do with it). — Anthony
– Anthony, Commented Oct 17, 2011 at 16:14

Eric S. Bullington · Accepted Answer · 2011-10-18 22:17:50Z

The short answer is that you can't directly extract data from the db in javascript using web2py. You have to query the db with web2py, and then use web2py to send your query data to the javascript (or more accurately since you're using ajax, use jquery/javascript to pull your query data down from web2py). Make sure that you actually need to perform logic on the client (javascript) side here, because the easiest thing to do would be to perform all your logic in python in the web2py controller.

However, if you do for some reason need to perform logic on your data on the client side, then you are on the right track. The easiest thing for you to do would be fetch the records you need from the db in the web2py controller, then package the records up as a json object in your web2py controller ("import simplejson" or you can do it with the standard library with the latest version of python), then return that json object to make it available for your js to fetch using the ajax request you've included above. Only at that point should you loop through the json object using the javascript to get the data you need.

That said, if you're just trying to get a field from a single record from the database, the easiest thing to do would be just to query the database correctly to get that record, and return it in a web2py controller for your ajax script to get.

Collectives™ on Stack Overflow

Is it possible to use web2py language in javascript file (.js)?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related