Re: [web2py] Script to generate schema (models) from mysql

2010-10-03 Thread Álvaro Justen [Turicas]
On Sun, Oct 3, 2010 at 19:37, Alexandre Andrade wrote: > Alvaro, > > I didn't see this post before. > > this can be a great feature and I will trye to adapt it to postgresql and > mysql, at least. > > if massimo already don't use it, with sqlite, postresql and mysql, it can > worth the value. Ple

Re: [web2py] How to loop through two items

2010-10-03 Thread Gary Herron
On 10/03/2010 08:21 PM, Andrew Evans wrote: I am trying to use two database values returned in my function If I use two loops (one inside another) it repeats itself for a single item for how many items are in the database, I think its cause of the two loops So I am trying to combine the loop

[web2py] How to loop through two items

2010-10-03 Thread Andrew Evans
I am trying to use two database values returned in my function If I use two loops (one inside another) it repeats itself for a single item for how many items are in the database, I think its cause of the two loops So I am trying to combine the loops into one {{for (stuff, products) in (userstuff

Re: [web2py] Re: Building Rows and Columns

2010-10-03 Thread Andrew Evans
hey ty that gives me a good start *Cheers

[web2py] Re: web2py 1.86.1 is OUT

2010-10-03 Thread mdipierro
Thank you for reporting the problem. Hard to fix things when I do not know there is a problem. ;-) On Oct 3, 9:22 pm, Manu wrote: > Thx Massimo , It works perfectly on windows now! > > On Mon, Oct 4, 2010 at 4:16 AM, mdipierro wrote: > > Fixed in 1.86.2 > > > incidentally I discovered the win bi

Re: [web2py] Re: web2py 1.86.1 is OUT

2010-10-03 Thread Manu
Thx Massimo , It works perfectly on windows now! On Mon, Oct 4, 2010 at 4:16 AM, mdipierro wrote: > Fixed in 1.86.2 > > incidentally I discovered the win binary was missing login_methods and > both osx and win binaries were missing pyfpdf. > > I am surprised nobody noticed. This was an error in t

[web2py] Re: web2py 1.86.1 is OUT

2010-10-03 Thread mdipierro
Fixed in 1.86.2 incidentally I discovered the win binary was missing login_methods and both osx and win binaries were missing pyfpdf. I am surprised nobody noticed. This was an error in the build script now fixed. Massimo On Oct 3, 9:01 pm, Manu wrote: > Hi , >   I have tried this release and

[web2py] Re: Autocomplete widget doesn't work on GAE?

2010-10-03 Thread mdipierro
Yes. You can make it work (sort of) if you edit gluon/sqlhtml.py and replace rows = self.db(field.like(self.request.vars[self.keyword] +'%'))\ .select(orderby=self.orderby,limitby=self.limitby,*self.fields) with rows = self.db(field>=self.request.vars[sel

Re: [web2py] Re: web2py 1.86.1 is OUT

2010-10-03 Thread Manu
Hi , I have tried this release and have some issues with the Windows release . Here is the log generated when i start the web2py_no_console.exe . Traceback (most recent call last): File "web2py.py", line 17, in File "gluon/widget.py", line 25, in File "gluon/main.py", line 44, in File

[web2py] Re: Building Rows and Columns

2010-10-03 Thread mdipierro
I would do this: {{def display(i,row):}} {{=i}} . {{=A(row.product_name, _href=URL('indv_product', args=row.id))}} {{return}} {{for i,row in enumerate(rows):}} {{if i%3==0:}}{{pass}} {{display(i,row)}} {{if i%3==2:}}{{pass}} {{pass}} {{# fill up blanks #}} {{for j in range(i%3,2):

[web2py] Autocomplete widget doesn't work on GAE?

2010-10-03 Thread Tito Garrido
I'm trying to use autocomplete widget ( http://web2py.com/book/default/chapter/07#Autocomplete-Widget) on GAE and I'm receiving this error: Traceback (most recent call last): File "/Users/titogarrido/Documents/Projetos/GAE/gametroca/web2py/gluon/restricted.py", line 188, in restricted exec cc

[web2py] Re: Script to generate schema (models) from mysql

2010-10-03 Thread mdipierro
we also have scripts/extract_mysql_models.py Massimo On Oct 3, 5:37 pm, Alexandre Andrade wrote: > Alvaro, > > I didn't see this post before. > > this can be a great feature and I will trye to adapt it to postgresql and > mysql, at least. > > if massimo already don't use it, with sqlite, postre

[web2py] Re: Packt Publishing Web2py cookbook

2010-10-03 Thread mdipierro
A bunch of us got that. If you did please contact me privately. Massimo On Oct 3, 4:27 pm, Richard wrote: > Just got this email: > > """ > Hi, > > I am Usha Iyer, an Acquisition Editor with Packt Publishing. As an > Acquisition Editor, it is my role to evaluate, develop and ultimately > bring bo

[web2py] Re: experimental... .pdf

2010-10-03 Thread mdipierro
if there are errors it should return text containing the errors, else pdf. This mechanism for error reporting is temporary and does not quite work. On Oct 3, 3:02 pm, Michele Comitini wrote: > @Massimo, > > is it text? > > response.headers['content-type']='text' > > or > > response.headers['conte

[web2py] Building Rows and Columns

2010-10-03 Thread Andrew Evans
Hello all I am facing a challenge in my code for some reason the logic to generate a group of div tags in a 3 by 3 column is eluding me here is my code I am missing something can anyone help if you can help by showing me a way to avoid using tables that would be great if not and end up using tab

Re: [web2py] Script to generate schema (models) from mysql

2010-10-03 Thread Alexandre Andrade
Alvaro, I didn't see this post before. this can be a great feature and I will trye to adapt it to postgresql and mysql, at least. if massimo already don't use it, with sqlite, postresql and mysql, it can worth the value. 2010/6/11 Álvaro Justen > Hello Alexandre, nice work. > I did it in pa

[web2py] Packt Publishing Web2py cookbook

2010-10-03 Thread Richard
Just got this email: """ Hi, I am Usha Iyer, an Acquisition Editor with Packt Publishing. As an Acquisition Editor, it is my role to evaluate, develop and ultimately bring book ideas to publication. I am also responsible for finding the right author for any book; bringing them onboard, then worki

[web2py] Re: Select specific fields on GAE

2010-10-03 Thread István Gazsi
I think it almost works. :) The uploaded files were redirected to the gallery_images table, but when I try to display them using the download function, the app can't retrieve them. I get the following error: Traceback (most recent call last): File "/base/data/home/apps/scalpellino-manufactory/ 3

Re: [web2py] experimental... .pdf

2010-10-03 Thread Michele Comitini
@Massimo, is it text? response.headers['content-type']='text' or response.headers['content-type']='application/pdf' ? tnx mic 2010/10/3 mdipierro : > install pdflatex > > create a views/generic.pdf that contains: > > begin file > {{ > import re > from gluon.contrib.markmin.markmin2p

[web2py] Re: experimental... .pdf

2010-10-03 Thread mart
@Michele: Thanks for that, I will make good use of it! :) @Massimo: scaling is one of those options that is more often set by the pdf viewer (because what generates the pdf usually sets the default to "scaling=enabled"). If I re-use that fingerboard example: When using the app, the young violinist

[web2py] Re: @Massimo: email notification on documentation User Comments additions

2010-10-03 Thread mdipierro
Good point. I will look into ti. should not be difficult but I am swamped at the moment. If it does not get done in one week, please remind me personally. Massimo On Oct 3, 2:20 pm, cjrh wrote: > Hi Massimo > > Is it possible for you to set something up so that I can be notified > by email whene

[web2py] @Massimo: email notification on documentation User Comments additions

2010-10-03 Thread cjrh
Hi Massimo Is it possible for you to set something up so that I can be notified by email whenever a visitor to the web2py book leaves a User Comment? Frequently, these comments point out errors in the documentation. I would like to fix errors faster, but I don't get around to check the all commen

[web2py] Re: auth.has_membership syntax erron

2010-10-03 Thread mdipierro
we all do that. ;-) On Oct 3, 12:28 pm, Dr Schmulge wrote: > Thank you , sorry , this is my fault, stupid copy past error  . > > 2010/10/3 mdipierro : > > > more likely there is an incomplete line before and it expects an > > indented block > > > On Oct 3, 9:41 am, Dr Schmulge wrote: > >> Hi al

Re: [web2py] Re: auth.has_membership syntax erron

2010-10-03 Thread Dr Schmulge
Thank you , sorry , this is my fault, stupid copy past error . 2010/10/3 mdipierro : > more likely there is an incomplete line before and it expects an > indented block > > On Oct 3, 9:41 am, Dr Schmulge wrote: >> Hi all >> >>  Missing gluon.tools  import ?? >> >> File "/home/john/web2py/applica

[web2py] Re: auth.has_membership syntax erron

2010-10-03 Thread mdipierro
more likely there is an incomplete line before and it expects an indented block On Oct 3, 9:41 am, Dr Schmulge wrote: > Hi all > >  Missing gluon.tools  import ?? > > File "/home/john/web2py/applications/testapp/models/menu.py", line 32 >     if auth.has_membership(auth.id_group('Administrator'))

[web2py] auth.has_membership syntax erron

2010-10-03 Thread Dr Schmulge
Hi all Missing gluon.tools import ?? File "/home/john/web2py/applications/testapp/models/menu.py", line 32 if auth.has_membership(auth.id_group('Administrator')): ^ SyntaxError: invalid syntax in file menu.py if auth.has_membership(auth.id_group('Administrator')): response.menu

[web2py] Re: DAL, legacy keyed table, field references

2010-10-03 Thread mdipierro
Thanks Denes, I agree. It is better to continue add features to sql.py until somebody has the time to put dal.py back in sync with sql.py. Massimo On Oct 3, 8:35 am, DenesL wrote: > Hi Ivan, > > sorry for the confusion, I have been a little away from web2py, not by > choice. > > Don't wait for

[web2py] Re: reduce textarea rows in autogenerated form

2010-10-03 Thread mdipierro
something like this should do form=crud.create(...) form.element('textarea')[_cols']=40 form.element('textarea')[_rows']=2 or use jQuery/CSS. I normally use jQuery. On Oct 3, 7:00 am, Markandeya wrote: > Dear Friends of Web2py, > where do i go to edit the default number of rows for a textarea

[web2py] Re: web2py 1.86.1 is OUT

2010-10-03 Thread mdipierro
I knew I forgot something important. I apologize. 1.86.1 also includes Hebrew translation by our user Yair. He did more than that since he fixed some typos in many of the existing translations. Massimo On Oct 3, 12:49 am, guruyaya wrote: > Oh, awsome! I see there's Hebrew and RTL support, in th

[web2py] Re: experimental... .pdf

2010-10-03 Thread mdipierro
what is scaling? On Oct 3, 12:02 am, mart wrote: > Ok, 'm really liking this! a few questions: > > 1) I'm not catching on where we get pdflatex... is it a plugin? where > do we get it? > > 2) Is this a feature that can be add to an up for users? meanin > something like "upload your document - the

[web2py] Re: DAL, legacy keyed table, field references

2010-10-03 Thread DenesL
Hi Ivan, sorry for the confusion, I have been a little away from web2py, not by choice. Don't wait for dal.py, just follow the 3 steps under point (E) in the post http://groups.google.com/group/web2py/browse_thread/thread/db150376b06d47fc The insert function in step 2 is on line 2527 now (1.85.3

[web2py] reduce textarea rows in autogenerated form

2010-10-03 Thread Markandeya
Dear Friends of Web2py, where do i go to edit the default number of rows for a textarea displayed in a SQLFORM or CRUD form that is autogenerated from a model? There are fields with a 'text' datatype. The textareas are too long vertically and they have scroll bars if more text area is needed which

Re: [web2py] Re: DAL, legacy keyed table, field references

2010-10-03 Thread Ivan Matveev
>2010/10/3 mdipierro : > Since August we had many improvements in sql.py that were not > reflected into dal.py. So shell I start hacking DAL or wait for improvements to be put in? > web2py is still using sql.py and it will be a little while before we > move to dal.py If I start hacking how do I

Re: [web2py] Re: DAL, legacy keyed table, field references

2010-10-03 Thread Ivan Matveev
Hi Denes, >2010/10/3 DenesL : > Hi Ivan, > > mysql is not one of the supported DBs for keyed tables: > only DB2, MSSQL, Ingres, and Informix have been added as per I looked at dal.py (web2py 1.83.2 2010-08-15). It has # list of drivers will be built on the fly # and lists only what is available

Re: [web2py] Re: Confirm deletion of record

2010-10-03 Thread Jason Brower
I do something similar except I use request.args(0) and look for "yes". If it has it delete otherwise show a screen with a "du ya reelize wanna" and a no with goes to some page, and yes which just adds a /yes to the end. IF there is yes, delete AND redirect to a page somewhere... BR, J On 1

Re: [web2py] web2py 1.86.1 is OUT

2010-10-03 Thread Jason Brower
I love the db(db.table) idea... when I first started using web2py I would do that thinking it would do that. BR, JAson On 10/02/2010 11:50 PM, mdipierro wrote: Changelog: markmin2latex markmin2pdf Storage getfirst, getlast, getall by Kevin and Nathan db(db.table), db(db.table.id) both supporte

[web2py] Re: Admin - edit static files is broken

2010-10-03 Thread Arnaud Masselin
Hi MAssimo, on localhost, I use web2py server. I look in httpd config. Thanks. On 2 oct, 22:04, mdipierro wrote: > Could be a permission issue. When you open it from localhost do you > still use lighttpd or do you start web2py user your user account? > > On Oct 2, 10:58 am, Arnaud Masselin wr

Re: [web2py] Re: experimental... .pdf

2010-10-03 Thread Michele Comitini
@Mart 1) You need to install a TeX distribution, TeX Live is probably the most complete: http://tug.org/texlive/ 2010/10/3 mart : > Ok, 'm really liking this! a few questions: > > > 1) I'm not catching on where we get pdflatex... is it a plugin? where > do we get it? > > > 2) Is this a feature t