[web2py] best way to load more db tables via ajax

2014-05-12 Thread Trevor Overman
What would be the most effective way to load, for example, 25 more database tables via an ajax function on clicking, for example again, a more button? What I am trying to do is load the first 25 tables and have this list concatenated for the next 25 in the sorted list. The problem I'm running

[web2py] help with jsonrpc

2014-03-01 Thread Trevor Overman
So I'm trying to connect an android application to my web2py website back end database by using json remote procedure calls. Currently, I am trying to make a simple test function to remotely add entries in the db. Additionally, I am running on GAE. What I have right now is: db.py

[web2py] Re: help with jsonrpc

2014-03-01 Thread Trevor Overman
ah you're right.. x.x... unfortunately, I am still receiving the same error. Another thing, when I try accessing the url with a specific port, ex. http://domain:port/app/default/call/run/test_add?a=3b=4http://domain/app/default/call/run/test_add?a=3b=4GAE is sending me a timeout error. hmm...

Re: [web2py] help with jsonrpc

2014-03-01 Thread Trevor Overman
Finally got things working. For anyone out there reading this, I fixed the problem by utilizing urlfetch in GAE. @service.jsonrpc def test_add(a,b): number_sum = a+b db.testing.insert(number_sum=number_sum) return a+b def test(): from gluon.contrib.simplejsonrpc import

[web2py] Edit a variable in a controller / view with ajax

2013-08-25 Thread Trevor Overman
So what I’m trying to do is have an ajax function that would sort a list in the view that is defined in the controller. Ex. View a onclick=ajax();sort/a div id=”my-list” {{for item in sorted_list:}} div id =”list-item” {{=item}} /div {{pass}} /div Controller sorted_list =

[web2py] DAL select help

2013-07-22 Thread Trevor Overman
In my database, I have a list of items stored. What I am trying to do is select a database row when the list in the database contains the item that I am iterating through in the controller. Do anyone know how this could be done ? model db.define_table('table',

[web2py] Datetime calculations and some genearal functionality advice

2013-04-25 Thread Trevor Overman
So for the website that I'm developing I want my users to be able to set availabilities, and after they have expired, I want them to be set as inactive . Also another feature would be validating the form to make sure the start and end time contained a vaild availibility (ex. the start time