hi
on win7 i have web2py in dropbox folder, so i can work on applications from
two computers (and to have a backup)
but now i'm getting this error quite often:
IOError: [Errno 22] invalid mode ('w') or filename:
'C:..\\Dropbox\\...\\databases\\c8b669d15150d7109e5f7_izobrazevanje.table'
Could
hi
i installed web2py with a script setup-web2py-ubuntu.sh on ubuntu (vps)
in the script, there is installation of reportlab
on windows machine i have put the reportlab in site-packages folder and i
have added some fonts
when i move my application to vps ubuntu server and doing
from reportlab.p
If I edit my template in a text editor then the £ sign shows up
normally. If I edit my template in microsoft word and save as filtered
html (which gets rid of MS Office formatting) then it also shows the £
normally if I open it directly in a browser. However when it is
returned from the web2py cont
I like both paper to read while enjoying my sofa/bed. and online to
find quickly the information when I need it ;)
On Wed, Jun 22, 2011 at 12:45 PM, Paul Gerrard
wrote:
> Call me old-fashioned, but I for one *prefer* the paper book to online
> 8O)
>
> Online is a good fall-back if I c
One solution is to have a variable called pound and put {{=pound}} in
the template.
However there has to be a better way!
On Jun 24, 9:31 am, apple wrote:
> If I edit my template in a text editor then the £ sign shows up
> normally. If I edit my template in microsoft word and save as filtered
>
Hi Massimo,
this is my *full*, unaltered startup log (web2py 1.96.4 running under
Jython 2.5.2):
No handlers could be found for logger "web2py.dal"
New installation: unable to create welcome.w2p fileweb2py Web
Framework
Created by Massimo Di Pierro, Copyright 2007-2011
Version 1.96.4 (2011-06-07
We have two tables:
db.define_table('t_company',
Field('f_name'))
db.define_table('t_person',
Field('f_company_id', db.t_company),
Field('f_name'))
crud.create(db.person) --> 'f_company_id' is re
I notice that group member Dwayne was offering a 'bounty' to the project for
information etc. I really like this idea and I wonder what others thought.
It provides an incentive to provide more functionality and gives people an
excuse to donate towards this wonderful framework and encourage Mass
Thanks. I am having a problem with response.render. Followed example
in the book but the controller below shows test.html but
response.render returns the generic view. Am I missing something?
def test():
customer = db.customer[1]
html = response.render('test.html', dict(customer=customer))
I tried making a dict
user_info = {'username':'Username','password':'Password'}
billing_info =
{'field_name':'Label','street':'Street','city':'City','state':'State',etc..}
when I display it seems the dict does not keep the order?
So when I display billing it shows some random order like state,
I think the problem is with your choice of editor. All of these entities
appear to work for me:
£ £ £ £
Codes are in github: https://github.com/szimszon/Temporary-storage
As suggested by the community, I am trying to export json data to
dataTable.
But only blank dataTable is rendered (with desired formatting, search
box, etc.)
Pl. introspect into my code as to where I have a mistake.
Data is not displayed (as returned by "get_data" method).
I have made sure that the
Hurrah! I have the answer.
In Microsoft Word 2010 go to File/Options/Advancedscroll to bottom
and choose web options/encoding. Then select to save document in
unicode (UTF8) format; and tick the box saying always save in the
default encoding.
On Jun 24, 12:41 pm, villas wrote:
> I think the
Hi,
I am now reading some documnentation about web2py.
Does web2py support postgresql schemas ?
I have my tables grouped in postgresql into scheme inside same
database.
So I can have same tables into the same databases but in different
schemas.
Like
schema1.mytable
schema2.mytable
How can I wor
what you really need to do?, create an app Web2py from your tables?
Ovidio Marinho Falcao Neto
ovidio...@gmail.com
88269088
Paraiba-Brasil
2011/6/24 Camil Ghircoias
> Hi,
>
> I am now reading some documnentation about web2py.
>
Python dictionaries do not preserve order. In Python 2.7, you can use an
ordered dictionary:
http://docs.python.org/dev/library/collections.html#collections.OrderedDict.
Anyway, if you're using SQLFORM, you can use the 'fields' argument to
provide a list of fields to be included in the form --
It's in version 1.93.2 as far as I can tell...
You can simply check in your version by passing a named parameter
(linkColumns = xyz..) to SQLTABLE and seeing if it works, like so:
def ManageUserProfiles():
response.view = 'shared/allpurpose.html'
response.title = 'Timesheets - manage user
I have a large erp application on windows forms that access postgresql
tables.
I am searching for tools to migrate the app from deskop to web app.
Didn't find something that satisfied me.
I like python as it is dynamic and clear syntax (comming from visual
foxpro environment I am know to appreciat
Is test.html inside /views/default/? In that case, you need to do
response.render('default/test.html',...) -- otherwise, if response.render
can't find the view, I think it will just revert to the generic view.
Anthony
On Friday, June 24, 2011 7:35:25 AM UTC-4, apple wrote:
> Thanks. I am havi
Thanks. I had incorrectly assumed it treated the views/controller
directory as the current one.
On Jun 24, 3:50 pm, Anthony wrote:
> Is test.html inside /views/default/? In that case, you need to do
> response.render('default/test.html',...) -- otherwise, if response.render
> can't find the view,
dear all,
I've added a unique field to some existing tables and w2p gave me an
error saing that he cannot add unique fields to a table so I deleted my
db and restarted as a new application but I obtained this:
ProgrammingError: Cannot operate on a closed database.
it's sufficient to comment o
On Friday, June 24, 2011 11:29:20 AM UTC-4, apple wrote:
>
> Thanks. I had incorrectly assumed it treated the views/controller
> directory as the current one.
By default, if no view is specified, it will look for
/views/current_controller/current_function.html and use generic.html if it
can'
Hello,
Together with others tables I have this in my db.py file:
...
db.define_table('fab_lote',
Field('fabricacion', db.fabricacion),
Field('lote', db.lote),
Field('cantidad_orden', 'double'),
Field('cantidad_gastado', 'double'),
Field('coste_unitario', 'double'))
whe
On 24/06/2011 09:22, andrej burja wrote:
hi
on win7 i have web2py in dropbox folder, so i can work on applications
from two computers (and to have a backup)
I'm doing the same with no trouble... but I never started at the same
time from two computers my web2py
Manuele
but now i'm
That is not the case with response.render. By default if you just
specify the filename then it looks first in views not in views/
controller.
On Jun 24, 4:33 pm, Anthony wrote:
> On Friday, June 24, 2011 11:29:20 AM UTC-4, apple wrote:
>
> > Thanks. I had incorrectly assumed it treated the views/
I would have great difficulty recommending Word as an editor for working
with HTML because of all the things it does under the covers. Not trying to
stir up flames, just trying to make your life easier. As a word processor
Word is okay.
Well put, ron_m. I would have no difficulty recommending against using Word
to edit HTML. It's just not the right tool...at all. There are so many good
free/low-cost options on all platforms that using Word makes little sense.
I customize all my forms (http://pricetack.com) so I can do exactly what I
want and it's pretty easy to manage:
http://web2py.com/book/default/chapter/07#Custom-forms
I would not use it for working with HTML normally. However if you have
something like a mailing letter or an invoice then you might want
someone to edit that who has no knowledge of HTML. They can use
tables, outlining and other formatting features of MS Office which
they know; and then load it up
pbreit;
Thanks,
I tried customizing the forms;
I got confused about; can you show me an example view?
On 6/24/11 12:41 PM, pbreit wrote:
I customize all my forms ( http://pricetack.com) so I can do exactly
what I want and it's pretty easy to manage:
http://web2py.com/book/default/chapter/0
For a financial bounty, I think the projects needs to be relatively more
substantial and Odesk works fine for that.
For smaller needs, a karma bounty might be sufficient in which case Stack
Exchange works OK.
But I'm not sure compensation is the best approach in the forums.
Emphasizing brevity and aesthetics.
http://www.bigjason.com/blog/announcing-datatree/
Hi web2py users,
I'm using Janrain for login. What's the best way to have a proper
redirect after login? I would like to redirect to be the location
visited before the login page.
When a non logged in user attempts to access a page that requires
login, they are redirected to the login page, and
On Friday, June 24, 2011 12:13:25 PM UTC-4, apple wrote:
>
> That is not the case with response.render. By default if you just
> specify the filename then it looks first in views not in views/
> controller.
Right, I think you misunderstood what I wrote -- by default *if you don't
specify any
I've been happy with lxml.builder which would look something like this:
from lxml.builder import E
doc = (
E.author(
E.name('Terry Pratchett'),
E.genre('Fantasy/Comedy'),
E.novels(
E.novel('Small Gods', year="1992"),
E.novel('The Fifth Elephant',
Is this is a sqlite or other?
On Jun 24, 10:31 am, Manuele Pesenti
wrote:
> dear all,
> I've added a unique field to some existing tables and w2p gave me an
> error saing that he cannot add unique fields to a table so I deleted my
> db and restarted as a new application but I obtained this:
>
> P
auth.settings.login_next=URL(...) should work
On Jun 24, 12:06 pm, Chris Baron wrote:
> Hi web2py users,
>
> I'm using Janrain for login. What's the best way to have a proper
> redirect after login? I would like to redirect to be the location
> visited before the login page.
>
> When a non logg
On 24/06/2011 20:13, Massimo Di Pierro wrote:
Is this is a sqlite or other?
yes, it was sqlite. At the moment I solved using postgres witrh
pool_size=100 but I didn't try if this parameter is really necessary.
what's the difference between the two db in this case??
Manuele
2011/6/23 Richard
> Hi Pierre,
>
Hi Richard,
>
> thanks for replying. I remember that I already stumbled upon the blog
> page you mention before I posted my question on this list. I admit
> that I didn't read it in depth back then. But I took as a good sign
> that you wrote in your final line:
I don't think SQLite does pools. SQLite DBs are easy to deal with...just
delete everything in the "databases" directory and start over. Might want to
double-check that your connection string is pointing to the right place.
When you deleted the db, did you also delete the associated .table
files? You should have
On Jun 24, 10:31 am, Manuele Pesenti
wrote:
> dear all,
> I've added a unique field to some existing tables and w2p gave me an
> error saing that he cannot add unique fields to a table so I deleted my
> db a
On 24/06/2011 20:40, Massimo Di Pierro wrote:
When you deleted the db, did you also delete the associated .table
files? You should have
everything in the databases directory...
Manuele
I do not know. This is odd. Can you send me your app (confidentally)?
On Jun 24, 1:50 pm, Manuele Pesenti wrote:
> On 24/06/2011 20:40, Massimo Di Pierro wrote:
>
> > When you deleted the db, did you also delete the associated .table
> > files? You should have
>
> everything in the databases dire
2011/6/23 Anthony
> Actually, even easier, you can just do mytag['_attr'] and mytag[0].
>
> On Thursday, June 23, 2011 6:21:37 PM UTC-4, Anthony wrote:
>
>> >>> mytag=TAG.element('xyz', _attr='value')
>> >>> print mytag.attributes['_attr']
>> value
>> >>> print mytag.components[0]
>> xyz
>>
>> An
I am trying to display chat message information;
I have 2 tables
The first table is the auth table define in web2py
The second is this
db.define_table('messages',
Field('from',db.auth_user),
Field('to',db.auth_user),
Field('msg','string'),
Field('ts','datetime',default=request.
I am guessing, I have not tried it
mfrom = db.messages.with_alias('mfrom')
mto = db.messages.with_alias('mfrom')
db(db.auth_user).select(db.auth.user.first_name,
db.auth_user.last_name,
mfrom.id.count(), mto.id.count(),
left=[mfrom.on(mfrom.from==db.auth_user.id),mto.on(mto.to==db.auth_use
Thanks I will try now.
On 6/24/11 3:27 PM, Massimo Di Pierro wrote:
I am guessing, I have not tried it
mfrom = db.messages.with_alias('mfrom')
mto = db.messages.with_alias('mfrom')
db(db.auth_user).select(db.auth.user.first_name,
db.auth_user.last_name,
mfrom.id.count(), mto.id.count(),
2011/6/24 szimszon
> Codes are in github: https://github.com/szimszon/Temporary-storage
>
great work, you really should put a license statement. check [this] for some
info about free software licenses _that worry about 'copyleft'_: [
http://www.gnu.org/licenses/].
regards
Massimo;
Thanks, this sort of works; The numbers seem off but this gives a good
starting point;
One other thing I would like to extend the table to include on other
field 'mtype'
which would be a value of 'text' or 'media',
If I wanted to extend the query to use the previous query and the
Hi All,
how can I do something like this:
def update_my_field(tablename, columnname, id,value):
db.tablename(id).update_record(columnname=value)
update_my_field("my_table","my_column","123","hello world")
thanks
--
Sebastian E. Ovide
def update_my_field(tablename, columnname, id,value):
db(db[tablename].id==id).update(**{columnname:value})
update_my_field("my_table","my_column","123","hello world")
On Jun 24, 3:08 pm, "Sebastian E. Ovide"
wrote:
> Hi All,
>
> how can I do something like this:
>
> def update_my_field(tabl
You can replace
mfrom.on(mfrom.from==db.auth_user.id)
with
mfrom.on((mfrom.from==db.auth_user.id)&(mfrom.type=='text'))
and the same with the mto.
On Jun 24, 3:06 pm, "David J." wrote:
> Massimo;
>
> Thanks, this sort of works; The numbers seem off but this gives a good
> starting point;
>
>
Got it thanks
I think I tried but perhaps I did not use the right syntax
I think I tried
(mfrom.from==db.auth_user.id& mfrom.type=='text')
But I think it has to be logically separate
(mfrom.from==db.auth_user.id)&(mfrom.type=='text')
On 6/24/11 4:28 PM, Massimo Di Pierro wrote:
You can
Today I had a similar problem and Carlos Costa sent me a script for it and
it worked well here
http://groups.google.com/group/web2py/browse_thread/thread/eef02b6d3ca0741b?pli=1
here worked well, so you need to put the output to egex.: python
extract_pgsql_models.py mydb localhost 5432 reingart S
Hi,
I'm parsing an XML with TAG helper, but web2py breaks when an [CDATA]
appears. Can the TAG helper bypass this?
kind regards
I do not understand it, but it works ! (in the book says to do not confuse
update with update_record because for a single row, the method update updates
the row object but not the database record, as in the case of update_record)
Thanks !
On Fri, Jun 24, 2011 at 9:24 PM, Massimo Di Pierro <
mass
Note, Massimo used db(db[tablename].id==id), which is a Set object (not a
Row object), so the update method is appropriate.
On Friday, June 24, 2011 5:25:20 PM UTC-4, sebastian wrote:
> I do not understand it, but it works ! (in the book says to do not confuse
> update with update_record becau
2011/6/24 danto
> Hi,
> I'm parsing an XML with TAG helper, but web2py breaks when an [CDATA]
> appears. Can the TAG helper bypass this?
>
> kind regards
>
ahem... well, Iol, a string.replace('
UNfortunately lots of things break TAG parning because it is based on
python HTMLparser
On Jun 24, 4:40 pm, danto wrote:
> 2011/6/24 danto
>
> > Hi,
> > I'm parsing an XML with TAG helper, but web2py breaks when an [CDATA]
> > appears. Can the TAG helper bypass this?
>
> > kind regards
>
> ahem.
I should have added a return
def update_my_field(tablename, columnname, id,value):
return db(db[tablename].id==id).update(**{columnname:value})
and I did it because this fails more gracefully if the id is not found
(returns 0).
On Jun 24, 4:35 pm, Anthony wrote:
> Note, Massimo used db(db[t
Thanks for the information.
I will look at this again when I get a chance...
Joe
On Tue, Jun 21, 2011 at 5:25 AM, David Watson wrote:
> Hi Joe,
>
> That report is generated because the types dictionary for that key
> doesn't have a value that encodes a template for the field.length to
> be writ
Hi,
let's say I have a simple form like the following:
def one():
form = FORM(_name='n')
if form.accepts(request.vars, session):
# do something
redirect(URL('two'))
else:
*# what I want to do is something like*
*form.vars.n = 'MY DYNAMIC VALUE'*
return dict(form=form)
Regards, Martin
Hello everyone.
Could you tell me how to round the number of seconds which
'request.now' represents like this
'2011-06-25 15:26:55.881000' => '2011-06-25 15:26:55' or
'2011-06-25 15:26:56'
thank you
dorasan
Im sorry. I missed the tag '[web2py]'
-- Forwarded message --
From: dorasan
Date: 2011/6/25
Subject: how to round the number of seconds
To: web2py-users
Hello everyone.
Could you tell me how to round the number of seconds which
'request.now' represents like this
'2011-06-25 1
65 matches
Mail list logo
