[web2py] Re: Survey: Functionality of the Drop Boxes widget

2010-03-23 Thread weheh
Thadeus, it's 6 of one, half-dozen of the other to me. I use both. So in theory, it doesn't really matter which is the default. Therefore, I prefer that the default remain whatever it currently is so that I don't have to change any of my code. -- You received this message because you are

[web2py] Re: How to call other web2py applications from within a web2py application

2010-03-23 Thread Rahul
Hi All, I used this code like below in my view to call other application as this is something simplest I could find. a {{=LOAD (url='http://127.0.0.1:8000/wiki/index.html'}} It did the job. But it overrides my selected application template and if I try to access a url in the index.html

Re: [web2py] Re: Survey: Functionality of the Drop Boxes widget

2010-03-23 Thread Thadeus Burgess
weheh, Massimo, The issue is the same for me, I have several web2py applications, each commanding over 20 forms which make use of IS_IN_SET. I am dealing with a sizable number of forms that I need to update just to fix this. The fact is that web2py changed the output of how drop boxes are

[web2py] Re: Survey: Functionality of the Drop Boxes widget

2010-03-23 Thread Yarko Tymciurak
Thadeus - I initially commiserated with you: backward compatipility is backward compatibility --- but I alwasy thought Massimo held on to that phrase too strongly, too tightly. It's important for the big things, but it _always_ gets in the way of meaningful, useful change... I think perhaps

[web2py] href not being rendered

2010-03-23 Thread annet
In a send_mail.html view I have a link which reads like: pHaving trouble viewing this email? a href={{=URL(r=request,c='clublocatormail',f='browser_version',args=[item.bedrijf])}} target=_blankView it in your browser/a/p When I send the mail and open it this link reads like: pHaving trouble

[web2py] Re: Debian / Ubuntu packager needed!

2010-03-23 Thread Dima Barsky
On Mar 23, 1:15 am, mdipierro mdipie...@cs.depaul.edu wrote: The main feature of web2py is that appliances are data and are treated as such. Consider a CMS app that wants to install, for example, a plugin. A plugin contains code and needs to be installable at runtime. The plugin may also

[web2py] Re: Debian / Ubuntu packager needed!

2010-03-23 Thread Mark Breedveld
I'll see both problems and another solution to work around this. We could install web2py into /usr/ directories with apt. Then create a startup script that makes a copy of web2py and the web2py applications that are installed trough apt to the /var folder. A so called runtime version of web2py.

[web2py] Can't use placeholders when calling stored procedure in DB2

2010-03-23 Thread Alexey Nezhdanov
Problem: (Pdb) print db2db.executesql(call webxdsl.abonsearch (123, 'port_id', '41110', '1', ?, ?);) *** Error: ('07001', '[07001] [IBM][CLI Driver] CLI0100E Wrong number of parameters. SQLSTATE=07001 (-9) (SQLExecDirectW)') (Pdb) print db2db._execute(call webxdsl.abonsearch (?),(1,2)) ***

[web2py] get value of an combo box (select tag)

2010-03-23 Thread tandnk50
Hi all, anyone show me how to I get selected value of combo box ?? thank you very much -- 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

Re: [web2py] Re: Survey: Functionality of the Drop Boxes widget

2010-03-23 Thread Thadeus Burgess
It is not so trivial to search and replace. For one, you cannot place keyword arguments before non-keyword args. So it is not a simple matter of find/replace IS_IN_SET(... with IS_IN_SET(zero=None..., there will have to be parsing of the syntax to determine where to place zero=. I am perfectly

[web2py] Re: is there a way to communicate with Web2Py from an external program?

2010-03-23 Thread canna
thank you. I understand that I have to publish a service that can send and receive calls from clients what do I need to look for on the client side? meaning, what ability 3dsMax should have in order to use this service? On 22 מרץ, 21:28, mdipierro mdipie...@cs.depaul.edu wrote: Perhaps you can

[web2py] Mercurial or Bazaar?

2010-03-23 Thread Giovanni Giorgi
hi all, I have seen there are two web2pty repositories: one based on mercurial and one based on bazaar. Which is the official one? By the way, I have tried both revision control system... I am sticking on mercurial because it seems more popular. I got a very bad feeling with subversion, and I

Re: [web2py] Re: Debian / Ubuntu packager needed!

2010-03-23 Thread Dima Barsky
On Tue, 23 Mar 2010 02:06:16 -0700 (PDT), Mark Breedveld m.breedv...@solcon.nl wrote: I'll see both problems and another solution to work around this. We could install web2py into /usr/ directories with apt. Then create a startup script that makes a copy of web2py and the web2py

[web2py] Re: Debian / Ubuntu packager needed!

2010-03-23 Thread Mark Breedveld
Hi Dimo, I agree on the fact that there more roles. And I want to make a clear separation in the repo. Web2py applications for production use are put in the usr folder. And copied and protected by a startup script. For example you could take the write right from /controllers

[web2py] Re: Debian / Ubuntu packager needed!

2010-03-23 Thread Mark Breedveld
Hi Kuba, Your indeed right that web2py is a higher application. So we could also decide not to pack any web2py applications into the apt repository. This is the most easy solution. Single user web2py server. And to make it according the guidelines, we make a startup script that create a runtime

[web2py] Re: proposal: admin-less ticket support

2010-03-23 Thread selecta
I wrote an issue tracker plugin that can do some of the things (except for deleting all tickets and downloading) also tickets are displayed a little different, sorted by number of error appearance and stacktrace only if you are interested I could post the plugin, it has still some issues but you

[web2py] Re: proposal: change SQLFORM delete checkbox handling

2010-03-23 Thread mdipierro
The only problem I see but needs testing is what happens to an existing app that uses the new SQLFORM with the existing web2py_ajax.html code? Send me a patch and I will try it. On Mar 23, 12:02 am, Jonathan Lundell jlund...@pobox.com wrote: At the moment, there's a delete-confirmation checkbox

[web2py] Re: How to call other web2py applications from within a web2py application

2010-03-23 Thread mdipierro
1) http://web2py.com/plugins/default/jqgrid 2) I suggest using reportlab+platypus On Mar 23, 2:23 am, Rahul rahul.dhak...@gmail.com wrote: Hi All,        I used this code like below in my view to call other application as this is something simplest I could find. a {{=LOAD

[web2py] Re: Can't use placeholders when calling stored procedure in DB2

2010-03-23 Thread mdipierro
will do. On Mar 23, 4:12 am, Alexey Nezhdanov snak...@gmail.com wrote: Problem: (Pdb) print db2db.executesql(call webxdsl.abonsearch (123, 'port_id', '41110', '1', ?, ?);) *** Error: ('07001', '[07001] [IBM][CLI Driver] CLI0100E  Wrong number of parameters. SQLSTATE=07001 (-9)

[web2py] Re: Mercurial or Bazaar?

2010-03-23 Thread mdipierro
They are clones of each other but I'd like to stop mantaining the bazaar one. On Mar 23, 4:50 am, Giovanni Giorgi j...@objectsroot.com wrote: hi all,  I have seen there are two web2pty repositories: one based on mercurial and one based on bazaar. Which is the official one? By the way, I

[web2py] clueless about db insert: IntegrityError: participant.type may not be NULL

2010-03-23 Thread Sven
Hi, I am new to web2py and really like it so far. I just ran into trouble though, and can't find the solution myself. The error message is: IntegrityError: participant.type may not be NULL as a result of calling: db.participant.insert(unique_ref=ref, batch_type=session.batch_type,

Re: [web2py] href not being rendered

2010-03-23 Thread Jonathan Lundell
On Mar 23, 2010, at 1:32 AM, annet wrote: In a send_mail.html view I have a link which reads like: pHaving trouble viewing this email? a href={{=URL(r=request,c='clublocatormail',f='browser_version',args=[item.bedrijf])}} target=_blankView it in your browser/a/p When I send the mail and

Re: [web2py] for testers

2010-03-23 Thread Albert Abril
I like to download the dev from mercurial repos, it's more comfortable. Maybe it's because the habit. On Mon, Mar 22, 2010 at 10:11 PM, mdipierro mdipie...@cs.depaul.edu wrote: http://web2py.com/examples/static/nightly/web2py_src.zip http://web2py.com/examples/static/nightly/web2py_win.zip

[web2py] Re: clueless about db insert: IntegrityError: participant.type may not be NULL

2010-03-23 Thread mdipierro
Because you used sqlite and your made the field type as notnull=True. sqlite does not support ALTER TABLE DROP COLUMN so the field is still there. I suggest you dump the dump the db, recerate it and restore the dump or add the field again as invisible (not sure if this will work, give it a try):

[web2py] Re: href not being rendered

2010-03-23 Thread mdipierro
I do not think this is the problem. He does not seem to be using the A(...) helper. On Mar 23, 9:16 am, Jonathan Lundell jlund...@pobox.com wrote: On Mar 23, 2010, at 1:32 AM, annet wrote: In a send_mail.html view I have a link which reads like: pHaving trouble viewing this email? a

Re: [web2py] Re: proposal: admin-less ticket support

2010-03-23 Thread Jonathan Lundell
On Mar 23, 2010, at 6:00 AM, selecta wrote: I wrote an issue tracker plugin that can do some of the things (except for deleting all tickets and downloading) also tickets are displayed a little different, sorted by number of error appearance and stacktrace only if you are interested I could

Re: [web2py] Re: href not being rendered

2010-03-23 Thread Jonathan Lundell
On Mar 23, 2010, at 7:40 AM, mdipierro wrote: I do not think this is the problem. He does not seem to be using the A(...) helper. Good point; my confusion. OK, then, how about this. If the link reads like text is literally true (that is, we're looking at the display text, not the source

[web2py] Re: Debian / Ubuntu packager needed!

2010-03-23 Thread Dima Barsky
Hi Mark, And I want to make a clear separation in the repo. Web2py applications for production use are put in the usr folder.   And copied and protected by a startup script.   For example you could take the write right from /controllers/models/views   And store static and upload under var

[web2py] Re: for testers

2010-03-23 Thread mdipierro
and it is better but we also need to test the binaries sometimes. On Mar 23, 9:19 am, Albert Abril albert.ab...@gmail.com wrote: I like to download the dev from mercurial repos, it's more comfortable. Maybe it's because the habit. On Mon, Mar 22, 2010 at 10:11 PM, mdipierro

[web2py] Re: Debian / Ubuntu packager needed!

2010-03-23 Thread mdipierro
I am not sure I understand. If I understand you are proposing: 1) installing web2py into /usr/ as it (it will not run there) 2) provide a script to allow users to make a copy of what is needed for runtime (inluding applications/) 3) allow the user to run from the folder where files have been

[web2py] web2py production deployment on vps.net (VIDEO)

2010-03-23 Thread mdipierro
The video: http://vimeo.com/10377947 Please use this link below to sign up for vps.net. http://www.vps.net/?bid=190aid=CD3792opt= If you want to use vps.net, by using the link to register you will be making a zero cost donation. -- You received this message because you are subscribed

[web2py] Re: get value of an combo box (select tag)

2010-03-23 Thread tandnk50
I write a combo box to select all table in the database I want to get tabe name after select I could get the table name if i use form to click submit button, but now I want get table without form?? in section http://web2py.com/book/default/section/5/2, OPTION, SELECT information is not enough

[web2py] Re: jqGrid plugin + ajax search and pagination + ui themes

2010-03-23 Thread dspiteself
I have been using another jquery grid. look at how custimizable the formatters and editors are. Would anyone be interested in us making a web2py plugin for it? If so what type of api should be supported. My current version does ajax add edit and load from a specific web2py model, but I could

Re: [web2py] Re: Debian / Ubuntu packager needed!

2010-03-23 Thread Dima Barsky
I am not sure I understand. If I understand you are proposing: 1) installing web2py into /usr/ as it (it will not run there) 2) provide a script to allow users to make a copy of what is needed for runtime (inluding applications/) 3) allow the user to run from the folder where files have

[web2py] Re: jqGrid plugin + ajax search and pagination + ui themes

2010-03-23 Thread mdipierro
nice On Mar 23, 12:09 pm, dspiteself dspites...@gmail.com wrote: I have been using another jquery grid. look at how custimizable the formatters and editors are. Would anyone be interested in us making a web2py plugin for it? If so what type of api should be supported. My current version does

[web2py] Re: Debian / Ubuntu packager needed!

2010-03-23 Thread mdipierro
I do not have any object. I think I need more details to understand it better. I think you should give it a shot and we'll see later if we find any problem. On Mar 23, 12:37 pm, Dima Barsky d...@debian.org wrote: I am not sure I understand. If I understand you are proposing: 1) installing

[web2py] Re: get value of an combo box (select tag)

2010-03-23 Thread mdipierro
Sorry. can you explain more in detail? On Mar 23, 10:33 am, tandnk50 dn.tan7...@gmail.com wrote: I write a combo box to select all table in the database I want to get tabe name after select I could get the table name if i use form to click submit button, but now I want get table without

[web2py] Re: joins, geraldo and possible alias

2010-03-23 Thread jonatron
Thanks, This is close, but it does not quite get the result I'm looking for, I basically need the following MySQL query: SELECT Calls . * , created_by.Name, handled_by.Name FROM ( Calls LEFT JOIN Users AS created_by ON Calls.CreatedBy = created_by.ID ) LEFT JOIN Users AS handled_by ON

[web2py] Re: joins, geraldo and possible alias

2010-03-23 Thread mdipierro
hmmm. it could be a bug. What do you get if you do: print db(db.Calls.id0)._select(db.Calls.ALL,db.created_by.name,db.handled_by.name, left=[created_by.on(created_by.id==db.Calls.CreatedBy), handled_by.on(handled_by.id==db.Calls.HandledBy)]) On Mar 23, 11:31 am, jonatron

[web2py] Re: MySQL server has gone away

2010-03-23 Thread David Zejda
Hi Massimo, please, were you able to look at it? I'm getting the same error relatively often, several times a day one a site with about 1 daily requests. Thanks :) David On Feb 23, 9:31 am, mdipierro mdipie...@cs.depaul.edu wrote: will look into this. -- You received this message because

[web2py] Re: Debian / Ubuntu packager needed!

2010-03-23 Thread Dima Barsky
On Mar 23, 6:00 pm, mdipierro mdipie...@cs.depaul.edu wrote: I do not have any object. I think I need more details to understand it better. I think you should give it a shot and we'll see later if we find any problem. I'm not very happy about this, I would prefer to reach an agreement before I

[web2py] Re: MySQL server has gone away

2010-03-23 Thread mdipierro
For now do this: try: db=DAL(mysql://a:b...@localhost/c, pool_size=5) except: db=DAL(mysql://a:b...@localhost/c, pool_size=5) It should fix the probelm. If not, set pool_size=0 in the second call. On Mar 23, 1:40 pm, David Zejda d...@atlas.cz wrote: Hi Massimo, please, were you able to

[web2py] Re: Debian / Ubuntu packager needed!

2010-03-23 Thread mdipierro
I understand. You do not have to develop the all thing. Can you show a pseudcode example of what the script would do? On Mar 23, 1:40 pm, Dima Barsky d...@debian.org wrote: On Mar 23, 6:00 pm, mdipierro mdipie...@cs.depaul.edu wrote: I do not have any object. I think I need more details to

[web2py] Re: for testers

2010-03-23 Thread mdipierro
the problem with web2py.exe -h not printing has been resolved. On Mar 22, 4:11 pm, mdipierro mdipie...@cs.depaul.edu wrote: http://web2py.com/examples/static/nightly/web2py_src.ziphttp://web2py.com/examples/static/nightly/web2py_win.ziphttp://web2py.com/examples/static/nightly/web2py_osx.zip

[web2py] Re: Debian / Ubuntu packager needed!

2010-03-23 Thread Mark Breedveld
i'm looking forward to your design plan. It sounds good and i'm confident that it will. regards Mark Breedveld, On Mar 23, 7:47 pm, mdipierro mdipie...@cs.depaul.edu wrote: I understand. You do not have to develop the all thing. Can you show a pseudcode example of what the script would do?

[web2py] Re: joins, geraldo and possible alias

2010-03-23 Thread jonatron
I get the following: SELECT Calls.id, Calls.CallerName, Calls.CreatedBy, Calls.HandledBy, Users.Name, Users.Name FROM Users, Calls LEFT JOIN Users AS created_by ON created_by.id=Calls.CreatedBy LEFT JOIN Users AS handled_by ON handled_by.id=Calls.HandledBy WHERE Calls.id0; On Mar 23, 6:06 pm,

[web2py] Re: Survey: Functionality of the Drop Boxes widget

2010-03-23 Thread Yarko Tymciurak
On Mar 23, 4:22 am, Thadeus Burgess thade...@thadeusb.com wrote: It is not so trivial to search and replace. For one, you cannot place keyword arguments before non-keyword args. So it is not a simple matter of find/replace IS_IN_SET(... with IS_IN_SET(zero=None..., there will have to be

[web2py] Re: Mercurial or Bazaar?

2010-03-23 Thread Yarko Tymciurak
On Mar 23, 8:36 am, mdipierro mdipie...@cs.depaul.edu wrote: They are clones of each other but I'd like to stop mantaining the bazaar one. It would be good to update the main page, and put a note on the branches... Also, since people will find launchpad of web2py, the links (which now still

[web2py] Re: Displaying Foreign Key

2010-03-23 Thread Greg
Ah, very simple. Thanks, guys. P.S. It's a good thing web2py makes it easy to rename tables. :) On Mar 22, 6:07 pm, mdipierro mdipie...@cs.depaul.edu wrote: You can just replace td{{=event.room_id}}/td with td{{=event.room_id.name}}/td This will result in one extra select per record.

[web2py] Re: jqGrid plugin + ajax search and pagination + ui themes

2010-03-23 Thread Yarko Tymciurak
This _is_ nice; looking at source of some of the examples, I see stuff that looks like webpy templating in setup, so the challenge will be to keep it clear which parts are client-dynamic, and which parts should be served by the server (i.e. static within a view)... I want to play with this one!

[web2py] Re: clueless about db insert: IntegrityError: participant.type may not be NULL

2010-03-23 Thread Sven
Thanks! Adding the field as invisible works. But I prefer to dump - drop - create - restore approach. After fiddling around I have two questions about that though 1) Why can I see the db object with corresponding tables in shell, but not access the database behind it? (ProgrammingError: Cannot

[web2py] Re: Displaying Foreign Key

2010-03-23 Thread Al
Would this work in GAE which does not handle table join? or the DAL automatically handle this for 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,

Re: [web2py] Survey: Functionality of the Drop Boxes widget

2010-03-23 Thread Alex Fanjul
Sorry, maybe I come late, but the best default option for me is: Please choose an option at the first place, with null or empty value associate. Even better if we can customize the text like: Please choose your country, Please choose your gender, etc. Of course we should be able to validate

Re: [web2py] web2py production deployment on vps.net (VIDEO)

2010-03-23 Thread Alex Fanjul
Massimo, If Im not wrong you should put your real hostname (myvps.example.com) in the Common Name field of the selfsign certificate to avoid certificate errors refering to incorrect domain certificate association alex El 23/03/2010 16:49, mdipierro escribió: The video:

Re: [web2py] web2py production deployment on vps.net (VIDEO)

2010-03-23 Thread Alex Fanjul
Of course you dont avoid the selfcertificate warning El 24/03/2010 1:46, Alex Fanjul escribió: Massimo, If Im not wrong you should put your real hostname (myvps.example.com) in the Common Name field of the selfsign certificate to avoid certificate errors refering to incorrect domain

Re: [web2py] web2py production deployment on vps.net (VIDEO)

2010-03-23 Thread Tiago Almeida
The video is great and the deployment process is braindead simple. Awesome. Thanks! :) Keep up the good work. Tiago - On Tue, Mar 23, 2010 at 3:49 PM, mdipierro mdipie...@cs.depaul.edu wrote: The video: http://vimeo.com/10377947 Please use this link below to sign up for vps.net.

Re: [web2py] web2py production deployment on vps.net (VIDEO)

2010-03-23 Thread Álvaro Justen [Turicas]
On Tue, Mar 23, 2010 at 12:49, mdipierro mdipie...@cs.depaul.edu wrote: The video:    http://vimeo.com/10377947 Please use this link below to sign up for vps.net.   http://www.vps.net/?bid=190aid=CD3792opt= If you want to use vps.net, by using the link to register you will be making a

[web2py] Re: clueless about db insert: IntegrityError: participant.type may not be NULL

2010-03-23 Thread mdipierro
On Mar 23, 5:49 pm, Sven svenstrin...@gmail.com wrote: Thanks! Adding the field as invisible works. But I prefer to dump - drop - create - restore approach. After fiddling around I have two questions about that though 1) Why can I see the db object with corresponding tables in shell, but

[web2py] Re: Displaying Foreign Key

2010-03-23 Thread mdipierro
No joins on gae. On Mar 23, 6:12 pm, Al albertsec...@gmail.com wrote: Would this work in GAE which does not handle table join? or the DAL automatically handle this for you? -- You received this message because you are subscribed to the Google Groups web2py-users group. To post to this group,

[web2py] Re: Survey: Functionality of the Drop Boxes widget

2010-03-23 Thread mdipierro
Fixed text cannot be set by default, because default is set outside the app and therefore would not be internationalized. On Mar 23, 7:24 pm, Alex Fanjul alex.fan...@gmail.com wrote: Sorry, maybe I come late, but the best default option for me is: Please choose an option at the first place,

[web2py] Re: Python 2.4 compatibility issues

2010-03-23 Thread mr.freeze
Are we aiming to be 2.4 compatible? There are several more problems that I've found but I won't worry about it if not. On Mar 23, 6:41 pm, mr.freeze nat...@freezable.com wrote: On python 2.4, I had to make these changes to tools.py to get web2py running: line 2562: Before:

[web2py] using syslog from a web2py app

2010-03-23 Thread Jonathan Lundell
I'd like to use syslog http://docs.python.org/library/syslog.html from my app. However, it's a .so on my system, so I can't see what it is and how it works, exactly. So my question is: If I open syslog and use it, and don't close it, will it get closed when my controller exits and the object

[web2py] Re: Python 2.4 compatibility issues

2010-03-23 Thread mdipierro
Yes. Please report them. This was tested once but somethink may have slipped is with patches On Mar 23, 10:01 pm, mr.freeze nat...@freezable.com wrote: Are we aiming to be 2.4 compatible? There are several more problems that I've found but I won't worry about it if not. On Mar 23, 6:41 pm,

[web2py] Re: using syslog from a web2py app

2010-03-23 Thread mdipierro
You can redefine response._caller= lambda a: a() but that only wraps controllers, not views. On Mar 23, 10:07 pm, Jonathan Lundell jlund...@pobox.com wrote: I'd like to use syslog http://docs.python.org/library/syslog.html from my app. However, it's a .so on my system, so I can't see what it

[web2py] Re: Python 2.4 compatibility issues

2010-03-23 Thread mr.freeze
In appadmin.html line 75 change this: {{cond = '!=' if table[fieldname].type in ['string','text'] else '0'}} to this: {{cond = '0'}} {{if table[fieldname].type in ['string','text']:}} {{cond = '!='}} {{pass}} line 95 do the same thing. On Mar 23, 10:10 pm,

[web2py] Re: Python 2.4 compatibility issues

2010-03-23 Thread mdipierro
fixed On Mar 23, 10:26 pm, mr.freeze nat...@freezable.com wrote: In appadmin.html line 75 change this:       {{cond = '!=' if table[fieldname].type in ['string','text'] else '0'}} to this:       {{cond = '0'}}       {{if table[fieldname].type in ['string','text']:}}       {{cond = '!='}}

[web2py] book chapters

2010-03-23 Thread mdipierro
If you make a major contribution to the book (like a new section), you should sign it with your name. This is because if I incorporate the chapter in a future printed version, I will want to acknowledge your contribution. The changelog may give me your email address but not the name you want me to