after updating this error occurs:
line 514, in parse\nif name in self.lexers:\nTypeError: argument
of type \'NoneType\' is not iterable\n'
Jose
ps you?
.requires = IS_IN_SET([x for x in range(1, 4)], zero=None)
Jose
ry, fields=fields, ...,
linkto=URL(r=request, f='read'))
Jose
>
> Why bother the [x for x in ...] ? Just do
> requires = IS_IN_SET(range(1, 4))
You are right
Jose
On 15 mayo, 23:15, mdipierro wrote:
> In the second case, does the list of fields include db.table.id?
Yes, of course, in fact shows the id field, but without link.
fields = my_table.fields
rows = crud.select(my_table, query=query, fields=fields, ...,
linkto=URL(r=request, f='read'))
Jose
On 16 mayo, 11:48, Jose wrote:
> On 15 mayo, 23:15, mdipierro wrote:
>
> > In the second case, does the list of fields include db.table.id?
>
I understand, the fields list should be table.field instead of using
only field
Jose
On 18 mayo, 06:59, Andrew Buchan wrote:
> Hello,
>
> Very simple one today:
>
> SQLFORM(db.CAR_Report, record = CARId , readonly = True, fields =
> ['Part_Number'])
>
> gives me a form showing:
>
> Id: 1
> Part Number: U5118
>
> Thing is, I don't want the user to
= DAL ("mssql ://..., db_codec = 'latin1')
As I said in another thread with the parameter db_codec = 'latin1' I
can see the contents of the database correctly.
The problem I have is when I write, it seems not to respect the
db_codec latin1 and use another.
How do I fix this problem?
Jose
e/web2py/gluon/contrib/gateways/fcgi.py", line 552, in
write
self._sendall(sock, header)
File "/usr/home/web2py/gluon/contrib/gateways/fcgi.py", line 529, in
_sendall
sent = sock.send(data)
socket.error: [Errno 32] Broken pipe
How to solve this?
Jose
>
> There is not much that we can do. The web server logs it. Probably
> web2py logs it too.
I have to enable log in fcgihandler.py. I'm going to do and see shows.
Jose
) Save the state of the object in the database. I do not like.
4) ¿?
How do you see this approach?
What other alternative can be proposed?
Regards
Jose
utes_value(),expiration_time)
>
> If the data is per user you can store it in session but you need to
> pickle/unpickle it yourself.
>
Thank you very much, it worked well.
I had thought of cache, but I thought it was only for functions and
selec.
Jose
As I mentioned, with the object caching works well.
When I create the object you pass as argument the db. The problem I
have is that when I save something in the database fails me because
the base is closed.
...
File "/usr/home/jose/web2py/applications/py_ccu/modules/
incidencias.py"
On 9 jun, 17:38, Jose wrote:
> As I mentioned, with the object caching works well.
> When I create the object you pass as argument the db. The problem I
> have is that when I save something in the database fails me because
> the base is closed.
>
> ...
> File "/usr/hom
:
form=crud.create(db.TB)
error:
Traceback (most recent call last):
File "/usr/home/jose/web2py/gluon/restricted.py", line 178, in
restricted
exec ccode in environment
File "/usr/home/jose/web2py/applications/py_ccu/controllers/
appadmin.py", line 410, in
I am working with a legacy database and am using many views, so as to
bridging differences with tables. All the views will create a numeric
id field for compatibility, but not in use.
Jose
On 15 jun, 05:12, Sky wrote:
> Thank you Jose,
> but I couldn't find out if you used define_table or not?
> can you drop me a piece of your code?
> i get 'invalid query' error when i query on my views.
>
They are declared in the same way that a real table. Then yo
Hi,
How can I change the encoding of the files edited with the editor's
own web2py?
Rgards,
Jose
On 24 jun, 13:27, mdipierro wrote:
> I do not know if that is possible
>
I need to save files to latin1 instead of utf8 (apparently default). I
know I can use iconv, but it gets annoying having to do so.
Regards
Jose
thank Mr.netadmin,
I use FreeBSD and my shell is csh.
% Echo $ LANG
es_ES.ISO8859-1
ISO8859-1 is Latin1, but coding of files created corresponds to utf-8.
Jose
On 25 jun, 18:24, NetAdmin wrote:
> OK,
>
> I use Linux and vi
> Here are my settings
>
> scroll=11 ttyfast
> fileencoding=utf-8
> fileencodings=ucs-bom,utf-8,default,latin1
> runtimepath=~/.vim,/var/lib/vim/addons,/usr/share/vim/vimfiles,/usr/
> share/vim/
> vim71,/usr/share/v
I have the following code:
if form.accepts(request.vars, session):
response.flash = int(form.vars.id)
#id = int(form.vars.id)
#doc = tb_documentos[id]
#doc.update_record(estado=1)
#redirect(url_expediente)
elif form.errors:
..
The id returned in the testing are:
263226
263228
263230
263232
263234
...
It is seen that increase in twos. If I go from the admin, the IDs are
correct.
Jose
h = type(form.vars.id)
return
The only change made to the table that gives the problem is that it
triggers have been defined, but this should not affect anything.
Anyway I will check with the administrator.
Jose
e this [1] and [2]. Web2py use "SELECT @@IDENTITY;" to get
the id.
In my case, the trigger does not do an insert into another table, but
it makes an update in another table. Then the problem that is
mentioned in the links that showed not apply.
Jose
[1] http://msdn.microsoft.c
On 27 jun, 12:51, mdipierro wrote:
> should we consider this a bug and use
>
> SELECT SCOPE_INDETITY()
>
> ?
I do not know MSSQLServer, especially regarding the different
versions. Here [1] there is another alternative: SELECT IDENT_CURRENT
('tablename');.
Someone who knows more about you can
Replacing this:
self._db._execute('SELECT @@IDENTITY;')
whit:
self._db._execute("SELECT IDENT_CURRENT('%s');"%self._tablename)
for me it worked in a SQLServer 2000 server I do not know for other
versions of SQLServer.
With SELECT SCOPE_IDENTITY() there was an error because it was not
recognized
On 27 jun, 16:29, mdipierro wrote:
> Anybody opposed to this change?
>
> Massimo
>
Me I correct myself, I said before that SCOPE_IDENTITY () not working,
but I had a typo.
I think SCOPE_IDENTITY () is the right choice, because IDENT_CURRENT
is out of session.
SCOPE_IDENTITY () works correctly.
The code should look like:
self._db._execute('SELECT SCOPE_IDENTITY();')
Jose
and retrieves the
ID, someone inserts another record, the ID obtained will be incorrect.
I know that the probability is very small, but it can happen.
For example:
Postgres use: "select currval ('tablename_id_Seq')"
similarly the other engines.
Jose
On 30 jun, 14:04, mdipierro wrote:
> If that can happen, than it is wrong. My understainding is that
> because we are in a transaction, before the insert is committed we get
> the id of the last record.
>
Okay, but "I believe" that everything about AUTO_INCREMENT fields are
out of the transacti
I have problems with local_import in the latest version of the trunk.
Jose
Sorry, I did not put what the problem. I saw in the log of changes
that had something new with Imports and thought I had to do with it.
The problem is that no matter the form directly. This started to
happen with the changes to the trunk between yesterday and today.
Jose
r: 'module' object has no attribute 'MyClass'
You understand?
This worked well until yesterday, after upgrading from the trunk,
started the error.
Jose
Now works!
Thanks
On 3 jul, 08:05, Iceberg wrote:
> Sorry gentlemen, I don't get it.
>
> First of all, the new implementation, even with the latest bugfix,
> does not use the "force" parameter at all, neither python reload(). I
> reckon that Jose did not test the reload fea
?
Should I run faster?
Jose
I comment if I have a problem. The first impression after the change,
was running faster.
Jose
unixODBC-2.3.0
* py26-pyodbc-2.1.5
Web2py: Version 1.79.2 (2010-06-08 22:45:26)
Regards
Jose
ldos.modules.reportes
The trunk version works well with both Cherokee and the server itself.
Regards
Jose
Please look at the thread [1] showing the error.
[1] http://groups.google.com/group/web2py/t/74578224649d6804
Jose
On 12 jul, 16:32, mdipierro wrote:
> 1.80.1 is supposed to be identical to trunk. (!?)
>
> Do you have this file: applications/sueldos/modules/reportes.py
>
No, the error does not occur due to missing module.
Now I know how to avoid it, but do not know why it happens.
The steps are:
1) Downloa
The following was taken from [1].
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
- - - - - - - - - - - - - - - - - - - - - -
Web2Py
web2py does not work well on multiple application environment so you
have to use it as the only WSGI application of the uWSGI server.
Use thi
{{=r.id}} | {{=r.nombre}} {{=A('[editar]',
_href=URL(r=request, f='editararchivo', args=[r.id]))}}
{{pass}}
When I edit a record I get the following error:
Traceback (most recent call last):
File "/usr/home/jose/web2py/gluon/restricted.py", line 178, in
restri
uest.vars, session):
id = form.vars.id
Jose
Ok, now work well.
Jose
When I use auth.define_tables(username=True) fails
Traceback (most recent call last):
File "/usr/home/jose/web2py/gluon/restricted.py", line 178, in
restricted
exec ccode in environment
File "/usr/home/jose/web2py/applications/csr/models/db.py", line 30,
in
The error I mentioned in my first post still appears.
Traceback (most recent call last):
File "/usr/home/jose/web2py/gluon/restricted.py", line 178, in
restricted
exec ccode in environment
File "/usr/home/jose/web2py/applications/csr/models/db.py", line 31,
in
On 24 jul, 19:01, weheh wrote:
> I have a list, x, with allowed values for field table.x. Is there a
> succinct way to do something like this?
>
> db(db.table.x in x).select()
Hi,
You must use the operator Belongs. Please see here [1]
Regards
Jose
[1] http://www.web2py.com/
Massimo,
After updating the following error occurs:
File "/usr/home/jose/w2p/gluon/tools.py", line 2970
elif dt.days > 21:
^
SyntaxError: invalid syntax
Jose
--
You received this message because you are subscribed to the Google Groups
"web2py-users" group
On 16 feb, 01:20, Jose wrote:
> Massimo,
>
> After updating the following error occurs:
>
> File "/usr/home/jose/w2p/gluon/tools.py", line 2970
> elif dt.days > 21:
> ^
> SyntaxError: invalid syntax
>
> Jose
Missing parenthesis in T(&#
misinterpretation.
[1] http://web2py.com/book/default/section/6/4
Jose
--
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group, send email to
web2p
how to this [1] with webpy?
[1] http://www.vimeo.com/9526668
--
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group, send email to
web2py+unsubscr...@googleg
Thank Massimo,
when inserted in company works well, but not in person.
Jose
--
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group, send email
On 20 feb, 14:54, mdipierro wrote:
> What behavior do you see? Can I see the model?
>
The behavior after the submit is normal, but when I go to see the
table person are not records.
Tested on FreeBSD and Windows
The code corresponds to the last posted by you [1]
[1] http://www.pastebin.com/m
On 20 feb, 16:25, mdipierro wrote:
> which version of web2py?
>
In windows the latest binary. In FreeBSD, the trunc version (1 hour
ago)
--
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to web...@googlegroups
On 20 feb, 17:01, mdipierro wrote:
> If I understand what you tell me.
> You click on create and get the modal
> add a new organization
> submit it (does the modal close?)
> go back to person form
> there is nothing in the dropdown.
No. I added the company, after you submit, it closes the modal
On 20 feb, 17:49, mdipierro wrote:
> I am not sure what you refer to is a bug. I think that is the
> workflow. Every time you submit the form you get a new empty form.
>
> Make sure the table definitions are models not controller and use
> appadmin to see if the records are in the table. They sh
#def ajax_create
and
#db.person.organization.comment = ajax_create(db.person.organization,
title='Add an Org.')
and now I could add the record.
Jose
--
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to web...@g
played
correctly, but when you click again not hide.
Any idea what is wrong.
Jose
--
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group, send email
On 26 feb, 18:50, Thadeus Burgess wrote:
> try it in firebug.
>
It works. There was an error, apparently some browsers allow.
I changed it:
[Marcas]
for this:
{{div_id='marcas%d'%r.id}}
{{div_id2='#%s'%div_id}}
[Marcas]
Jose
--
You received this message bec
On 1 mar, 18:28, mdipierro wrote:
> zencoding is now in trunk.
>
Ctrl + s not working It's going to save the page.
Jose
--
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to web...
in line 1033 and 1227
captcha = self.settings.register_captcha or self.settings.captcha
Jose
--
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this g
l
> DROP col instead of ALTER TABLE tbl DROP COLUMN col
this worked well. Perhaps in an update error was introduced.
Jose
--
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
On 6 mar, 15:36, salbefe wrote:
> I'm using the latest version from mercurial repository.
>
I sent a patch to Massimo.
Jose
--
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to web...
2 2010] [error] WARNING:root:unable to import
Rocket
[Fri Mar 12 15:25:25 2010] [error] WARNING:root:unable to import
Rocket
Jose
--
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to web...@googlegroups.c
On 12 mar, 21:48, Timothy Farrell wrote:
> I'm not sure how you upgraded, but make sure you have a rocket.py in
> your gluon folder.
>
$ hg pull
$ hg update
--
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to
aster[1]
>>> a
at 0x37f8fc34>, 'name': 'A',
'id': 1, 'delete_record': at 0x37f8f80c>, 'detail':
}>
>>> b = a.detail
>>> b.select()
Traceback (most recent call last):
File "", line 1, in
F
On 13 mar, 16:42, mdipierro wrote:
> This should work in the normal console but it is a known problem in
> the web based shell. There is some timeout issue that closes the DB. I
> will investigate more.
Ok, thank.
Jose
--
You received this message because you are subscribed to t
SO Freebsd.
In opera works fine, but in firefox fails, try to save the page as
html
Jose
--
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group,
D&q=http://groups.google.com/group/web2py/browse_thread/thread/d59ee3d6c2e6d836&usg=AFQjCNFpArFjqca6GqxppSFICblEp7hwGg
Jose
--
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To u
On 17 mar, 23:25, Thadeus Burgess wrote:
> http://thadeusb.com/weblog/view/web2py_virtualfields_as_an_orm_an_sql...
>
> -Thadeus
Thank Thadeus, excellent.
Jose
--
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post
tal(self):
return self.item_total * self.tax_percentage
def tax(self):
return self.total() - self.item_total
db.sales.virtualfields.append(Sales())
in contrrolers/default.py
def sales():
rows = db(db.sales.id>0).select()
return dict(rows=rows)
when accessing sales
Traceback
On 17 mar, 23:54, Jose wrote:
> Fails,
>
> in model/db.py
>
> db.define_table('sales',
> Field('item'),
> Field('item_total', 'double'),
> Field('tax_percentage', 'double'),
> Field(&#
ales())
works well, but what I meant is that you must write the name of the
table:
return self.sales.item_total *
self.sales.tax_percentage
if not set, the same error occurs
Jose
--
You received this message because you are subscribed to the Google Groups
"web2py-users&quo
(url='http://www.google.com')}}
I will not display anything. With other applications web2py works
fine.
Jose
[1] http://gluonframework.wordpress.com/2010/03/07/web2py-ajax-and-forms/
--
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To
On 22 mar, 17:56, mdipierro wrote:
> You can LOAD(url='anything') but anything must return a component, not
> entire page with ... How the browsers response to an
> inside another is unpredictable.
Ok, thank.
--
You received this message because you are subscribed to the Google Groups
"web
ords (idem for the 3 forms).
Where that leaves only one form, insert the record, but not upload the
file, only saves the field nombre
Jose
--
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to web...@
a bit, just wanted to see if they could.
Anyway, with a single form that does not work, do not upload file:
Form 1
{{=LOAD('default', 'form_doc', ajax=True, ajax_trap=True)}}
Jose
--
You received this message because you are subscribed to the Google Groups
"web2py-user
On 24 mar, 20:17, mdipierro wrote:
> That is a bug. The problem is that it is not technically a web2py bug
> but a limitation of jquery.submit. I think there is a jquery plugin to
> extend the jquery.submit functionality to multipart forms. If you find
> it and try it, let us know.
Maybe this [
maybe this is causing problems when the parameter deletable=True
Error:
File "/usr/home/jose/w2p/gluon/sqlhtml.py", line 748, in __init__
col3.get(self.FIELDKEY_DELETE_RECORD, ''))
TypeError: append() takes exactly one argument (3 given
someone could review
Jose
-
I sent a patch to Massimo
--
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com.
For more options, visit t
1]
qry1 = (db.t2.f22.f12 == 10)
rows = db(qry1).select(db.t2.ALL)
How would be the simplest way to query?
Jose
--
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscri
Yes, that's what I did, I used left join. This is what we would use
them if the query would have made with pure sql.
Knowing that I can do the following:
row = db.t2[n]
print row.f22.f11
print row.f22.f12
DAL thought would solve the query in the same way.
Thank you.
Jose
--
You recei
> is same problem from other people?
It works well for me, tested in Opera, Firefox and Konqueror.
Jose
--
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscr
.
File "/usr/home/jose/w2p/gluon/sql.py", line 1067, in
self._execute = lambda *a, **b: self._cursor.execute(*a, **b)
ProgrammingError: (-104, 'isc_dsql_prepare: \n Dynamic SQL Error\n
SQL error code = -104\n Token unknown - line 1, column 258\n )')
Before the upgrade
ues=keepvalues):
Jose
--
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com.
For more options, vis
On 5 abr, 17:59, mdipierro wrote:
> One more try please.
Now, it works well!
Thank you.
--
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group, send email
Hi,
For a presentation of web2py talk I've suggested them to include a
comparison with other technologies and highlight the advantages over
technologies such as asp.net. and PHP.
Please could you help me with this.
Thanks
Jose
--
To unsubscribe, reply using "remove me" as the subject.
y
> mengu
Where can I see some of what you've done?
Jose
--
Subscription settings: http://groups.google.com/group/web2py/subscribe?hl=en
Hi,
there any way to authenticate against the users defined at the server
database?
That is, pass user and password in db = DAL (...)
Regards,
Jose
--
Subscription settings: http://groups.google.com/group/web2py/subscribe?hl=en
On 22 abr, 13:06, mdipierro wrote:
> db = DAL('postgres://username:passw...@hostname:port/dbname')
I meant to enter user and password from a form
Jose
--
Subscription settings: http://groups.google.com/group/web2py/subscribe?hl=en
as validated when there is a
database server with registered users at the server level (not at the
table as is the case auth_user), and are already assigned permissions
to tables, views, processes, etc in the database.
Jose
--
Subscription settings: http://groups.google.com/group/web2py/subscribe?hl=en
s, it may take several
minutes to several hours. Is correct to do this in the context of a
web application?
Regards,
Jose
it must be the user who launches the
process.
Running the script as you said, how to access the same to application
context: db, session, etc.
I use subprocess to run?
Jose
On 28 abr, 18:31, Jose wrote:
>
> Running the script as you said, how to access the same to application
> context: db, session, etc.
I said nothing, I just read the output of python web2py.py -h
Jose
on %s/web2py.py -S py_ccu -M -R %s"%(os.getcwd(),
script)
subprocess.Popen(comando, shell=True)
redirect(URL(r=request, f='a_function'))
As always, excellent web2py
Jose
One more question.
The model is imported with-M, but I do not know is how to pass session
to the script.
Jose
On 28 abr, 20:39, Jose wrote:
> One more question.
>
> The model is imported with-M, but I do not know is how to pass session
> to the script.
>
> Jose
I answer myself. I used pickle.
Jose
, session):
category = form.vars.category
#code here
...
redirect(a_url)
elif form.errors:
response.flash = 'errors'
return dict(form=form)
Option 2
using onaccept: http://www.web2py.com/book/default/chapter/07
Jose
1 - 100 of 654 matches
Mail list logo
