Re: [web2py] Re: Asking advice for a special architecture

2011-04-12 Thread José Luis Redrejo Rodríguez
2011/4/12 Christopher Steel : > We have an app for that. (Sorry could not resist...) Thanks for not resisting :) > > here: > > http://www.web2py.com/appliances/default/show/18 > > It is getting pretty old but should outline the basics using xmlrpc > > Cheers, > I'll take a look at it, as it loo

[web2py] Re: shameless advertisement - web2py course

2011-04-12 Thread kuokon
You can try it's Python version of their Intellij IDE, PyCharm: http://www.jetbrains.com/pycharm/ Best, kuokon On Apr 12, 12:13 pm, Massimo Di Pierro wrote: > Hello everybody, > > tomorrow is the first day of my online class on web development with python > using web2py: > > htt

[web2py] Re: Web2Py and IntelliJ Idea

2011-04-12 Thread kuokon
You can try the Python version of their IDE, PyCharm: http://www.jetbrains.com/pycharm/ Best, kuokon On Apr 12, 12:25 pm, luckysmack wrote: > Im wondering if anyone is using IntelliJ's Idea editor for their > web2py projects. I used it for php before coming here and is hands > down

Re: [web2py] Re: extra text in forms

2011-04-12 Thread Martín Mulone
pass comment value to field definition? ,comment="This is my instruction on how to fill this field" Field('author_name', 'string', length=255, default="", label=("Your name"), comment=T("Your name")), 2011/4/12 niknok > This is how I use it right now.. Looking for a way to change > 'instructi

[web2py] Pagination in web2py

2011-04-12 Thread Francisco Costa
Hi! What is the ideal pagination method in web2py? Are there any plugins or examples?

Re: [web2py] Pagination in web2py

2011-04-12 Thread Tom Atkins
This worked for me: http://www.web2py.com/book/default/chapter/12#Pagination On 12 April 2011 11:16, Francisco Costa wrote: > Hi! > What is the ideal pagination method in web2py? > Are there any plugins or examples?

[web2py] contains in selecting rows

2011-04-12 Thread Kenneth Lundström
I´d like to create a form with a list of members in a select/option tag and have the user select one or more of the members. In form.accepts I´d like to pull all rows of the selected members. In request.vars.members I have a list of selected members but what should the query look like? Kenn

[web2py] Re: Pagination in web2py

2011-04-12 Thread Francisco Costa
The thing is that I use paginations on a lot of different controllers, and I would love to have a more generic solution On Apr 12, 11:29 am, Tom Atkins wrote: > This worked for me: > > http://www.web2py.com/book/default/chapter/12#Pagination > > On 12 April 2011 11:16, Francisco Costa wrote: >

[web2py] Re: 502 Bad Gateway in web2py

2011-04-12 Thread Jose
On 11 abr, 10:39, "contatogilson...@gmail.com" wrote: > Hello guys, > > I hosted a system webfaction.com and its plan has 80MB of memory. But > the strange > thing is that only has two people accessing the system and the usage time > gives > thefollowing error: > > 502 Bad Gateway > > What do I

[web2py] Re: Interactive Fiction App

2011-04-12 Thread Jonathan Dobson
Great - thanks for the info Anthony. WebSockets seem more straightforward to me. They appeal to my low-level sensibilities. Too bad they're not ubiquitous. Yet?

[web2py] Re: Pagination in web2py

2011-04-12 Thread David Marko
Hello, see web2py util project here: http://packages.python.org/web2py_utils/paginate.html I have a good experinece with this. For more advanced solutions you an use this: http://www.web2pyslices.com/main/slices/take_slice/39 David

[web2py] Re: extra text in forms

2011-04-12 Thread DenesL
On Apr 12, 1:34 am, niknok wrote: > This is how I use it right now.. Looking for a way to change > 'instruction' field. Change the field how? Be specific. > form=SQLFORM.factory( >     Field('instruction','text', writable=False, default='Extra text to > display'), >     Field('f1', 'string'))

[web2py] Re: contains in selecting rows

2011-04-12 Thread DenesL
You might be able to use belongs. On Apr 12, 6:44 am, Kenneth Lundström wrote: > I d like to create a form with a list of members in a select/option tag > and have the user select one or more of the members. > > In form.accepts I d like to pull all rows of the selected members. In > request.vars

Re: [web2py] Re: mod_wsgi and import error under apache

2011-04-12 Thread Manuele Pesenti
Il 11/04/2011 19:42, Arun K.Rajeevan ha scritto: Seems your second problem is a circular import problem in matplotlib here is a reference https://groups.google.com/forum/#!topic/modwsgi/97bnQk9ojtY And here goes gist of it, Try a

[web2py] Re: Interactive Fiction App

2011-04-12 Thread Anthony
On Tuesday, April 12, 2011 7:52:24 AM UTC-4, Jonathan Dobson wrote: > > Great - thanks for the info Anthony. WebSockets seem more straightforward > to me. They appeal to my low-level sensibilities. Too bad they're not > ubiquitous. Yet? For browsers that don't yet support WebSockets, ther

[web2py] Re: mod_wsgi and import error under apache

2011-04-12 Thread Massimo Di Pierro
Try run web2py with matplotlib without mod_wsgi. Perhaps matplotlib is printing something. On Apr 12, 8:16 am, Manuele Pesenti wrote: > Il 11/04/2011 19:42, Arun K.Rajeevan ha scritto:> Seems your second problem > is a circular import problem in matplotlib > > here is a reference > >https://grou

[web2py] Re: Creating a many-to-many form with arbitrary number of fields

2011-04-12 Thread spiffytech
On Apr 11, 11:49 pm, JorgeRpo wrote: > what is ingredient_num for? It's to keep track of what order the ingredients are in- recipes usually list ingredients in the order you will use them. On Apr 12, 1:14 am, pbreit wrote: > I'd suggest something like this: That's essentially what I planned t

[web2py] auth_user manually insert/update the password

2011-04-12 Thread Bob
Hello, could someone answer a couple of questions: 1. Is it possible to manually crypt the password in the same way that crud() does it? The reason is that I need to manually update the user with db().update() and can't use crud 2. In similar situation using SQLFORM. When updating the user it's l

[web2py] Re: extra text in forms

2011-04-12 Thread Anthony
On Tuesday, April 12, 2011 1:34:01 AM UTC-4, niknok wrote: > > This is how I use it right now.. Looking for a way to change > 'instruction' field. > > form=SQLFORM.factory( > Field('instruction','text', writable=False, default='Extra text to > display'), > Field('f1', 'string')) Ar

[web2py] Re: auth_user manually insert/update the password

2011-04-12 Thread Anthony
On Tuesday, April 12, 2011 9:59:00 AM UTC-4, Bob wrote: > > Hello, could someone answer a couple of questions: > > 1. Is it possible to manually crypt the password in the same way that > crud() does it? > The reason is that I need to manually update the user with > db().update() and can't use

[web2py] Re: auth_user manually insert/update the password

2011-04-12 Thread Anthony
On Tuesday, April 12, 2011 9:59:00 AM UTC-4, Bob wrote: > > 2. In similar situation using SQLFORM. When updating the user it's > logical to leave the password blank in case you don't want to change > it. But SQLFORM crypts the blank and changes the password in the DB If you pass the record id

Re: [web2py] Re: Asking advice for a special architecture

2011-04-12 Thread Vasile Ermicioi
that solves only the part of synchronizing local and remote databases, but not the offline work for offline you need a desktop solution (adobe air , other solution), or if you need to work in browser, I don't see other solution than google gears Google Gears is in fact a javascript interface to s

Re: [web2py] Asking advice for a special architecture

2011-04-12 Thread Sebastian E. Ovide
2011/4/11 José Luis Redrejo > My intention is using > GAE for this > Are you sure about that ? working with GAE requires much more effort !... you need to spend more time designingand it is much more difficult for refactoring (it is very difficult to predict what your customer is going to n

[web2py] Re: extract get_records from build_set in IS_IN_DB

2011-04-12 Thread Carlos
Hi, For now, I've implemented a tricky work-around that seems to work properly for the special cases I describe, and without repeating any code. In case anyone is interested: class tmp_dbset(object): def __init__(self, owner): self.db = db self.owner = owner def select(s

[web2py] Re: Use bpython with web2py

2011-04-12 Thread Arun K.Rajeevan
as simple as issuing "hg import " once inside web2py repo.

[web2py] Re: Web2Py and IntelliJ Idea

2011-04-12 Thread luckysmack
Idea has all the same features and options as the pycharm version. Pycharm (as well as phpstorm, webstorm, et.al.) are all based on limited versions of Idea, targeted for a specific purpose. In this case, python. I just has the python plugin installed by default. On Apr 12, 2:34 am, kuokon wrote:

[web2py] shortcut for table_is empty?

2011-04-12 Thread mart
Hi, is there a shortcut to check if a table is empty? (not look to see what the content is, just if it has any at all) Thanks, Mart :)

[web2py] Re: LAMP like frameworks are dying. Time for the javascript age

2011-04-12 Thread JmiXIII
"Expect the growth of more full-blown desktop-like apps hosted in the browser (like the Ext JS desktop demo). Expect people to begin to hate refreshing the page. " => +1 I really agree with this and I wish so much webbrowser could use python as javascript On 12 avr, 00:46, cjrh wrote: > O

[web2py] secure connection to database ¿?

2011-04-12 Thread Luis Díaz
Greetings pose the scenario: I have 2 VPS: the first where web2py run the app I'm developing. the second that I have for postgresql database Now the question .. as the database is not on the same server I require to connect securely? Díaz Luis http://www.facebook.com/diazluis2007 User Linux

[web2py] 2 field unique validator

2011-04-12 Thread Mike
I know this question has been asked and answered before, but I am having errors in implementation and I feel like it's something really silly. If anyone can point anything obvious out that I am missing, please let me know. Basically I am trying to implement so that two rows can not have the same co

[web2py] Re: auth_user manually insert/update the password

2011-04-12 Thread Bob
Thanks Anthony Hiding with javascript will not work because it will get submitted with javascript. But I will try the readable/writable trick, thanks Bob

[web2py] 2 field unique validator

2011-04-12 Thread pbreit
Not sure if this is the problem but the book always shows multiple validators enclosed in square brackets [].

[web2py] Re: 2 field unique validator

2011-04-12 Thread DenesL
Move the requires from inside the field definition to after the table definition. web2py will not allow a reference to a field that has not been created. On Apr 12, 12:01 pm, Mike wrote: > I know this question has been asked and answered before, but I am > having errors in implementation and I

[web2py] Re: extract get_records from build_set in IS_IN_DB

2011-04-12 Thread Carlos
Hi DenesL, Thanks, but I just needed this change in IS_IN_DB validator in order to support direct rows/records instead of selectable dbsets, and without requiring extra database access (therefore without an extra db / table). Best regards, Carlos

[web2py] Re: extract get_records from build_set in IS_IN_DB

2011-04-12 Thread DenesL
An alternative would be to load you records in a table defined in a DAL('SQLITE:memory') database, then you can use the regular validators and DB commands. On Apr 12, 11:00 am, Carlos wrote: > Hi, > > For now, I've implemented a tricky work-around that seems to work properly > for the special c

Re: [web2py] shortcut for table_is empty?

2011-04-12 Thread Marin Pranjic
Something like db(db.tablename.id>0).count() ? On Tue, Apr 12, 2011 at 5:22 PM, mart wrote: > Hi, > > is there a shortcut to check if a table is empty? (not look to see > what the content is, just if it has any at all) > > Thanks, > Mart :)

[web2py] Re: 2 field unique validator

2011-04-12 Thread Mike
Thanks DenesL! That was definitely the issue. On Apr 12, 12:21 pm, DenesL wrote: > Move the requires from inside the field definition to after the table > definition. > web2py will not allow a reference to a field that has not been > created. > > On Apr 12, 12:01 pm, Mike wrote: > > > > > > > >

[web2py] Re: auth_user manually insert/update the password

2011-04-12 Thread Anthony
On Tuesday, April 12, 2011 12:01:26 PM UTC-4, Bob wrote: > > Thanks Anthony > > Hiding with javascript will not work because it will get submitted > with javascript. If you use an update form, the hidden password field should be pre-populated, so when you submit, it shouldn't replace the pas

Re: [web2py] Re: Use bpython with web2py

2011-04-12 Thread Albert Abril
OMG! My favourite python interpeter in my favourite (all-languages) framework. You are fantastic people. 2011/4/12 Arun K.Rajeevan > For those who don't use repo but web2py packages from download page, > here is conventional patch files from diff. use patch to apply them. > you have to apply pat

Re: [web2py] Re: LAMP like frameworks are dying. Time for the javascript age

2011-04-12 Thread Albert Abril
Just a question... is erlang a direct competitor to javascript with this paradigm? 2011/4/12 JmiXIII > "Expect the growth of more full-blown desktop-like > apps hosted in the browser (like the Ext JS desktop demo). Expect > people to begin to hate refreshing the page. " => +1 > > I really agree

[web2py] Performance Considerations

2011-04-12 Thread Ross Peoples
I've been developing my application for 6 weeks now and I stay updated with the trunk version of web2py. I know that Massimo, Johnathan, and others have been working to increase performance of web2py, but I had to make a Django app for someone that was similar to one of the web2py applications I

[web2py] Re: LAMP like frameworks are dying. Time for the javascript age

2011-04-12 Thread Massimo Di Pierro
http://blog.mysyncpad.com/post/2073441622/node-js-vs-erlang-syncpads-experience On Apr 12, 12:45 pm, Albert Abril wrote: > Just a question... is erlang a direct competitor to javascript with this > paradigm? > > 2011/4/12 JmiXIII > > > > > > > > > "Expect the growth of more full-blown desktop-li

Re: [web2py] Performance Considerations

2011-04-12 Thread Jason Brower
On 04/12/2011 08:52 PM, Ross Peoples wrote: I've been developing my application for 6 weeks now and I stay updated with the trunk version of web2py. I know that Massimo, Johnathan, and others have been working to increase performance of web2py, but I had to make a Django app for someone that wa

[web2py] Re: Performance Considerations

2011-04-12 Thread Massimo Di Pierro
Migrations do affect time at al, in particular if you use an rdbms other than sqlite. Try switch migrations off, click on the button "bytecode compile"/, and set cool_size=20. Let us know what you get. We can still do better but these three changes should give you a big boost. On Apr 12, 12:52 

[web2py] Re: secure connection to database ¿?

2011-04-12 Thread Massimo Di Pierro
restrict postgresql access to 127.0.0.1 and make a ssh tunnel between machines. On Apr 12, 10:38 am, Luis Díaz wrote: > Greetings > > pose the scenario: > > I have 2 VPS: > > the first where web2py run the app I'm developing. > the second that I have for postgresql database > > Now the question .

Re: [web2py] Performance Considerations

2011-04-12 Thread Anthony
On Tuesday, April 12, 2011 2:14:30 PM UTC-4, encompass wrote: > > I wish there was a way to make a query that could be read easily by all > users. And it updates at a rate I can set in my default.py or something > similar. :D > That way I can have comon queries for all users in one area and it

[web2py] Re: Performance Considerations

2011-04-12 Thread pbreit
pool_size

[web2py] Error ticket and path problem

2011-04-12 Thread Arun K.Rajeevan
Hi, today I tried to put all my web2py projects under a common directory called web2py_projects with a "application" directory within it, in which I kept all my web2py projects. I cloned web2py trunk at web2py_projects/web2py Then soft linked admin, welcome and example applications from within clo

[web2py] Re: mod_wsgi and import error under apache

2011-04-12 Thread Arun K.Rajeevan
It's not matplotlib but mercurial that prints into stdout. >File"/usr/lib/pymodules/python2.6/mercurial/ui.py",line232,inwrite > sys.stdout.write(str(a)) > IOError:sys.stdout access restricted by mod_wsgi About matplotlib, in case there's still problem, can you try to enter plot.py's co

Re: [web2py] Performance Considerations

2011-04-12 Thread Jason Brower
ooohhh, nice! On 04/12/2011 09:31 PM, Anthony wrote: On Tuesday, April 12, 2011 2:14:30 PM UTC-4, encompass wrote: I wish there was a way to make a query that could be read easily by all users. And it updates at a rate I can set in my default.py or something similar. :D T

[web2py] Re: Performance Considerations

2011-04-12 Thread VP
Hi, do you have controller methods that take a relatively long time? For example, at least 0.5 second? I made a point previously that because session is locked at the beginning of a controller function and is released only at the finish of that function, requests will have to wait one after each o

[web2py] Re: mod_wsgi and import error under apache

2011-04-12 Thread Arun K.Rajeevan
well I was looking into mercurial.py in admin/controllers and mercurial's python api I can see ui.quiet is set in our mercurial.py implementation. That should be fixed this issue. But we know it doesn't See http://code.google.com/p/modwsgi/wiki/FrequentlyAskedQuestions and search for "Why do I g

[web2py] Re: Redirect & response.flash

2011-04-12 Thread Drise
Sorry to dig something old up, but is there a way to time it? like the auth login? On Feb 28, 7:11 am, puercoespin wrote: > Very useful information. > > Thanks Jonathan > > On 25 feb, 17:11, Jonathan Lundell wrote: > > > > > > > > > On Feb 25, 2011, at 2:02 AM, SergeyPo wrote: > > > > Hello ever

[web2py] Re: Interactive Fiction App

2011-04-12 Thread Jonathan Dobson
Right on - thanks.

Re: [web2py] Bookings Manager

2011-04-12 Thread Ismael Alejandro
On Mon, Apr 11, 2011 at 8:27 PM, Ialejandro wrote: > Hi everybody!! Again with my booking example, but now I'm really > stucked. > > > I have this model: > > > *** > > if auth.is_logged_in(): >me = a

[web2py] Re: shortcut for table_is empty?

2011-04-12 Thread mart
Yeah, that's what I ended up using... was really looking for a boolean, so I faked it (def isEmpty(tb): returns True if empty, False if not). Was just looking to see if there was one already. Thanks for the reply Mart :) On Apr 12, 1:02 pm, Marin Pranjic wrote: > Something like db(db.tablename.

[web2py] Re: shortcut for table_is empty?

2011-04-12 Thread Massimo Di Pierro
may be faster to do db(db.tablename.id>0).select(limitby=(0,1)) perhaps we should have something like: db(db.tablename).isempty() On Apr 12, 12:02 pm, Marin Pranjic wrote: > Something like db(db.tablename.id>0).count() ? > > > > > > > > On Tue, Apr 12, 2011 at 5:22 PM, mart wrote: > > Hi

[web2py] Re: Bookings Manager

2011-04-12 Thread b00m_chef
You need to add a db Boolean field for "validated". You will need to set default to False. Then simply have the admin validate page return all records in db that have validation=False. On Apr 11, 6:27 pm, Ialejandro wrote: > Hi everybody!! Again with my booking example, but now I'm really >

[web2py] Powerpack

2011-04-12 Thread Martín Mulone
Powerpack App = Plugin Instant Press + Plugins Comments + Plugins Intro: http://www.youtube.com/watch?v=nvvWE2rVnR0 https://bitbucket.org/mulonemartin/powerpack/wiki/Home -- My blog: http://martin.tecnodoc.com.ar Expert4Solution: http://www.experts4solutions.com/e4s/default/expert/6 http://www.

[web2py] Re: Web2Py and IntelliJ Idea

2011-04-12 Thread mikech
We are voting for PyCharm to support Web2Py see this thread: https://groups.google.com/d/topic/web2py/JN7PLI93Vp0/discussion

[web2py] Re: Bookings Manager

2011-04-12 Thread pbreit
I almost never advise an Ajax solution first but this might be a reasonable way to go. This will work for 10s of rooms but probably not 100s since you have to click once to verify each room. You can choose whatever statuses you want. I have it so that it becomes "verified" when you click the lin

[web2py] Re: Powerpack

2011-04-12 Thread Anthony
Awesome! Thanks a lot, Martin. :) On Tuesday, April 12, 2011 5:19:51 PM UTC-4, Martin.Mulone wrote: > Powerpack App = Plugin Instant Press + Plugins Comments + Plugins > > Intro: http://www.youtube.com/watch?v=nvvWE2rVnR0 > > https://bitbucket.org/mulonemartin/powerpack/wiki/Home > > -- > My bl

[web2py] Re: Powerpack

2011-04-12 Thread pbreit
Wow, great packaging! Will definitely have a look.

[web2py] Re: plugins

2011-04-12 Thread Anthony
Let's add Martin's Powerpack to the list: https://bitbucket.org/mulonemartin/powerpack/wiki/Home On Friday, March 11, 2011 9:48:26 AM UTC-5, Massimo Di Pierro wrote: > > I did a very poor job at keeping track of community created plugins. > > If you are aware of a plugin for web2py that is no

[web2py] Re: bulk insert form

2011-04-12 Thread Gregory Hellings
It probably isn't helpful for multiple file uploads, but you can do bulk insert with the CSV interface. You might need to write a little JavaScript magic to convert multiple forms into a CSV format, but it shouldn't be terribly difficult. For multiple uploads, you could just put multiple forms on

[web2py] Re: Powerpack

2011-04-12 Thread Massimo Di Pierro
wow...can we make easier for user to install? Can we add this to the list of wizard plugins? On Apr 12, 4:34 pm, pbreit wrote: > Wow, great packaging! Will definitely have a look.

[web2py] Re: secure connection to database ¿?

2011-04-12 Thread luis diaz
thanks for the reply. I had intended to use for the tunnel: autossh in the configuration of postgresql: allowed the ip of the vps, running the app the ideas of restricting access only to 127.0.0.1 not thought of it. My new question: to making the tunnel, the connection to the db is done as if

[web2py] ReCaptcha and SQLForm

2011-04-12 Thread Drise
I know this is probably really simple, however, I'm somewhat new to Web2py. I have def submit(): form = SQLFORM(db.confession) This form doesnt require a login, so to avoid spam, I would like to implement a captcha. I'd rahter not use Crud, as I'm much more familiar with sqlform, and it seems

[web2py] Re: ReCaptcha and SQLForm

2011-04-12 Thread pbreit
I see this suggestion: form[0].append(TR('',captcha, '')) https://groups.google.com/d/topic/web2py/eeMT2Bb-KYA/discussion

Re: [web2py] Re: bulk insert form

2011-04-12 Thread Stifan Kristi
a, i am understand right now, thank you so much for your explaination, greg. best regards, steve van christie

Re: [web2py] Re: Powerpack

2011-04-12 Thread Stifan Kristi
amazing, i'll try it...

[web2py] Re: Powerpack

2011-04-12 Thread mart
Bravo! On Apr 12, 5:50 pm, Massimo Di Pierro wrote: > wow...can we make easier for user to install? Can we add this to the > list of wizard plugins? > > On Apr 12, 4:34 pm, pbreit wrote: > > > > > > > > > Wow, great packaging! Will definitely have a look.

[web2py] Re: ReCaptcha and SQLForm

2011-04-12 Thread Drise
Traceback (most recent call last): File "gluon/restricted.py", line 188, in restricted File "C:/Users/Drise/Desktop/web2py/applications/MinecraftAnonymous/ controllers/default.py", line 69, in File "gluon/globals.py", line 124, in File "C:/Users/Drise/Desktop/web2py/applications/Minecraft

[web2py] Re: ReCaptcha and SQLForm

2011-04-12 Thread Drise
I've already read through that, and tried to dissect it and use it for what I need, but it didn't work (and slightly confused me more). On Apr 12, 6:42 pm, Drise wrote: > Traceback (most recent call last): >   File "gluon/restricted.py", line 188, in restricted >   File "C:/Users/Drise/Desktop/we

[web2py] Re: ReCaptcha and SQLForm

2011-04-12 Thread Drise
Also, I need to have it show no matter, so I don't need to append it. I just need to have it display always. On Apr 12, 6:45 pm, Drise wrote: > I've already read through that, and tried to dissect it and use it for > what I need, but it didn't work (and slightly confused me more). > > On Apr 12,

[web2py] Re: ReCaptcha and SQLForm

2011-04-12 Thread DenesL
See http://www.web2py.com/book/default/chapter/08?search=captcha#CAPTCHA-and-reCAPTCHA On Apr 12, 8:05 pm, Drise wrote: > Also, I need to have it show no matter, so I don't need to append it. > I just need to have it display always. > > On Apr 12, 6:45 pm, Drise wrote: > > > > > > > > > I've

[web2py] request.args error on module

2011-04-12 Thread 黄祥
hi all, i have a lot of code that used by another controller: e.g. def show(): page = db.author(request.args(0)) or redirect(URL('index')) return dict(page = page) so, i plan to use a module that contain repeated def function: e.g. module : def show(request, db): page =

[web2py] Re: bulk insert form

2011-04-12 Thread villas
I use this code for updating multiple records, maybe you could use something similar for inserts. controller -- myrecords=db(query).select(db.table.ALL) if form.accepts ... for r in myrecords: if request.vars.has_key('id%i_price' % r.table.id): r.table.update_reco

Re: [web2py] Re: bulk insert form

2011-04-12 Thread Stifan Kristi
thank you so much villas for your share, i'll try to modify it for inserts. best regards, steve van christie On Wed, Apr 13, 2011 at 8:43 AM, villas wrote: > I use this code for updating multiple records, maybe you could use > something similar for inserts. > > controller -- > myreco

[web2py] Re: ReCaptcha and SQLForm

2011-04-12 Thread Drise
Hm... I've also tried there too. Seems only to contain a method for CRUD and auth, which I would honestly like to avoid, but if I need to, which it seems I do, I'll use it.

[web2py] Re: secure connection to database ¿?

2011-04-12 Thread Massimo Di Pierro
yes from the point of the web2py all and from the point of view of the postgresql server. On Apr 12, 5:36 pm, luis diaz wrote: > thanks for the reply. > > I had intended to use for the tunnel: autossh > > in the configuration of postgresql: > allowed the ip of the vps, running the app > > the i

[web2py] Re: powertable question about bStateSave

2011-04-12 Thread tomt
Hi, I discovered why pagination is lost. When table.showkeycolumn = true then at line 733 hidekeycolumnjs = "var hidekeycolumn = 200;oTable.fnSetColumnVis(0,false);oTable.fnDraw();" The datatable API says that fnDraw() has the side effect of resetting the pagination If the call is changed to "

[web2py] Re: powertable question about bStateSave

2011-04-12 Thread tomt
Whoops, I made a mistake. Page position is lost when: table.showkeycolumn = False but the "solution" is the same... fnDraw(false) On Apr 12, 8:02 pm, tomt wrote: > Hi, > > I discovered why pagination is lost.  When table.showkeycolumn = true > then at line 733 > > hidekeycolumnjs = "var hidekeyc

[web2py] Re: shortcut for table_is empty?

2011-04-12 Thread mart
Just tried this: test = db(db.cumulativeProperties.id>0).select(limitby=(0,1)) print 'test: {0}'.format(test) results: cumulativeProperties.id,cumulativeProperties.uuid,cumulativeProperties.name,cumulativeProperties.value,cumulativeProperties.tag,cumulativeProperties.cmdName 1,365674dc-6371-4215

[web2py] Re: shortcut for table_is empty?

2011-04-12 Thread Massimo Di Pierro
On Apr 12, 10:06 pm, mart wrote: > Just tried this: > > test = db(db.cumulativeProperties.id>0).select(limitby=(0,1)) > print 'test: {0}'.format(test) > > results: > cumulativeProperties.id,cumulativeProperties.uuid,cumulativeProperties.name > ,cumulativeProperties.value,cumulativeProperties.ta

[web2py] request.args error on module

2011-04-12 Thread pbreit
I usually just put those functions in the models folder. Much easier. I would highly recommend trying to keep things simple.

[web2py] Re: ReCaptcha and SQLForm

2011-04-12 Thread pbreit
This seems to work but you might need to play around with the layout (need to replace recaptcha keys). def captcha_form(): public_key = 'xxx' private_key = 'xxx' form = SQLFORM(db.confession) form[0].append(TR('',Recaptcha(request, public_key, private_key),'')) if form.accepts