Re: [web2py] Many-to-many relations with CRUD Insert

2012-01-17 Thread Christian Winterhager
Yes, thats clear. Until now i use a program, which is based on INFORMIXDB with Python und CGI. In this program (respectively programs) i do exactly that what you described above in your mail. It is not difficult to write these programs but it is slow and boring. But now i know web2py and i wan

[web2py] Apache/mod_wsgi: Exposing individual web2py apps alongside other non-web2py services

2012-01-17 Thread Kevin Ivarsen
Hello, I have an Apache server with mod_wsgi, and I would like to host web2py alongside a variety of other things. For example: http://example.com/ hosts a PHP website. Might link to things like / about.php, /users/view.php, etc http://example.com/files a standard Apache listing of files in a

Re: [web2py] Many-to-many relations with CRUD Insert

2012-01-17 Thread Johann Spies
On 17 January 2012 11:03, Christian Winterhager < christian.winterha...@onlinehome.de> wrote: > Yes, thats clear. Until now i use a program, which is based on INFORMIXDB > with Python und CGI. In this program (respectively programs) i do exactly > that what you described above in your mail. It is

Re: [web2py] Many-to-many relations with CRUD Insert

2012-01-17 Thread Johann Spies
On 17 January 2012 11:27, Johann Spies wrote: > I am working with a biliometric database > Sorry that must be bibliometric database -- Because experiencing your loyal love is better than life itself, my lips will praise you. (Psalm 63:3)

[web2py] Skype Integration

2012-01-17 Thread ganesh waghmare
Hi, I want to integrate skype in my web2py application. I have skypekit downloaded from skype.com. But it gives error : "SSLError:ssl read operation timed out" detailed stack trace: Traceback (most recent call last): File "/usr/lib/python2.6/threading.py", line 532, in __bootstrap_inner sel

[web2py] Re: book 4th edition in PDF

2012-01-17 Thread Remco Boerma
Thanks for writing the book. Concerning payment, i couldn´t find any information about stripe on your page, so i googled them and validated them at visa. I can imagine more people wouldn´t just trust their creditcard details to a form not knowing what system is handling the details and where i

[web2py] Re: book 4th edition in PDF

2012-01-17 Thread Remco Boerma
Works, mastercard

[web2py] Re: Links to referencing records - 'str' object has no attribute 'ignore_common_filters'

2012-01-17 Thread isi_jca
Hi!!! I made a modifications in my script: def list_records(): expresion = 'list_records' table = request.args(0) query = request.vars.query pos = query.find(expresion) if pos >= 0: pos = pos + len(expresion) query= query[pos:] q = db(query) rec

Re: [web2py] Represent - redirect

2012-01-17 Thread Mathias Van Daele
Thanks !! Op 17 januari 2012 00:44 schreef Anthony het volgende: > On Monday, January 16, 2012 4:47:01 PM UTC-5, Mathias Van Daele wrote: >> >> Thanks for answer Johann. >> >> But how can I catch the value of args in the concerned function ? >> > > args from the URL are always in request.args, s

[web2py] Re: DAL IMAPAdapter

2012-01-17 Thread Alan Etkin
I am about to send a new diff to the issues list for IMAPAdapter: Added a new static field "size" to limit size in queries or filter message sizes Possible query commands will be: db.table.size < 3 (to fetch only messages smaller than 3 octets) db.table.size > 1000 (fetch only large m

[web2py] Ckeditor Crud Controller Problem

2012-01-17 Thread Andrew Evans
Hello I am having a problem with CKEditor in Crud I get the following error when I try to use it Traceback (most recent call last): File "/opt/web2py/gluon/restricted.py", line 192, in restricted exec ccode in environment File "/opt/web2py/applications/pstv/controllers/control_panel.py"

[web2py] Re: Ckeditor Crud Controller Problem

2012-01-17 Thread Anthony
> > db.define_table('contrib', > Field('userinfo', db.auth_user, default=auth.user_id, readable=False, > writable=False), > Field('title'), > Field('contributions','text',requires=IS_NOT_EMPTY())) > > Controller Code > > @auth.requires_membership('admin') > def contributions(): >

[web2py] UnicodeEncodeError on GAE

2012-01-17 Thread ttsujie
Hi! I'm web2py and python newbie. I like web2py! But recently I have a problem on GAE. I encounterd UnicodeEncodeError on GAE when I update a field value of one table on appadmin. The table has a list:string field. I suspect that cause is list:string field. File "gluon\html.py", line 1585, in _po

[web2py] Re: Links to referencing records - 'str' object has no attribute 'ignore_common_filters'

2012-01-17 Thread Anthony
> > I made a modifications in my script: > def list_records(): > expresion = 'list_records' > table = request.args(0) > query = request.vars.query > pos = query.find(expresion) > > if pos >= 0: > pos = pos + len(expresion) > query= query[pos:] >

Re: [web2py] Many-to-many relations with CRUD Insert

2012-01-17 Thread Christian Winterhager
I have also constraints on database level, but this is necessary for normal logical consistency of the database model. The problem is for me again - even if i use that "reference" or "list.reference" - that i cannot have * ONLY* these fields book.title author.name in my form on the screen and *

[web2py] Re: Many-to-many relations with CRUD Insert

2012-01-17 Thread Anthony
This might give you some ideas: http://web2py.com/books/default/chapter/29/7#One-form-for-multiple-tables. I suppose you would have to loop through the list of submitted authors to insert multiple records into the "verb" table. Anthony On Monday, January 16, 2012 3:35:16 PM UTC-5, Christian W

[web2py] Re: Question about many to many forms

2012-01-17 Thread Cliff
Check out SQLFORM.smartgrid http://web2py.com/books/default/chapter/29/7#SQLFORM.grid-and-SQLFORM.smartgrid-%28experimental%29 Also the image blog example gives a viable approach, though the relationship is one-to-many http://web2py.com/books/default/chapter/29/3#An-image-blog Also I think you co

[web2py] Re: Links to referencing records - 'str' object has no attribute 'ignore_common_filters'

2012-01-17 Thread isi_jca
Ok, Thanks a lot. On 17 ene, 11:00, Anthony wrote: > > I made a modifications in my script: > > def list_records(): > >     expresion = 'list_records' > >     table = request.args(0) > >     query = request.vars.query > >     pos = query.find(expresion) > > >     if pos >= 0: > >         pos = p

[web2py] Re: DAL IMAPAdapter

2012-01-17 Thread Alan Etkin
The new version of the adapter with fixes and size queries http://code.google.com/p/web2py/issues/detail?id=610#c4

Re: [web2py] Re: There is no web2py homebrew for OS X

2012-01-17 Thread Alvaro Lizama Molina
The pypi repo must be the defeault form of install web2py is cross platform, and easy to use. 2012/1/17 pbreit > Might not be a bad idea but it's way better to install Web2py from source. > Then you have excellent version control. -- Alvaro Lizama Molina - http://alvarolizama.net

[web2py] "too short" - password error not proper case.

2012-01-17 Thread David
Not a biggie, but it seems strange that the auth table generates " too short" error message It seems all the other messages seem proper case like "Cannot be empty" this should be changed to "Too short" for consistency

[web2py] Re: Many-to-many relations with CRUD Insert

2012-01-17 Thread Christian Winterhager
Antony, thank you, i tried exactly this some weeks ago and it did not work. Since now... may be, that i worked not enough. I will try more and we will see.

[web2py] jQuery UI modal form dialog and user function.

2012-01-17 Thread Annet
I would like the default/user function's view default/user.html to open in a modal form dialog as in jQuery UI: http://jqueryui.com/demos/dialog/#modal-form Does one of you have example of how to get this to work? Kind regards, Annet.

[web2py] Re: Many-to-many relations with CRUD Insert

2012-01-17 Thread Christian Winterhager
Anthony, the basic recommendation was to use SQLFORM.factory, and that was a good idea. I tried it again and i had now more success than some weeks before. So now i can insert rows in the table "book" and the table "verb" in one FORM and with only one submit-button. The FORM looks like this: fo

Re: [web2py] Re: Ckeditor Crud Controller Problem

2012-01-17 Thread Andrew Evans
*cheers I must of been blind not to see that last night ty very much On Tue, Jan 17, 2012 at 5:51 AM, Anthony wrote: > db.define_table('contrib', >> Field('userinfo', db.auth_user, default=auth.user_id, readable=False, >> writable=False), >> Field('title'), >> Field('contributions'

[web2py] Python / web2py or.... the learning path?

2012-01-17 Thread Artur
Do you think that someone with basic knowledge of programming (a little theoretical knowledge of languages like python, javascript and c), could have a chance to start learning web programming language using python and web2py framework? I'm not talking about the understanding of language syntax

[web2py] Re: Help with OAuth20 facebook infinite redirect

2012-01-17 Thread Ben Tammetta
Hello, Do you mind sharing what facebook app you switched too? I was writing FB apps in PHP but I want to switch to web2py so I am looking for a nice working base app to start with to create both canvas apps and tab page apps. Any links you can point me too would be appreciated. I have found

[web2py] Guidence on using web2py for a facebook canvas app or tab page app

2012-01-17 Thread Ben Tammetta
Hello, I have developed a few apps for facebook using PHP but I really want switch future development to web2py. I have not found any good updated base facebook web2py apps to start from. A lot of the FB python code I have found applies to Django or assumes you will be using google app engine

[web2py] Re: Python / web2py or.... the learning path?

2012-01-17 Thread Anthony
web2py was originally created as a teaching tool -- I think you'll find it relatively easy to learn web programming with web2py, especially if you have some programming experience. The book (http://web2py.com/books/default/chapter/29) is a great learning resource. For a general understanding of

[web2py] Working XMLRPC code failing on new web2py version ?...

2012-01-17 Thread fpp
Hi, I have this very old web2py app that has been working 24/7 since early 2008... One instance runs on my phone (Nokia N900, a Linux device), another on my home server (also Linux). The mobile instance frequently "pushes" database records to the server instance, using XMLRPC, by calling the rel

[web2py] Re: jQuery UI modal form dialog and user function.

2012-01-17 Thread apple
In user.html add lines: http://ajax.googleapis.com/ajax/libs/jqueryui/1.8.16/ themes/{{=response.theme or "smoothness"}}/jquery-ui.css" rel="stylesheet" type="text/css" /> http://ajax.googleapis.com/ajax/libs/jqueryui/1.8.16/ jquery-ui.min.js" type="text/javascript"> $(document).ready(functi

[web2py] Re: Proposal for SQLFORM.grid

2012-01-17 Thread Massimo Di Pierro
Please open ticket and I will add this tonight On Jan 16, 11:58 pm, Martin Weissenboeck wrote: > Hi! > > grid generats SQLFORMs for 'new', 'view' and 'edit'. But only the first > propagates the parameter formstyle from the constructor: > Line 1550 ('new'): > >            create_form = SQLFORM( >

[web2py] Re: Skype Integration

2012-01-17 Thread Massimo Di Pierro
can you show any code? On Jan 17, 4:17 am, ganesh waghmare wrote: > Hi, > > I want to integrate skype in my web2py application. I have skypekit > downloaded from skype.com. But it gives error : "SSLError:ssl read > operation timed out" > > detailed stack trace: > Traceback (most recent call last)

[web2py] Re: Working XMLRPC code failing on new web2py version ?...

2012-01-17 Thread Massimo Di Pierro
Please open a ticket. What's the latest version that worked? Can you show how you expose the service? On Jan 17, 1:49 pm, fpp wrote: > Hi, > > I have this very old web2py app that has been working 24/7 since early > 2008... > > One instance runs on my phone (Nokia N900, a Linux device), another o

Re: [web2py] Re: Python / web2py or.... the learning path?

2012-01-17 Thread Bruno Rocha
Absolutelly YES! I teach web2py in my course http://cursodepython.com.br the great part of audience is beginners also in web and programming, with Python it is very easy to learn O.O and web2py makes very easy to understand web workflow. * I am making some tests, may be my course will be recorde

Re: [web2py] how to remove duplicate tables in smartgrid?

2012-01-17 Thread Martin Weissenboeck
My problem is similar: At first there is the table of persons "auth_user" with some additional fields like a phone number and so on. Now one persons ("A") writes something concerning another person ("B"). Let's sove it with a table db.define_table('report', Field('from_person', 'reference auth

Re: [web2py] Re: Proposal for SQLFORM.grid

2012-01-17 Thread Martin Weissenboeck
Done. 2012/1/17 Massimo Di Pierro > Please open ticket and I will add this tonight > > On Jan 16, 11:58 pm, Martin Weissenboeck wrote: > > Hi! > > > > grid generats SQLFORMs for 'new', 'view' and 'edit'. But only the first > > propagates the parameter formstyle from the constructor: > > Line 15

[web2py] Need help with drag-n-drop using jQuery

2012-01-17 Thread Frank Hall
I'm prototyping a scheduling board with drivers in the columns and their deliveries in the rows to prove that I can reassign deliveries using drag-n-drop under web2py. I have developed a matrix of movable cells that I based on Massimo's Excel Spreadsheet module. I can drag-n-drop cells just fin

Re: [web2py] Guidence on using web2py for a facebook canvas app or tab page app

2012-01-17 Thread Michele Comitini
Hello Ben, Take a look at this simple example app http://goo.gl/6tXxs http://code.google.com/r/michelecomitini-facebookaccess/source/browse/applications/#applications%2FhelloFacebook Web2py comes with support for oauth2.0 (for facebook auth) included, so take some time to understand how web2py w

[web2py] Re: Python / web2py or.... the learning path?

2012-01-17 Thread Chris May
There are indeed a *lot* of PHP tutorials and articles out there. Most of them are of little value in general, or even misleading readers into bad practices (as referenced by Christian Heilmann in a recent post on Smashing Magazine

[web2py] Re: UnicodeEncodeError on GAE

2012-01-17 Thread howesc
try decode instead of encode (the string is encoded in utf-8 and you are trying to decode): mystr.decode("utf-8") it was a different but similar problem that i had on GAE that i solved this way. good luck! cfh

[web2py] Re: Implementing tornado chat server with web2py

2012-01-17 Thread Abhishek Gupta
I implemented a similar solution, but the user keeps on getting disconnected from the tornado server. This happens frequently with chrome. Any guesses, so as why the user is being disconnected so often (in every 4-5 secs).

[web2py] Re: Python / web2py or.... the learning path?

2012-01-17 Thread pbreit
I find the Widnows/Mac Web2py download to be one of the easiest ways to get started and to learn to program. You will thank yourself later by learning Python instead of PHP. Python is easy to learn because it is pretty well thought-out, the syntax is clean and easy to read, there is not a lot of

[web2py] web2py powered sites yogesh link not working

2012-01-17 Thread António Ramos
http://www.yogeshd.in/ link is not working in the bottom of the page :)

Re: [web2py] Re: There is no web2py homebrew for OS X

2012-01-17 Thread pbreit
Web2py changes too fast to use anything but source, in my opinion.

[web2py] Re: UnicodeEncodeError on GAE

2012-01-17 Thread ttsujie
Thank you for replay. I tried, but the same error message. (app_devserver NG, GAE NG) I think it's strange that error message is "UnicodeEncodeError", is not "UnicodeDecodeError"... On 1月18日, 午前7:44, howesc wrote: > try decode instead of encode (the string is encoded in utf-8 and you are > tryi

[web2py] Re: error class proposal

2012-01-17 Thread Alex
I've created a function getFormFields which I call for every form I'm using. In this function I go through all inputs of the form with form.elements('input, select, textarea') and then I check if the name of the input field exists in form.errors. If there is an error I add a css error class. At th

Re: [web2py] Re: error class proposal

2012-01-17 Thread David J
Massimo added this to trunk. Please see .inputinvalid class On Jan 17, 2012 8:47 PM, "Alex" wrote: > I've created a function getFormFields which I call for every form I'm > using. In this function I go through all inputs of the form with > form.elements('input, select, textarea') > > and then I

[web2py] Re: web2py powered sites yogesh link not working

2012-01-17 Thread Anthony
Thanks for pointing that out. Looks like it may have been a spam posting. Anthony

[web2py] Can I pass a variable through an ajax load?

2012-01-17 Thread chawk
{{=LOAD('controller_name','function',ajax=True)}} if so, where would I put it? I am trying to grab that variable on the page that is being loaded. Hope this makes sense I am completely worn out. Chris

[web2py] Re: Can I pass a variable through an ajax load?

2012-01-17 Thread Anthony
Sure: {{=LOAD('controller_name','function', args=[...], vars=dict(...), ajax=True)}} On Tuesday, January 17, 2012 9:38:48 PM UTC-5, chawk wrote: > > {{=LOAD('controller_name','function',ajax=True)}} > > if so, where would I put it? > > I am trying to grab that variable on the page that is bei

[web2py] how to download file from within a cid target

2012-01-17 Thread smogzer
I'm trying to generate a pdf with the bundled pdf generator (fypdf) from withing a .load file that is loaded into a div. Outside the cid div (i.e. extension .html) the download works fine but from within the .load, the contents get rendered into the cid target, never downloading to the user. How

[web2py] Re: Can I pass a variable through an ajax load?

2012-01-17 Thread chawk
Thanks Anthony.

[web2py] Re: UnicodeEncodeError on GAE

2012-01-17 Thread ttsujie
First I don't know that it's need to update default version setting after update version at app.yaml. After update default version, that go good. I'm sorry for lack of my GAE knowlege. (I'm ashamed..) Anyway if someone encounter the same problem, this thread is useful. (I'm not sure this is the be

[web2py] Re: get user id on mobile app after login to web2py

2012-01-17 Thread Yuval
The cookies was an easy and strait forward implementation. Adding response.cookies['myCookie'] = 'myData' in the web2py default controller (that the user will visit once logged in) and using the CookieManager Class on the app side provided a simple solution. Thanks, Yuval On Jan 16, 8:10 pm, Brun

[web2py] dynamic SQLForm.factory from query

2012-01-17 Thread web-dev-m
Dear Everyone, I am still plugging away on web2py and loving it more and more the better I understand python. I have a page where a large list is generated from a database query. Next to each item from the list, I would like to put the ability to add a comment. I did this statically by creating

Re: [web2py] Re: Movuca - The Social CMS - Need Testers and Contributors

2012-01-17 Thread Bruno Rocha
HI, A lot of people are sending me emails with suggestions and bug reports (some people who are not familiar with github to fill issues there) So I created UserVoice account for Movuca If you have any consideration, suggestion, bug report, idea etc... http://movuca.uservoice.com Thank you --

[web2py] Re: Skype Integration

2012-01-17 Thread ganesh waghmare
Hi massimo, code: In default.py-> import Skype accountName = skype_username accountPsw = skype_password loggedIn= False Skype.Account.OnPropertyChange = AccountOnChange MySkype = Skype.GetSkype(keypair_keyFileName) account = MySkype.GetAccount(accountName) account.LoginWithPassword(account

[web2py] MSSQL How to access tables which not created by web2py

2012-01-17 Thread Dan
Hi all, In db.py, I successful create a connect to MSSQL and create a new table in "mydb" database like below. db.py msdb = DAL('mssql://user:passwd@sqlserver/mydb') msdb.define_table('test1',Field('firstname'),Field('surname')) Now in mydb, I got two tables "test" which already exists and "tes

Re: [web2py] MSSQL How to access tables which not created by web2py

2012-01-17 Thread Bruno Rocha
You need to map the existent table and set migrate=False, also you will need to specify which field is the 'id' or primary keys, and for all fields you need to tell the datatype. msdb.define_table( 'test', FIeld('cod', 'id'),

[web2py] Re: dynamic SQLForm.factory from query

2012-01-17 Thread Annet
Did you have a look at the wiki example in the web2py book: http://www.web2py.com/books/default/chapter/29/3#A-wiki ? Instead of a 'page' table you have the table from which you retrieve the list and, just like in the example, a table to store the comments. page_id in your case becomes list_id. I