[web2py] Re: Web2Py function to query the database...

2013-01-15 Thread Mihir Lade
Hi Anthony, Thanks for your reply. The code to searchFlights is as below: def searchFlights(): return dict() def show(): *receivedFlights =

[web2py] Re: Web2Py function to query the database...

2013-01-15 Thread Mihir Lade
Also, I am querying a local database that I created using the DAL. Yes, I am creating a custom HTML form and posting it to web2py to query the database.. On Sunday, January 13, 2013 9:45:11 AM UTC+10:30, Anthony wrote: Can you provide more details regarding what you have tried? How are you

[web2py] Re: Web2Py function to query the database...

2013-01-15 Thread Anthony
Answered on StackOverflow: http://stackoverflow.com/a/14341931/440323 On Tuesday, January 15, 2013 3:19:13 AM UTC-5, Mihir Lade wrote: Hi Anthony, Thanks for your reply. The code to searchFlights is as below: def searchFlights(): return dict() def show(): *receivedFlights =

[web2py] Web2Py function to query the database...

2013-01-12 Thread Mihir Lade
Hi Guys, I am currently working on an assignment where I need to create a function which would query the database to search flights available according to the users input through the HTML form. I have attached a picture of the HTML form. Basically the user, selects the origin, the

[web2py] Re: Web2Py function to query the database...

2013-01-12 Thread Alan Etkin
The book has anything you are asking for and much more. For an introduction to forms and controllers I think you could check the examples at Overview: http://www.web2py.com/books/default/chapter/29/03#Overview Also, there are appliances available you can use as example:

[web2py] Re: Web2Py function to query the database...

2013-01-12 Thread Mihir Lade
Hi Alan, I've read the chapters a few times however having difficulty understanding a HTML search page would pass the information to a function where it queries multiple databases to return the data? On Sunday, January 13, 2013 8:14:07 AM UTC+10:30, Alan Etkin wrote: The book has anything

[web2py] Re: Web2Py function to query the database...

2013-01-12 Thread Anthony
Can you provide more details regarding what you have tried? How are you creating the form and posting to web2py? Are you querying local databases that you are modeling with the DAL, or are you querying some external API's? When you submit a form to web2py (via GET or POST), the variables will

[web2py] function in query

2011-02-11 Thread Manuele Pesenti
Hi, how can I select records of a table that got 2 date fields (one datetime and a simple date) wich difference is a fixed value? I thought this solution: import datetime today=datetime.datetime.today() yesterday = today.date() - datetime.timedelta(days=1) db.define_table('mytab', ...

Re: [web2py] function in query

2011-02-11 Thread w2padawan
2011/2/11 Manuele Pesenti manuele.pese...@gmail.com: (...) TypeError: float() argument must be a string or a number Thank you very much for any help. Manuele where/why is the/a float argument?