[web2py] Quick Query Tips

2016-08-03 Thread web2pyuser777
Hello all! So i'm using web2py to allow users to use a form to query a database. This is all done with DAL, SQLFORM.factory, and the results displayed using SQLFORM.grid... right now, after the form submits, i set the variables (session.name = form.vars.name) and create a query. This query is

[web2py] Re: having issues with dates and DAL

2016-07-21 Thread web2pyuser777
Thank you all very much! -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2p

[web2py] Re: having issues with dates and DAL

2016-07-20 Thread web2pyuser777
Actually found out i was using the non datetime version of the date in the database... Thanks all for the help. Secondary question. after i get this question i run a query with a following code: query = db.table.id > 0 if fruit: query &= db.table.fruit == fruit however, the database stores

[web2py] Re: having issues with dates and DAL

2016-07-20 Thread web2pyuser777
I'm not sure what you mean... Oracle stores the date type using "/" instead of "-" or ".".. i looked into the code for the parsing that web2py uses and it only parses with "+" "-" or "." so that is why i think my issue is arising. I was wondering if anyone knows an intermediary step i can take t

[web2py] Re: having issues with dates and DAL

2016-07-20 Thread web2pyuser777
What i've found is that the oracle has the date stored at 2016/04/12 and when the parse occurs, it looks for a - to seperate and cant find it. This is why it states that its not an integer because the "/" are included in the term... is there a way to parse with "/" instead of "-"? i know SQL st

[web2py] having issues with dates and DAL

2016-07-19 Thread web2pyuser777
Hi everyone, i keep getting this error: File "/web2py/gluon/packages/dal/pydal/adapters/base.py", line 1544, in parse_date (y, m, d) = map(int, str(value)[:10].strip().split('-')) ValueError: invalid literal for int() with base 10: '2016/04/12' im basically submitting the form and searchin