I've also tried commenting the lines
if charset != 'None':
self._execute('SET NAMES %s;' % charset)
in sql.py but then I got this error message:
Traceback (most recent call last):
File "/var/www/alvinru/data/www/bilingsoft.ru/gluon/restricted.py",
line 107, in restricted
exec ccode in
I am working on a view which will display a timetable. So far, this is
what I have got:
day
time
program
level
location
{{for program in timetable:}}
{{=program.day}}
{{=program.time}}
I downloaded the latest version. Now the error message is:
Traceback (most recent call last):
File "", line 1, in
File "gluon/sql.py", line 1034, in import_from_csv_file
ValueError: Mixing iteration and read methods would lose data
--~--~-~--~~~---~--~~
You re
Now I receive an error message that says:
"'isc_attach_database: I/O error for file "employee.fdb?set_encoding=None"
Error while trying to open file. No such file or directory'"
On Mon, Jun 22, 2009 at 1:18 PM, mdipierro wrote:
>
> Use this string instead. It seems some version is Firbird d
Ahh. Makes sense. Thanks.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to
web2p
You must have an old version of web2py. That error cannot come form
line 997.
Massimo
On Jun 21, 11:24 pm, weheh wrote:
> Massimo, I tried your migration suggestion but got an error message on
> reading the 'somefile.csv' file:
>
> Traceback (most recent call last):
> File "", line 1, in
>
It is quote old and primitive. You just select the colors, the fonts
etc. and then there is a "click here" to download the "layout.html" to
replace the default one.
Massimo
On Jun 21, 10:32 pm, Joe Barnhart wrote:
> Interesting site. It would be helpful to describe your service more
> complet
Use this string instead. It seems some version is Firbird do not like
setting the default encoding to UTF8.
db = SQLDB('firebird://sysdba:passw...@localhost/employee.fd?
set_encoding=None')
On Jun 21, 9:54 pm, Alexei Vinidiktov
wrote:
> Hello,
>
> I'm trying to make a connection to a Firebird
How would it be different from?
{{=XML(filelikeobject.read())}}
Massimo
On Jun 21, 8:07 pm, DenesL wrote:
> Massimo,
>
> what do you think of allowing file-like objects (stringio et al.) to
> be used in includes?.
--~--~-~--~~~---~--~~
You received this message
Massimo, I tried your migration suggestion but got an error message on
reading the 'somefile.csv' file:
Traceback (most recent call last):
File "", line 1, in
File "gluon/sql.py", line 997, in import_from_csv_file
ValueError: Mixing iteration and read methods would lose data
--~--~-~
ok ok I got da buukn = ok ok I got the book.
:) It's very nice.
On Sun, 2009-06-21 at 13:25 -0700, mdipierro wrote:
> ?
>
> On Jun 21, 1:38 pm, Jason Brower wrote:
> > I got it, and yeah, it's worth it.
> > If your having trouble, and need to do your thesis, don't do anything
> > until you get
>db.x.y_id.requires=IS_IN_SET(valid_y_ids)
IS_IN_SET takes a second parameter with the names you want to display
(or one parameter where the values and their displanames are provided
as a dictionary)
db.x.y_id.requires=IS_IN_SET(valid_y_ids, display_names)
On Mon, Jun 22, 2009 at 5:04 AM,
Interesting site. It would be helpful to describe your service more
completely. I don't really understand what you are offering by just
looking at the site.
On Jun 21, 3:40 pm, "nathan.ms" wrote:
> I just released my first web2py application. It connects writers with
> editors. The rates are
Consider this:
model:
db.define_table('x',db.Field('y_id',db.y,requires=IS_NULL_OR(IS_IN_DB
(db,'y.id','%(name)s'
db.define_table('y',db.Field('name','string',requires=[IS_NOT_EMPTY
(),IS_NOT_IN_DB(db,'y.name')]))
controller:
try:
records = db(db.x.id==int(request.args[1]))
valid_
Hello,
I'm trying to make a connection to a Firebird db file, but I keep
getting this error:
Traceback (most recent call last):
File "/var/www/alvinru/data/www/bilingsoft.ru/gluon/restricted.py",
line 98, in restricted
exec ccode in environment
File
"/var/www/alvinru/data/www/bilingsoft.ru/a
On Jun 21, 4:26 pm, mdipierro wrote:
> my guess is that currently do not change often so I would use cache
> the mapping:
>
> currencies=cache.ram('currencies',lambda: dict([(row.code,row.name)
> for row in db(db.currency.id>0).select()]), 5000)
> db.cache_account.currency.represent=lambda id: cu
Massimo,
what do you think of allowing file-like objects (stringio et al.) to
be used in includes?.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" group.
To post to this group, send email
> Can we get a discount on the updated Lulu version if we previously
> bought the original Lulu ebook version?
> A one-time deal, maybe??
+1!
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" gro
On Jun 21, 8:11 pm, Daniel Guryca wrote:
> Hey, I have just installed apache + web2py + mod_wsgi.
>
> Now results are very comparable to django results.
> Great !
that's a relief! I was getting a worried about web2py performance
after reading another thread on performance.
>
> I'm going to tes
http://www.appliedstacks.com/Popularity/
report your side to
http://www.appliedstacks.com/NewestFirst/web2py
Massimo
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" group.
To post to th
I think this is an excellent idea.
You may want to consider a better layout. you can generate one here
http://www.web2py.com/layouts
or use a free one for example:
http://www.freelayouts.com/templates/Paperova
Massimo
On Jun 21, 5:40 pm, "nathan.ms" wrote:
> I just released my first
I just released my first web2py application. It connects writers with
editors. The rates are very, very cheap for simple text correction.
http://morrisdecode.com
Please let me know what you think and what I can improve. Big thanks
to all the web2py coders here.
--~--~-~--~~--
Actually thought it was a though one to debug. I am sure it may have
helped other users as well.
Massimo
On Jun 21, 3:43 pm, matkolbe wrote:
> Hi Massimo,
>
> I'm that unbelievable stupied!!! It absolutely clearly described in
> your ebook... I've always skipped it, don't know why... ;o)
>
> Gr
You're the man.
On Jun 21, 4:27 pm, mdipierro wrote:
> You can customize the widget:
>
> db.table.field.widget=lambda a,b:StringWidget.widget
> (a,b,_class='yourclass')
>
> On Jun 21, 3:59 pm, "mr.freeze" wrote:
>
> > How can I append a class to one of the fields in a SQLFORM ? I would
> > pref
You can customize the widget:
db.table.field.widget=lambda a,b:StringWidget.widget
(a,b,_class='yourclass')
On Jun 21, 3:59 pm, "mr.freeze" wrote:
> How can I append a class to one of the fields in a SQLFORM ? I would
> prefer to do it when the form is generated and not with jQuery on
> docum
my guess is that currently do not change often so I would use cache
the mapping:
currencies=cache.ram('currencies',lambda: dict([(row.code,row.name)
for row in db(db.currency.id>0).select()]), 5000)
db.cache_account.currency.represent=lambda id: currencies[id]
Massimo
On Jun 21, 3:57 pm, "Franc
Thanks for your note...
Here is the code for uploading the image... I'm Using Python Version
2.5
@auth.requires_login()
def upload():
from gluon.sqlhtml import form_factory
albumNameList = [y.id for y in db(db.album.buacct_fk ==
session.auth.user.id).select(db.album.id)]
formPic = for
How can I append a class to one of the fields in a SQLFORM ? I would
prefer to do it when the form is generated and not with jQuery on
document.ready.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
"web2py Web Frame
I am trying to show the detail for a foreign key, but I really do not
know how to do it.
My model is:
db.define_table('currency',
SQLField('code',length=3),
SQLField('name',length=100))
db.currency.code.requires=[IS_NOT_EMPTY(),IS_NOT_IN_DB
(db,'currency.code')]
db
Hi Massimo,
I'm that unbelievable stupied!!! It absolutely clearly described in
your ebook... I've always skipped it, don't know why... ;o)
Greetings and thanks a lot!!!
matthew
On 21 Jun., 19:42, mdipierro wrote:
> Thanks for your comments.
>
> You can fix your problem by replacing:
>
> if
The requested session id is in request.sesssion_id and the response
session id is in response.session_id. The two should match if the
requested session is found.
Anyway, why don't you explain what you are trying to accomplish. I do
not see why one would ever need to access this.
Massimo
On Jun
Almost everything in T2 is now in web2py and much more powerful. T2 is
deprecated and will not be supported.
Massimo
On Jun 21, 2:55 pm, Robert Marklund wrote:
> I have read every where and on same places iread that the T2 plugin
> can/should be used and in some places that some of the function
?
On Jun 21, 1:38 pm, Jason Brower wrote:
> I got it, and yeah, it's worth it.
> If your having trouble, and need to do your thesis, don't do anything
> until you get this.
> It's too bad I couldn't get the newer version. ;) I wanted to have
> details about auth and other nifties.
> Thanks M.
>
Hi Kyo,
appadmin ignores db.table.field.readable and db.table.field.writable
but it always displays the id field.
I am not sure I understand what behavior you want to change.
Massimo
On Jun 21, 12:06 pm, __Kyo__ wrote:
> when I edit a table that has fields from other tables using appadmin,
> s
I just need the info how i can get the session ID from the session
object.
And then on the other page from the get-data set the session-id back
to the session, so its seams like that person is logged in.
Like this in poseido code:
@auth.requires_login()
def upload_image()
sessionid = session.
I have read every where and on same places iread that the T2 plugin
can/should be used and in some places that some of the functionality is
moved in to web2py itself.
So whats the status of it what should i use ?
/R
--
__
Robert Marklund
Phone: +46 (0
I got it, and yeah, it's worth it.
If your having trouble, and need to do your thesis, don't do anything
until you get this.
It's too bad I couldn't get the newer version. ;) I wanted to have
details about auth and other nifties.
Thanks M.
Regards,
Jason Brower
--~--~-~--~~
Extra special cool. I will have to try this.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, s
As promised:
Cookbook for how I installed a console-less-and-DOS-black-window-less
web2py service on a Windoze Server 2003, Standard Edition - Build
3790
(Service Pack 2).
Step One, change C:\web2py\options.py to:
import socket, os
ip = socket.gethostname()
port = 8000
password = '' ### mean
As promised:
Cookbook for how I installed a console-less-and-DOS-black-window-less
web2py service on a Windoze Server 2003, Standard Edition - Build 3790
(Service Pack 2).
Step One, change C:\web2py\options.py to:
import socket, os
ip = socket.gethostname()
port = 8000
password = '' ### means
when I edit a table that has fields from other tables using appadmin,
showed me the id (number) of the table, I would like to display the
field name and not the id. Can you do to show me the field name using
appadmin?. maybe work with a query as a table, becose I tried to
export a query as a table
Thanks for your comments.
You can fix your problem by replacing:
if inputform.accepts
(request.vars,session,formname='form_newflexiblecost'):
with
if inputform.accepts(request.vars,formname=None):
This is because web2py does some "magic" to prevent double form
submission and this is achie
auth_table must have a "email" and optionally a "username". If
username is present it will be used for login.
If your users do not have an email, then you do not need to fill the
field since only username will be used for login.
massimo
On Jun 21, 11:38 am, alain31 wrote:
> Hello, I'm new to we
Hi Denes,
Thanks for your reply.
> One way to obtain the desired result would be to write content.content
> out to an html file in the views folder and instead of:
> {{=XML(content.content)}}
> have :
> {{include 'content_file.html')}}
So, in the controller, instead of return dict(cont
Hi Massimo ,
first of all, I hated python, cause I was trying to totally reprogram
a webapp. Then a friedn of mine, Peter (writting an article bout
web2py), I think you also know him :o), told me about your framework -
and now I love python :o)
REALLY GREAT/BRILLIANT WORK!!!
Now to the problem:
Hello, I'm new to web2py (I know django) and I decided to give a try.
I bought the book, but I don't find detailled documentation about
auth. I want to create several apps (for a classroom organization)
sharing the same users, but with different profiles, for example
teachers, students, visitors..
How did you insert the images in the database? Which Python version
are you using?
It seems your fileupload field contains a serialized FieldStorage
object and not the web2py filename. This is very wrong.
The problem is not in the code you show but in the data you have in
db. Please show us more
I checked your form with this:
def insert_flexiblecost():
if inputform.accepts
(request.vars,session,formname='form_newflexiblecost'):
print 'done'
return dict(form=inputform)
and your form works great. he problem is somewhere else.
In particular I do not see in your code the pl
John,
Thanks for helping me solve the problem and giving the explanation for
its cause, I copied and paste it to my log. problem solved in both
Firefox and Safari.
> One of these days I will get around to loading Safari on Wine. But let
> me know if this works on Safari.
Your solutions works o
I am uploading a fix to this problem for authentication now. It will
be in trunk in a couple of minutes, please give it a try.
Massimo
On Jun 21, 9:39 am, Faye wrote:
> On Jun 20, 11:02 pm, mdipierro wrote:
>
> > "officially" we say we only support 2.5 because if people use 2.6 only
> > synta
yes you can migrate an entire database from the shell with one
command:
1) have a model that connects to the sqliite db
2) python web2py -S yourapp -M
3) in the shell type
db.export_to_csv_file(open('somefile.csv','wb'))
4) quit, edit the model to connect to the other db instead
5) python we
Hello Mate,
I seem to have a problem to upload Image file in the view... Here is
an example of how I implement it...
### In the Controller ##
def download():
import os
path=os.path.join(request.folder,'uploads',request.args[0])
return response.stream(path)
def index():
photoSet
I think the solution may be changing the OptionsWidget validator. I
will work on it. If you have any advice, let me know.
On Jun 21, 5:12 am, DenesL wrote:
> On Jun 20, 11:23 pm, mdipierro wrote:
>
> > The code you have below works fine. I guess the question is how to do
> > IS_IN_DB and IS_NOT
Thanks for letting us know. Please make sure the web2py app is
compiled (click [compile]). We desperately need independent comparison
banchmarks like yours. Please post some numbers when you can.
Massimo
On Jun 21, 5:11 am, Daniel Guryca wrote:
> Hey, I have just installed apache + web2py + mod
You only told us that your rails app provides basic auth and so I
indicated how you can used web2py to authenticate uses using Rails'
basic auth. This is tested and it works. It is not the most secure way
but it is the only way until we know more about the rails app.
Does the rails app exposes ot
http://127.0.0.1:8000/a1/default/_TEST
returns
ValueError: line 2 of the docstring for junk lacks blank after >>>:
'>>>junk()'
On Jun 21, 1:57 am, weheh wrote:
> Here it is again. The controller runs fine. The doctest does not.
>
> def junk():
> """
> >>>junk()
> 'hell
Nevermind, represent did the trick:
db.things.category.represent = lambda id: SPAN(db.categories[id].name)
On Jun 21, 10:33 am, "mr.freeze" wrote:
> When I change my SQLFORM for a table record to readonly, all of the
> IS_IN_DB relationships go back to their foreign keys instead of the
> values
Annet,
change this --
{{=A(event.event,_href="javascript:eventlistdetails('%s')"%URL
(r=request,f='eventdetails',args=[event.id]))}}
to this --
{{=A(event.event, _onmouseover="this.style.cursor='pointer';",
_onclick="javascript:eventlistdetails('%s')"%URL
(r=request,f='eventdetails',args=[even
When I change my SQLFORM for a table record to readonly, all of the
IS_IN_DB relationships go back to their foreign keys instead of the
values defined by the validator (for example: IS_IN_DB
(db,'categories.id','%(name)s')). What am I missing?
--~--~-~--~~~---~--~---
Hello there,
I have a problem, validating the form does not react.
The code in the controller inputform is defined global):
inputform=FORM(TABLE(TR(B(T('Date:')),INPUT
(_type="text",_name="new_date",_class="field-width-80 field-padding-
right-10",_id="new_datepicker_id",requires=[IS_NOT_EMPTY()
Me too! For the first time in two weeks!
On Jun 21, 8:20 am, Adon Metcalfe wrote:
> Also FYI for me its started working again =)
>
> On Sun, Jun 21, 2009 at 1:24 PM, mdipierro wrote:
>
> > good point. I will ask.
>
> > On Jun 21, 12:16 am, JohnMc wrote:
> > > Massimo,
>
> > > I notice in this
On Jun 20, 11:02 pm, mdipierro wrote:
> "officially" we say we only support 2.5 because if people use 2.6 only
> syntax they app will not work on 2.5. "technically" web2py runs on 2.6
> with only one known issue: The cgi module that parses form variables
> behaves differently in 2.5 and 2.6. If y
you always have to set a user in mysql: if you never set a user before
I suppose you always accessed as 'root' and a blank password but these
have yet to be present in the connection string (not a web2py issue
here).
carlo
On 21 Giu, 07:00, weheh wrote:
> I had to do some mucking around with se
maybe I am not fully up to date with the latest web2py releases so
chech this out:
db structure: if you have an existing mysql db with the same structure
as the sqlite db, it is just a matter of changing the connect string
in the model
db data: I think web2py does not care for migrating data fro
Hi Annet,
you can't have double nested template language code, which is the end
result of inserting a piece of a template in a view using template
language.
The template gets parsed into python code before it is executed, so:
{{=XML(content.content)}}
will insert the piece of the template as
here you can find some details about autoincrement in SQLIte:
http://www.sqlite.org/autoinc.html
as you can see ROWID is a 64 bit signed number and my conclusion is
you never should worry about the 'id gaps'.
carlo
On 21 Giu, 00:01, Fauché JM wrote:
> Annet ,has clearly explain the "problem".
Also FYI for me its started working again =)
On Sun, Jun 21, 2009 at 1:24 PM, mdipierro wrote:
>
> good point. I will ask.
>
> On Jun 21, 12:16 am, JohnMc wrote:
> > Massimo,
> >
> > I notice in this discussion that the dates that many of the failures
> > seem be to occuring on the weekends 7th
linkto in SQLTABLE is used for creating URLs to edit individual
records.
What you want is under "pagination" in the book.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" group.
To post to thi
On Jun 20, 11:23 pm, mdipierro wrote:
> The code you have below works fine. I guess the question is how to do
> IS_IN_DB and IS_NOT_IN_DB at the same time for the same field. Is that
> the question?
Yes, that is the question.
Sorry, it was not stated explicitly.
On Jun 21, 12:36 am, mdipierro
Hey, I have just installed apache + web2py + mod_wsgi.
Now results are very comparable to django results.
Great !
I'm going to test it a bit more.
Thanks
Daniel
On Sun, Jun 21, 2009 at 2:01 AM, AchipA wrote:
>
> You didn't say what web server you used for Django, whether you
> benchmarked com
Hurray :)
/R
On Jun 20, 3:13 am, mdipierro wrote:
> By the end of july there will be auto upgrade. ;-)
>
> On Jun 19, 6:43 pm, Eddie Eyles wrote:
>
> > I like the pace of new releases of web2py, but it is a pain to
> > download each one (the Windows distribution takes an hour on my
> > connect
Oups actually is a copy and paste... I don't have ":" after the
decorators...
I just sent you a zip file containing the controller and view...
Thanks for your help !
Yannick P.
On Jun 21, 12:19 am, mdipierro wrote:
> I see lots of errors in the first 4 lines:
>
> @auth.requires_login() :
> de
In my model I have:
db.define_table('utility',
db.Field('utility',label='Utility *
',length=12,default='',notnull=True,unique=True),
db.Field('content',type='text'),
migrate=False)
In a controller I have:
def privacy():
response.functionname=T('Privacy')
content=db(db.utili
I'm using the linkto field in SQLTABLE to create a hypertexted link to
a record in the db. Since there are many records, I need to paginate
the results. So I create a page_offset var that gets passed along.
Here's the SQLTABLE:
records = SQLTABLE(db().select(db.table.ALL),linkto=URL
(r=reque
All I can say about Rails app is that they are going to use "basic
authentication". I imagine there could be multiple ways to implement
an authentication scheme between web2py and ruby. My question is
whether there is one tested and secure way?
--~--~-~--~~~---~--~~
Now 100% certain about causing reserved keyword conflict with mysql.
Thanks again for the reminder.
I successfully migrated the data to mysql from sqlite, but did it 1
table at a time. Is there a convenient way to move all the data from
all tables at once? I figured tar and detar just brings back
76 matches
Mail list logo
