Anyone can help with this?
Trying to update web2py again but still having this same problem. Any left
join in this oracle db get this type of error.
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.c
I'm trying to move an app from a old version of web2py (2.14) to latest
version. After updating some code i'm stuck on the error below.
If i remove the left join the query works. And I dont find anything about
changes on 'left' syntax.
Someone knows whats wrong?
left_join() takes exactly 2 a
environment: Debian 7.11; python 2.7.3; web2py 2.14.5 running on rocket
background:
An application that have many clients periodically sending data, some are
http posts some others json.
About 2 month ago it started to eventually throwing this error on console:
2017-08-01 15:50:37,966 - Rocket
I got too many of this error lately. And its getting worse every day. I
have no idea what to do to stop these errors. I have to reset rocket every
few hours.
Was this fix eventually reverted ? Someone knows the file it is this
workaround?
--
Resources:
- http://web2py.com
- http://web2py.com/
rt.py", line 85, in
custom_importer
modules_prefix, globals, locals, [itemname], level)
ImportError: No module named modules
Em terça-feira, 16 de junho de 2015 14:03:42 UTC-3, Fabiano Faver escreveu:
>
> I have tried to follow this tutorial:
> http://www.web2pyslices.com/sli
I have tried to follow this tutorial:
http://www.web2pyslices.com/slice/show/1579/web2py-and-redis-queue
Just changed the arguments in the enqueue function to be fixed:
def contato():
form = SQLFORM.factory(Field("name"), Field("message"))
if form.accepts(request):
# enqueue the e
Niphlod, I have a small app the DB is getting big quickly and was asked to
do a cache layer..I just started started to learn about it and i'm already
lost. Could you point the direction to a newbie how to do it? Is it just
some code change in web2py? I saw there is this Redis but didn't read ye
I have to paginate a search page that use a HTML form and request.vars to
get the fields and values to search. As its is a dynamic form only two
fields are fixed and the rest is dynamic.
example:
fixed
request.vars.tpdoc = 1
request.vars.group = 3
dynamic
request.vars.name = 'abc'
request.vars.p
niphlod I'm having a problem with left with AND.
this is the sql I want to work:
SELECT *
FROM permissao_grupo
LEFT JOIN auth_membership ON auth_membership.id_permissao_grupo =
permissao_grupo.id
AND user_id =3
WHERE permissao_grupo.id_grupo =5
this is what i tried until now:
db((db.permissao_g
I would like to implement the example
of
http://web2py.com/books/default/chapter/29/07#Adding-extra-form-elements-to-SQLFORM
inside auth.register form.
Then try to validate if its checked.
auth.settings.register_onvalidation = checkaceito
And I set that users need approval to login:
auth.s
eature description in docs:
>
>
> http://web2py.com/books/default/chapter/29/06?search=tenancy#Common-fields-and-multi-tenancy
>
>
>
> Dne středa, 9. ledna 2013 13:31:59 UTC+1 Fabiano Faver napsal(a):
>>
>> Its my first time dealing with multi tenancy and I'm still a bi
Its my first time dealing with multi tenancy and I'm still a bit confused
how i could implement it with my scenario.
I've built a app and want to allow that each 'company' access only their
data. Each company have their user admin that can register
products,things,etc and other users and their
I tried the book example
in http://web2py.com/books/default/chapter/29/07#SQLFORM-in-HTML
It's not working. I tried to use to sqlform.process from a html form using
the way, but did not work. Then I tried exactly the same code on book and
still did not work.
Its not validating the form, just fla
gt; On Tuesday, 27 November 2012 05:29:03 UTC-6, Fabiano Faver wrote:
>>
>> in web2py book:
>> In the case of a table including an "upload"-type field ("fieldname"),both
>> process(dbio=False) and validate() deal with the storage of the uploaded
>> file
in web2py book:
In the case of a table including an "upload"-type field ("fieldname"), both
process(dbio=False) and validate() deal with the storage of the uploaded
file as if process(dbio=True), the default behavior.
it means that I cannot delay the upload?
model based on Massimo examples:
db
Esta rodando muito em no meu galaxy nexus. Android 4.1.1
Navegabilidade está bacana.
Em segunda-feira, 3 de setembro de 2012 20h46min12s UTC-3, rochacbruno
escreveu:
>
>
> Hi, I just published a beta version of web2pyslices reader for Android:
> https://play.google.com/store/apps/details?id=com.
Se for somente para por um limite maximo. Há os parametros maxtextlenght,
um limita todas as colunas para o mesmo e o outro você passa um dicionário
com os campos e os limites.
Mas se for para setar um tamanho fixo para as colunas creio que será
necessario usar CSS.
Em segunda-feira, 3 de sete
quot;1", _id="1")
> 0 selected="selected" value="1">1
>
> Adapting to your case:
>
> {{for row in rows:}}
> {{=row.descricao}}{{=SELECT(*[OPTION(option,
> **{"_value": option, "_selected":"selected"
try:
> db.table[key].update_record(level=value)
> except:
> # do something if key is invalid.
> db.commit()
> redirect("URL TO REDIRECT AFTER UPDATES") # or use ajax
>
> Now in views/controller/test.html
>
>
>
in views/controller/test.html
>
>
>
>{{for row in rows:}}
> {{=row.name}} **
>{{pass}}
>
>
>
>
> On Wed, Aug 22, 2012 at 3:16 PM, Fabiano Faver
> > wrote:
>
>> | name | level |
&g
I would like to know what tool I could use to create a big form that have
rows referencig a record in db.table, something like a SQLFORM.grid. But
much simpler and i could change the values directly on this table and have
only one submit to update them all. In this example I just want to update
My example is written in a previous post. Last one before today. What is in
book and what im trying to do.
Em 13/07/2012 14:26, "Massimo Di Pierro"
escreveu:
> What need to be distinct? can you provide an example of data?
>
> On Friday, 9 March 2012 13:51:25 UTC-6, Fabiano Fav
I still don't know how manage this. Anyone?
Em quinta-feira, 8 de março de 2012 11h20min17s UTC-3, Fabiano Faver
escreveu:
>
> I`m trying to select distinct printers used in each day but i`m not
> managing to use the distinct argument
>
> count = db.contadores.id_impresso
July 10, 2012 9:49:40 PM UTC+1, Fabiano Faver wrote:
>>
>> controller:
>>
>> def gerenciar_grupos():
>>
>> form_not_usu = SQLFORM.factory(
>> Field('usuarios', requires=IS_IN_DB(db,
>> db.auth_user,'%(email)s',multiple=True),widget=SQLFOR
ulho de 2012 16h46min48s UTC-3, Richard escreveu:
>
> in your model Field(..., default=True) or in the controller
> db.table.field.default=True
>
> You also need to use checkbox widget.
>
> Richard
>
> On Tue, Jul 10, 2012 at 2:39 PM, Fabiano Faver wrote:
>
>> I
ng to use 2 FORMs now..
Em terça-feira, 10 de julho de 2012 16h46min48s UTC-3, Richard escreveu:
>
> in your model Field(..., default=True) or in the controller
> db.table.field.default=True
>
> You also need to use checkbox widget.
>
> Richard
>
> On Tue, Jul 10, 2012 a
I want to creat something similar to SQLFORM(auth_membership) but I want
the user to choose a group and all users show up as checkboxes and users
who already belong to this group are checked as well.
I`m downt know how to pre-select these auth_users.
any tips?
Will it be implemented in 2.0?
I would like to use something like this, but I don`t know how to do it yet.
Any tips that I can build a manager_group that can manage who belongs to
the other groups?
Em domingo, 29 de janeiro de 2012 23h17min06s UTC-2, Massimo Di Pierro
escreveu:
>
> auth.mygrou
It can be associated with auth groups? I want to limit content access for
some users groups. Using the scenario given by Ovidio, every hospital user
could see it own content, managers would see content from many hospital of
a region and administrators, directors would see all hospitals. Preferab
Thanks for the tips Villas, Annet and Pbreit.
I checked this bootstrap and really liked what I can do with it. indeed it
is very helpful.
Please correct me if I am wrong
But it seems to load all modal DIVs into the page as hidden.
My page would have many links to modal windows and a SQLFORM inside
I have a page with some edit links that redirect to a simple edit page
using SQLFORM.
I would like to open this form in a modal window and if possible when the
form is submited the link is replaced in parent window. (justo to change
the icon image of the link).
Someone can advice a easy to us
7;,'integer'),
Field('copytwocolor','integer'),
Field('scanner','integer'),
Field('fax','integer'),
Field('total','integer'),
Field('data',
But because of the group by clause it are too slow and I curious to know if
I can query each company separately do what i must with the data and show
the result on page as soon as they are ready
2012/5/16 Fabiano Faver
> I'm trying to display a table with the name of some companies
I'm trying to display a table with the name of some companies with the
background color of each TD or DIV dependent of the last day the printers
company were checked
this it what I have now:
def exibicao_empresas():
#get companies
empr = db(auth.accessible_query('read', db.empresa,
au
I have a page that have a slow query using group by but it are slowing down
the query so I thought to load each item separately and showing them as
they are done. Web2py have any tool that can help me with this or I need to
use another approach?
db.contadores).count()
> db(db.contadores)._count()
>
> On Friday, 9 March 2012 11:25:14 UTC-6, Fabiano Faver wrote:
>>
>> Same thing...
>>
>> print db(db.contadores.id>0)._count() - it respond a sql (with or
>> without argument)
>> print db.cont
pm
count = db.contadores._count()
File "C:\web2py\gluon\dal.py", line 6774, in __getattr__
return self[key]
File "C:\web2py\gluon\dal.py", line 6714, in __getitem__
return dict.__getitem__(self, str(key))
KeyError: '_count'
Em sexta-feira, 9 de ma
definitely has a "_count" method...
>
>
>
> Il giorno venerdì 9 marzo 2012 15:55:42 UTC+1, Fabiano Faver ha scritto:
>>
>> Niphlod, this is what i got, using distinct argument or not:
>>
>> Traceback (most recent call last):
>> File "C:
s.data==dias_passado)).count(distinct=db.contadores.id_impressora)
Em sexta-feira, 9 de março de 2012 10h54min59s UTC-3, Niphlod escreveu:
>
> ooops, sorry, the _count method is on the table, not the field
> try with
>
> db.contadores._count(distinct=db.contadores.id_impressora)
&g
res.id_impressora._count(distinct=db.contadores.id_impressora)
>
> (mind the _ before count.)
>
> If you can fire off queries on your db using another tool than web2py
> (let's say, phpmyadmin), try to copy the resulting string into that and
> watch if the query raises an erro
MySQL
Em sexta-feira, 9 de março de 2012 08h59min46s UTC-3, Niphlod escreveu:
>
> what db are you using ?
>
>
> Il giorno giovedì 8 marzo 2012 15:20:17 UTC+1, Fabiano Faver ha scritto:
>>
>> I`m trying to select distinct printers used in each day but i`m not
>
I`m trying to select distinct printers used in each day but i`m not
managing to use the distinct argument
count = db.contadores.id_impressora.count()
for row in
db((db.contadores.id>0)&(db.contadores.data<=today)).select(db.contadores.data,count,groupby=db.contadores.data):
print row.con
I had this same doubt and this thread have helped as there is no
explanation on online book.
But I want to make the rows selectable to allow user to update all them
toguether.
I have no clue how to edit the submit button that shows at the end of the
table when selectable is active.
Any tips?
i'm using admin interface.
just tried a 'import serial' and copied pyserial from python site-packages
to web2py site-packages
I'm dealing whit this exact issue now, i cant import pyserial. same thing
above, its not finding wintypes. and it seems that some manage to import it.
I'm willing to control a external device with web2py through serial port.
Thanks Noel and Anthony both have worked!
what it was worrying me is that I didn't want to just redirect the user, it
will have to run some code and will redirect to specific pages based on user
group and data on page. I guess i would put these codes in a page anyway and
redirect, but perhaps i
I'm tryng to put a button thaat calls a action which in the end will
redirect to another page. but its like the function is not known.
I've tryed in view:
and:
in controller:
def atualizar():
#add some code here later
redirect(URL('index'))
butthis is what I got:
Un
47 matches
Mail list logo