Hi,
As you all know, SQLFORM.grid search does not support searching for
multiple words - it throws an error Invalid Query
Searching for multiple words may be a common requirement.
I looked thru various older posting on this group, but none worked for me
AS IS (Possiblly because they were old -
I too have come across this same problem - good to see a solution (Now to
try it for my scenario)
Thanks Kyle !!
-Mandar
On Thursday, February 28, 2013 9:54:35 PM UTC+5:30, sander.vi...@gmail.com
wrote:
Awesome, that's it, field_id.
To prove our loyalty and to please the many python and
don't know on GAE, but usually to match a date you can do either:
1. day = current day, month = current month, year = current year
2. = current day midnight, current day + 1, again midnight
you tried the 1st, did you try the 2nd too ?
On Friday, March 1, 2013 2:51:53 AM UTC+1, jjg0 wrote:
Hi
it's pobably due to this
https://github.com/web2py/web2py/blob/master/applications/welcome/static/js/web2py_bootstrap.js#L27
On Thursday, February 28, 2013 11:29:19 PM UTC+1, Anthony wrote:
Please show some code.
On Thursday, February 28, 2013 5:15:06 PM UTC-5, RHC wrote:
I have a view
I'm using Web2Py for 6 months now, and I'm very happy with it.But here are
the most missing features I found in Web2Py. Most of those missing features
concerns grids/smartgrids.
- inline_editing parameter for SQLFORM.(smart)grid to allow inline
edition of some or all fields (ajax),
i want to access checked check boxes without clicking the submit button ,
and i want these checked check boxes in my fancy box drop down, so after
hitting submit button i can get all checked check boxes in my fancybox drop
down.I have two buttons one button submits the forms and updates the DB
web2py will definitely pythonanywhere in?
Ovidio Marinho Falcao Neto
Web Developer
ovidio...@gmail.com
ovidiomari...@itjp.net.br
ITJP - itjp.net.br
83 8826 9088 - Oi
83 9336 3782 - Claro
Thanks. It certainly looks like that code makes the change I'm thinking of.
However, I don't have a web2py_bootstrap.js in my application's static
folder. I am a few versions behind the latest, so maybe this file is a
recent addition, and another script used to perform this function in older
pythonanywhere.com is great, but I put my trust in amazon ec2
El jueves, 28 de febrero de 2013 18:40:22 UTC-5, Massimo Di Pierro escribió:
web2py.com is moving to pythonanywhere.com. There may be disruptions but
we hope not.
--
---
You received this message because you are subscribed
EC2 is really expensive..
On Fri, Mar 1, 2013 at 6:49 PM, samuel bonilla pythonn...@gmail.com wrote:
pythonanywhere.com is great, but I put my trust in amazon ec2
El jueves, 28 de febrero de 2013 18:40:22 UTC-5, Massimo Di Pierro
escribió:
web2py.com is moving to pythonanywhere.com. There
Hi!
It seams not every times I'm able to setup properly the scheduler to run
a simple function every (for example) 10 seconds.
This is how I run the framework:
$ ./web2py -a secretpass -k appname
This is the task I have inserted (here exported in csv format)
Il 01/03/13 15:14, Manuele Pesenti ha scritto:
Hi!
It seams not every times I'm able to setup properly the scheduler to
run a simple function every (for example) 10 seconds.
This is how I run the framework:
$ ./web2py -a secretpass -k appname
ok, the trick was to use the right option K
Difficult to beat that : ... There's even a useful free plan.
Don't know if web2py can be hosted for free, but I guest yes...
:)
Richard
On Fri, Mar 1, 2013 at 9:11 AM, Phyo Arkar phyo.arkarl...@gmail.com wrote:
EC2 is really expensive..
On Fri, Mar 1, 2013 at 6:49 PM, samuel bonilla
I've been having a lot of trouble trying to clean up my URLs. If my app
name is myapp, and I go out an buy the domain myapp.com, when I deploy the
site all the urls are going to read www.myapp.com/myapp/default/function.
How do I get rid of the app name and controller?
I've read the section
Hi,
I like to make my errorpages a little nicer. adding a link to get back to
my main site... and displaying the error code 400 404 etc.
How can I do that. can I have like a function like error_site() in my
controler?
do I need to do something with the routes.py?
thanks for your help.
--
---
I've begun learning python from an ebook called RealPython
and created my first app:
def question(x):
x = raw_input(What do you want? )
z = raw_input(Why do you want it? )
z = z.replace(my, your)
z = z.replace(I, you)
print So you want, x, z
print
a = raw_input(and why do you want that? )
a
So my app is getting some small audio files via the gluon.tools fetch
method, and then storing them manually in the upload folder via the store()
method. While this works fine on a local server, it doesn't seem to work on
GAE. It's throwing a runtime error: you must specify a
Hello from a novice,
I'am trying to define a field that enables me make my entries sortable
manually. I choose 'integer' as field type:
db.define_table('image',
Field('Position', 'integer', label=T('Position')),
In my controller, I use orderby to sort the entries:
images =
did you try the recommended way already ?
http://web2py.com/books/default/chapter/29/04#Routes-on-error
On Friday, March 1, 2013 3:48:06 PM UTC+1, BlueShadow wrote:
Hi,
I like to make my errorpages a little nicer. adding a link to get back to
my main site... and displaying the error code
Hi,
I'am trying to show my entries in an manually defined order.
I choose 'integer' as field type: *db*.define_table('image',
Field('Position', 'integer', label=T('Position')),
In my controller, I use *orderby* to sort the entries: *images* =*db*().*
select*(*db.image.ALL*,
guys, let's try to avoid YAPHD (Yet Another Python Hosting Debate)
there are tons of deployment solution out there and every one has pros and
cons
--
---
You received this message because you are subscribed to the Google Groups
web2py-users group.
To unsubscribe from this group and
I agree , thats why i run web2py on our own data center :)
On Fri, Mar 1, 2013 at 9:23 PM, Niphlod niph...@gmail.com wrote:
guys, let's try to avoid YAPHD (Yet Another Python Hosting Debate)
there are tons of deployment solution out there and every one has pros and
cons
--
---
You
yep. -k is for certs. -K and -X are scheduler related.
PS: -a is not needed if you want to start just the scheduler process
e.g.
1st shell: web2py.py -a secretpass -- starts the webserver
2nd shell: web2py.py -K theappname -- starts the scheduler process
vs
one-shell-only: web2py.py -a
Sorry, I misunderstood when you said:
m_dsc_clients - is not a legacy table and defined in db.py,
This line in dal.py is wrong (it was recently fixed in trunk):
if rfieldname in hasattr(rtable,'_primarykey') \
it should read:
if rfieldname in rtable._primarykey \
You can either update
thanks Niphlod for this it sounds really good but unfortunatly I get an
empty variable when I do this.
Richard i don't really understand what you like to say.
On Wednesday, February 27, 2013 10:28:12 PM UTC+1, Niphlod wrote:
you should join them and then do the ordering. auto-references are a
Hi guys, I want to add a action button(like delete,edit, view, i/e) at the
grid, something to change a value from the record indicated at the line,
this is my table:
db_events.define_table('alerts',
Field('type', length=20, label='Clase' ),
Field('rule', label='Regla'),
disclaimer: not tested: in a controller, prepare a function
def check_to_true():
if not request.args(0):
return ''
db_events.alerts(request.args(0)).update_record(checked=1)
and then pass links in the grid as
links = [
dict(header='check the rec',
body=lambda row
what does it mean an empty variable ?
On Friday, March 1, 2013 4:04:47 PM UTC+1, BlueShadow wrote:
thanks Niphlod for this it sounds really good but unfortunatly I get an
empty variable when I do this.
Richard i don't really understand what you like to say.
On Wednesday, February 27, 2013
this can only happen in sqlite if you changed the Field from string to
integer. If you delete the db and let web2py recreate it, it will work ok.
On Friday, March 1, 2013 9:33:05 AM UTC+1, St. Pirsch wrote:
Hi,
I'am trying to show my entries in an manually defined order.
I choose 'integer'
well, coding for a web app kind of **needs** different standards than
coding a console program. Web2py itself is based on the MVC pattern, so it
adds another layer of different standards patterns. It may sound
overcomplicated comparing web2py to an ultra-basic console program like
that, but
On 1 Mar 2013, at 6:42 AM, jjg0 miahgor...@gmail.com wrote:
I saw in another question someone posted an example using the parameter based
system:
routers = dict(
# base router
BASE=dict(
default_application='myapp',
),
myapp=dict(
I just discovered that the insert works with the SQLform, but not manually.
Any idea why that would be?
On Friday, March 1, 2013 12:35:08 PM UTC+8, montgome...@gmail.com wrote:
So my app is getting some small audio files via the gluon.tools fetch
method, and then storing them manually in
when I change the line in default.py(example from my first post) to: row =
db(db.table.refrence == db.refrencedtable.Field).
select(db.table.ALL, orderby=db.refrencedtable.Field)
if I do a print row or use row in the view somehow it is blank/empty
On Friday, March 1, 2013 4:32:31 PM UTC+1,
Wow, Thanks Niphlod!,this code worked like a charm!
Additionally how can I append this code:
jQuery(this).closest('tr').remove();
to the callback?
Thanks again for your time!
Christian.
El viernes, 1 de marzo de 2013 12:31:54 UTC-3, Niphlod escribió:
disclaimer: not tested: in a
Now I really like the RealPython book because the author explains it to me
and I 'just get it' but when it comes to reading the web2py manual.. I just
don't get it
for example why does everything always get defined with a return dict()
after it..
Have you gone through the Introduction
That's a good news.
I llike pythonanywhere !
On Thursday, February 28, 2013 5:40:22 PM UTC-6, Massimo Di Pierro wrote:
web2py.com is moving to pythonanywhere.com. There may be disruptions but
we hope not.
--
---
You received this message because you are subscribed to the Google Groups
Oops.
db(db.table.refrence == db.refrencedtable.id).select(db.table.ALL, orderby=
db.refrencedtable.Field)
mind that there have to be records referencing each other, i.e.
db.refrencedtable
*1*, aaa
*2*, bbb
*3*, ccc
db.table
1, 'title1', *1*, ...
2, 'title 2', *1*, ...
3, 'title 3', *1*,
I defined a table 'register
db.define_table('register',
Field('nodeID','reference node'),
Field('viewID','reference view'),
Field('groupID',type=''),
...
migrate=False)
The view a user chooses determines the groups he can become a member of, so
groupID
can be empty or
you didn't ask for that - removing the clicked row - but you're lucky
anyway.
add a delete='tr' to the A helper.
http://web2py.com/books/default/chapter/29/05?search=callback#Built-in-helpers
On Friday, March 1, 2013 4:59:39 PM UTC+1, Christian Espinoza wrote:
Wow, Thanks Niphlod!,this code
I think I was miss leading by your example where
orderby=db.table.reference.Field
To me it should not read like that it should read : orderby=db.table.Field
And Niphold is right you were missing a join, but it should had works if
you only want to order base on the id of the referenced field if
As I mentioned, I am restarting the server with every change to routes.py.
I tried using:
routers = dict(
# base router
BASE=dict(
default_application='myapp',
),
)
But this still does not solve my problem. I need *every *page to hide the
app name and controller, not
Have you considered using a
list:referencehttp://web2py.com/books/default/chapter/29/06#list:type,-and-containsfield
with the IS_IN_DB(..., multiple=True) validator?
On Friday, March 1, 2013 11:06:31 AM UTC-5, Annet wrote:
I defined a table 'register
db.define_table('register',
Hi Massimo,
We did print the t-shirt ourselves ;-)
I'll send you one.
Kind Regards,
Rene
On Thursday, February 28, 2013 6:06:56 PM UTC+1, Massimo Di Pierro wrote:
Where did you get that? I want one.
--
---
You received this message because you are subscribed to the Google Groups
We got a problem when we upgrade to 2.3.2 in JSONRPC called via qooxdoo.
TypeError: testlogin() argument after ** must be a mapping, not
list, JSONRPCError
Which worked fine in 2.2.1
Below is code for controller :
@service.jsonrpc
def testlogin(username, password):
status = 0
The bug is at:
gluon/tools.py
s = methods[method](**params)
it should be
s = methods[method](*params)
On Sat, Mar 2, 2013 at 12:16 AM, Phyo Arkar phyo.arkarl...@gmail.comwrote:
We got a problem when we upgrade to 2.3.2 in JSONRPC called via qooxdoo.
TypeError:
One char fix so i wont be adding a patch. :)
On Sat, Mar 2, 2013 at 12:40 AM, Phyo Arkar phyo.arkarl...@gmail.comwrote:
The bug is at:
gluon/tools.py
s = methods[method](**params)
it should be
s = methods[method](*params)
On Sat, Mar 2, 2013 at 12:16 AM, Phyo
I've found this tip from Massimo on checking file upload progress:
In the upload form add
input type='hidden' name='X-Progress-ID' value='test'/
def upload_page():
...
length_bytes = cache.ram('X-Progress-ID:test:length',None,0)
uploaded_bytes =
Thanks a lot Nihplod, all is working as expected now!!!
--
---
You received this message because you are subscribed to the Google Groups
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
For more
Any reason there for ** ?
On Sat, Mar 2, 2013 at 12:40 AM, Phyo Arkar phyo.arkarl...@gmail.comwrote:
The bug is at:
gluon/tools.py
s = methods[method](**params)
it should be
s = methods[method](*params)
On Sat, Mar 2, 2013 at 12:16 AM, Phyo Arkar
yep, to support keyword arguments. It was an oversight of jsonrpc 1 vs 2
specs.
trunk has it fixed, along with specific 1 vs 2 support (i.e. jsonrpc and
jsonrpc2 decorators)
On Friday, March 1, 2013 8:00:30 PM UTC+1, Phyo Arkar wrote:
Any reason there for ** ?
On Sat, Mar 2, 2013 at 12:40
I c , JSONRPC2 is still in draft right?
we are not using JSONRPC2 yet so that gave us problem.
On Sat, Mar 2, 2013 at 2:12 AM, Niphlod niph...@gmail.com wrote:
yep, to support keyword arguments. It was an oversight of jsonrpc 1 vs 2
specs.
trunk has it fixed, along with specific 1 vs 2
I am running web2py 2.0.9 and this code is in the layout.html file in this
version.
I am wondering what the best way to ensure dynamically loaded or reloaded
components get the same styling as the rest of the page. I don't want to
add my own hack to my pages, becuase if web2py changes what it
http://www.jsonrpc.org/specification
not draft anymore...
mic
2013/3/1 Phyo Arkar phyo.arkarl...@gmail.com:
I c , JSONRPC2 is still in draft right?
we are not using JSONRPC2 yet so that gave us problem.
On Sat, Mar 2, 2013 at 2:12 AM, Niphlod niph...@gmail.com wrote:
yep, to support
sorry for delay:
!-- Modal --
div id=Modallogin class=modal hide fade tabindex=-1 role=dialog
aria-labelledby=myModalLabel aria-hidden=true
div class=modal-header
button type=button class=close data-dismiss=modal
aria-hidden=true×/button
h3 id=myModalLabelLog in /h3
/div
div
Disruption: The book link is broken.
--
---
You received this message because you are subscribed to the Google Groups
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
For more options, visit
Just worked for me, three minutes later.
On Friday, March 1, 2013 5:25:22 PM UTC-5, Rufus wrote:
Disruption: The book link is broken.
--
---
You received this message because you are subscribed to the Google Groups
web2py-users group.
To unsubscribe from this group and stop receiving
# As simple as this? (I'm new too)
routes_in = (
('/$anything', '/myapp/default/$anything'),
)
routes_out = (
('/myapp/default/$anything', '/$anything'),
)
--
---
You received this message because you are subscribed to the Google Groups
web2py-users group.
To unsubscribe from
The link to the online engish book is broken (Invalid request).
On Thursday, February 28, 2013 3:40:22 PM UTC-8, Massimo Di Pierro wrote:
web2py.com is moving to pythonanywhere.com. There may be disruptions but
we hope not.
--
---
You received this message because you are subscribed to
+1 for auth,ajax_login()
I'm also interested in a bare ajax login feature, but, what about the
security risks of passing credentials with javascript in the background?
What are the issues to take in account for that feature? I there any
standard way of securing the passwords and other
routes.example.py is very helpful for this (I was tempted to add another
hint, butnah.)
On Friday, March 1, 2013 9:48:06 AM UTC-5, BlueShadow wrote:
Hi,
I like to make my errorpages a little nicer. adding a link to get back to
my main site... and displaying the error code 400 404 etc.
I may have marked this answered a bit too early. Here are more problems I
am seeing:
1. If you only need date, use Field('appointment_date', 'date') instead
Using Field('appointment_date', 'date') seems to destroy tables. Does
web2py even have a working Field('...', 'date')? When adding a
The second solution, '= current day midnight, current day + 1, again
midnight' doesn't actually solve anything since google app engine does not
allow that sort of query. I believe both will work on any other server,
it's just a gae issue.
On Friday, March 1, 2013 3:38:41 AM UTC-5, Niphlod
Oh I wish it were that simple, but no I still see invalid requests when
trying that:(
Can anyone help me with this? I still have not resolved this issue.
On Friday, March 1, 2013 5:49:46 PM UTC-5, Rufus wrote:
# As simple as this? (I'm new too)
routes_in = (
('/$anything',
On 1 Mar 2013, at 4:14 PM, jjg0 miahgor...@gmail.com wrote:
Oh I wish it were that simple, but no I still see invalid requests when
trying that:(
Can anyone help me with this? I still have not resolved this issue.
When you use the parametric router, what exactly is the complete error
I anticipated that, because I tried it.
I added:
routes_onerror = [
(r'*/*', r'error')
]
to call an error function. in this case, /myapp/default/error
On 3/1/2013 7:14 PM, jjg0 wrote:
Oh I wish it were that simple, but no I still see invalid requests
when trying that:(
Can anyone help
Still broken ...
On Fri, Mar 1, 2013 at 3:10 PM, John Ho john.py...@gmail.com wrote:
The link to the online engish book is broken (Invalid request).
On Thursday, February 28, 2013 3:40:22 PM UTC-8, Massimo Di Pierro wrote:
web2py.com is moving to pythonanywhere.com. There may be
I have had a little look through the web2py source on github and it seems
to me it would be more consistent for components if a function was called
here:
https://github.com/web2py/web2py/blob/master/applications/welcome/static/js/web2py.js#L120that
re-ran the same code found in
I am wrong in the second case. It seems that date() cannot be used in a
query that way, sorry.
For the first case, Field('appointment_date', 'date') should work. I have
similar fields in my program without any problems. I think you may need to
drop the old table and re-create a new table
Ok, I think I see what I did wrong. On further investigation, it turns out
that resetting the server is not good enough to refresh the routes.py file,
you need to actually reload it in the admin interface(I am running the
web2py source on a windows pc, maybe this is different on linux?). The
Dropping that field and creating a new one got it working.
Thanks everyone, I've gotten a lot of really good help on this group since
picking up web2py. Much appreciated!
On Friday, March 1, 2013 8:20:41 PM UTC-5, Mark wrote:
I am wrong in the second case. It seems that date() cannot be
On Friday, 1 March 2013 00:44:00 UTC-6, Vasile Ermicioi wrote:
hi,
a few questions
1)
flask example doesn't work if I use flask routing with parameters
@app.route('/place/int:place_id',methods=['GET','POST'])
@wrapper(view='templates/place.html')
def place(place_id):
return dict()
You probably stored '12' as a string, than changed the type to integer.
On Friday, 1 March 2013 01:46:51 UTC-6, St. Pirsch wrote:
Hello from a novice,
I'am trying to define a field that enables me make my entries sortable
manually. I choose 'integer' as field type:
def question():
form = SQLFORM.factory(
Field('what',label='what do you want?'),
Field('why',label='why do you want it?'))
if form.process().accepted:
z = 'you want %s because %s' % (form.vars.what, form.vars.why))
return locals()
What do you mean?
On Friday, 1 March 2013 09:54:22 UTC-6, montgome...@gmail.com wrote:
I just discovered that the insert works with the SQLform, but not
manually. Any idea why that would be?
On Friday, March 1, 2013 12:35:08 PM UTC+8, montgome...@gmail.com wrote:
So my app is getting
It is back online. Sorry for the disruption but yesterday we moved to
PythonAnywhere and routes broke.
On Friday, 1 March 2013 19:34:50 UTC-6, rh wrote:
On Fri, 1 Mar 2013 15:10:54 -0800 (PST)
John Ho john@gmail.com javascript: wrote:
The link to the online engish book is broken
Direct link is works: http://web2py.com/books/default/chapter/29/00
2013. március 2., szombat 1:43:41 UTC+1 időpontban jjs0sbw a következőt
írta:
Still broken ...
On Fri, Mar 1, 2013 at 3:10 PM, John Ho john@gmail.com
javascript:wrote:
The link to the online engish book is broken
I'm a self taught high school students trying to make a quote of the day
website.
Essentially what I'm trying to do is assign the day of the month equal to a
quote that I have selected. The code runs just fine. I'll post it on the
bottom.
Anyway, the disconnect that I'm getting is inputting
Yesterday we moved web2py.com to PythonAnywhere.com hosting.
Everything should work well. If you experience any problem please report it
here.
PythonAnywhere is a fantastic platform for web2py hosting and moving there
was very simple and painless. The process is now documented in the book.
ok, thank you
--
---
You received this message because you are subscribed to the Google Groups
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
For more options, visit
what's the errors you are getting on GAE?
not sure how up to date this is, but attached is the facebook.py that i'm
currently using on GAE.
cfh
On Tuesday, February 26, 2013 5:10:25 PM UTC-8, Jaime Sempere wrote:
Hi, i'm getting mad using facebook.py, I cannot get it work.
Anyway, I have
Sorry, I misunderstood when you said:
m_dsc_clients - is not a legacy table and defined in db.py,
It's my fault, the explanation was a bit unclear.
This line in dal.py is wrong (it was recently fixed in trunk):
if rfieldname in hasattr(rtable,'_primarykey') \
it should read:
if
Hi
There is another exception
type 'exceptions.KeyError' 'field_name'*File
/var/www/py/web2py/gluon/dal.py in create_table at line 811*
806.
807.
808.
809.
810.
811.
812.
813.
814.
815.
ftype = ftype + \
types['reference
I have started my application with 4 workers.
But some workers have stopped (?) and now there is only one active worker.
How can I add additionals workers without having to restart the
application? Is it sufficient to add some records to db.scheduler_worker?
Which values should I choose for the
83 matches
Mail list logo