process web2py results in javascript

Question

Complete newbie to web2Py.... I have a web page that has a dropdown menu and I want to perform certain queries based on the value selected.

Reports.html

<h2>Reports</h2>

<p>Please select a report template or choose to write your own.</p>

<select id="ReportSelect" onchange="ReportSelectionChange()">
    <option disabled selected value="0"></option>
    <option value="1">option 1</option>
    <option value="2">option 2</option>
</select>

<script language="javascript" type="text/javascript">
function ReportSelectionChange()
{
    var menuItem = document.getElementById("ReportSelect").value;

    switch(menuItem)
    {
        case "1":
                {{=myform}}
                break;
        case "2":
        default:
                alert(menuItem);
                break;
    }
}

controller python file

def reports():
user_id = request.args(0)
tuple = db(/*My query here*/).select()

myform = FORM('/*not sure what goes here*/')

return dict(tuple=tuple, myform=myform)

I want to pass back all the results from the query to the calling page and have the results appear in a table.

Q: How can I do this? what needs to get passed back? can this even be accomplished with javascript?

Leonel Câmara · Accepted Answer · 2017-02-28 00:21:51Z

1

You are mixing HTML generated by web2py with javascript in a way that will not work. Remember that javascript is executed client side and python is server side.

In this case I suggest you start with trapped links: http://www.web2py.com/books/default/chapter/29/12/components-and-plugins#Trapped-Ajax-links-and-the-A-Helper

Which will work well for your usage of either browsing or creating. Later you can revisit this page and make it better.

answered Feb 28, 2017 at 0:21

Leonel Câmara

1053 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Marlysson · Accepted Answer · 2017-02-28 22:17:18Z

Use ajax function, the ajax function will be executed in some event ( this case onclick of the select item , then will run some method in your controller, this method in controller will return the data from db and the ajax function have parameter that means the target that result will be appended .

1.Use the ajax function on option element indicating that will executed on onclick event. 2. In method in your controller make the search on database and return the result. 3. Set the target of ajax function to some element in your html ( table , li's ...)

1.

<select id="ReportSelect" name="myoption">
    <option disabled selected value="0"></option>
    <option value="1" onclick="ajax('{{=URL('controller', 'method')}}', ['myoption'], 'your_target')" />option 1</option>
    <option value="2">option 2</option>
</select>

2.

def method():
    data = request.vars.myoption
    your_result_query = db(your_query)

    elements = UL(LI(content) for i in your_result_query)
    return dict(result=elements)

In your view put a element with id with same name of target of ajax_function .

Collectives™ on Stack Overflow

process web2py results in javascript

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related