[web2py:32278] Possible major bug, or my own stupidity...

2009-10-06 Thread encompass
I wish I could show you the code, but it's against company policy. But I have some code that is accessing an sqlite database. I am the only one accessing it right now. But I have some session data. session.equipment (Holds specific data pulled from xml and turned into a dictionary. for example "a1

[web2py:32279] advice on the routes py and database queries.

2009-10-06 Thread mengu
hi everyone, i am coding a blog system with web2py that will be licensed under gpl. hopefully, it will be a nice one with tagging, categorising, syntax highlighting, built-in accordion menu and many other things. my first question is about routes. can you please let me know how to set the routes

[web2py:32280] Re: anti spam, anti porn strategy?

2009-10-06 Thread encompass
Just as a side note, I wanted to inform you that web2py groups is now on the ban list of my business. Just after I looked at this post with my work computer. I am not blaming you, but I thought it was funny. Regards, Jason On Oct 6, 7:17 am, Richard wrote: > I've used the recaptcha built in to

[web2py:32281] Re: newbie looking for style advice

2009-10-06 Thread Iceberg
On Oct5, 11:31pm, mdipierro wrote: > > On Oct 5, 10:14 am, devnull wrote: > > 2. I wanted a more specific error message for each field which uses an > > is-float-in-range validator ... But is there a way to refer to the > > actual max and min without repeating it in the string? Something like >

[web2py:32282] Re: Try out admin editor

2009-10-06 Thread Kuba Kucharski
Still the main problem with admin editor is this wrong-refreshing/wrong-displaying trauma - never solved or did I miss smth ? On Oct 5, 2009 3:47 AM, "Iceberg" wrote: Did not really try the admin editor until recently. Nice as a handy tool for some quick typing, the only inconvenience is the la

[web2py:32283] Re: Possible major bug, or my own stupidity...

2009-10-06 Thread mdipierro
Hi Jason, there is no way this could be caused by the framework. IF it is a bug, it would be in the python PIcke module but I do not think this is the case. It is more likely there is a typo somewhere in the code. Print the session in your model (before you modify it) and in your actions (before

[web2py:32284] Google app engine retrieve data from related table

2009-10-06 Thread Michael - afewtips.com
I understand that inner joins on GAE are not allowed, so what is the best practice for retrieving data from related tables? Forget normalizing and just add the related data to the record when the record is added? or Keep the data normalized and every time I need to show the data for a bicycle,

[web2py:32285] Re: Increment the value of a field + 1 or how to auto-increment a field value ?

2009-10-06 Thread Web2py-SuperFan
Hi Massimo, I have a similar problem, and will deploy to gae I want to do a crud.create form on table1.dollars and then when it is accepted, automatically update table2.total with a running total How do I do this? Here's what I did but it just accepts the form data, inserts to table 1 then doe

[web2py:32286] Re: Database Synchronization and UUID's

2009-10-06 Thread CJSteel
Sweet! It works great after commenting out the auth tables and making that minor change to the import action. It had crossed my mind that the auth tables did not have uuid's but I did not realize that you could do without them completely. I will do some more poking around to find the parameters r

[web2py:32287] Re: Google app engine retrieve data from related table

2009-10-06 Thread mdipierro
It depends on how many you need per page. If more than 10 I would use option 1 (denormalize) and if less than 10 I would go with option 2. I just made up the number 10. On Oct 6, 8:38 am, "Michael - afewtips.com" wrote: > I understand that inner joins on GAE are not allowed, so what is the > bes

[web2py:32288] FORM factory

2009-10-06 Thread leone
I want use FORM object and helpers objects, but I need complete control over html code. Exists a factory method as in SQLFORM, so I can code .. {{=form.begin}} {{=form.widget.x}} {{=form.widget.y}} {{=form.submit}} {{=form.end}} .. ??? If not, exist an alternative way to obtain t

[web2py:32289] Re: Google app engine retrieve data from related table

2009-10-06 Thread Michael - afewtips.com
What if it's 9 fields? (Just Kidding). Thanks - I think I will retain the normalized form and possibly create a function that scans a table that maintains the relationships between tables with the table names and key fields so I don't have to deal with updating the names and queries everywhere e

[web2py:32290] Re: FORM factory

2009-10-06 Thread mdipierro
yes form=SQLFORM.factory(Field('x'),Field('y')) .. {{=form.custom.begin}} {{=form.custom.widget.x}} {{=form.custom.widget.y}} {{=form.custom.submit}} {{=form.custom.end}} .. On Oct 6, 9:51 am, leone wrote: > I want use FORM object and helpers objects, but I need complete > co

[web2py:32291] Yet another bug :)

2009-10-06 Thread Thadeus Burgess
When using custom SQLFORM, you do not need to specify {{=form.hidden_fields()}} because {{=form.custom.end}} includes these. As to documentation, you MUST specify {{=form.hidden_fields()}}, however with the latest version from svn, the form gets broken since it includes multiple _formkeys. Easy

[web2py:32292] Re: Yet another error in the manual :-)

2009-10-06 Thread mdipierro
Where does it say that? The example in page 219 says: 1 {{=form.custom.begin}} 2 Image name: {{=form.custom.widget.name}} 3 Image file: {{=form.custom.widget.file}} 4 Click here to upload: {{=form.custom.submit}} 5 {{=form.custom.end}} On Oct 6, 10:34 am, Thadeus Burgess wrote: > When using

[web2py:32293] Re: Database Synchronization and UUID's

2009-10-06 Thread DenesL
I added this to the errata https://mdp.cti.depaul.edu/wiki/default/_page/Errata_for_web2py_2nd_Edition_Book please help to keep it updated. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py-users" group. To po

[web2py:32294] Re: FORM factory

2009-10-06 Thread leone
How can I render a sequence by Field in SQLFORM.factory? Thanks! On 6 Ott, 17:14, mdipierro wrote: > yes > > form=SQLFORM.factory(Field('x'),Field('y')) > > > .. >  {{=form.custom.begin}} >  {{=form.custom.widget.x}} >  {{=form.custom.widget.y}} >  {{=form.custom.submit}} >  {{=form.custo

[web2py:32295] Re: passing arguments from view to controller

2009-10-06 Thread Yarko Tymciurak
:-) On Sun, Oct 4, 2009 at 11:21 AM, znafets wrote: > > slightly disagree - there is nothing like going through that, > explaining it to someone who is willing to help and skilled. > Thanks to you Yarko and also Massimo I got some enlightment along the > way. > > ciao > Stefan > > On Oct 3, 8:22

[web2py:32296] Re: FORM factory

2009-10-06 Thread mdipierro
It is automatic. You just need Field('name',requires=IS_IN_SET(('a','b','c'))) or requires IS_IN_DB On Oct 6, 11:32 am, leone wrote: > How can I render a sequence by Field in > SQLFORM.factory? > Thanks! > > On 6 Ott, 17:14, mdipierro wrote: > > > yes > > > form=SQLFORM.factory(Field('x'),F

[web2py:32297] Re: I found this.

2009-10-06 Thread Yarko Tymciurak
not sure what this is pointing to (maybe you need to login to see?) - I have a long list of IIIT Hyderabad Publications On Mon, Oct 5, 2009 at 12:58 AM, mdipierro wrote: > > > http://web2py.iiit.ac.in/publications/default/index?type=Journal%20Papers&type=Conference%20Papers&type=Technical%20

[web2py:32298] Re: Database Synchronization and UUID's

2009-10-06 Thread CJSteel
np, thank you On Oct 6, 12:12 pm, DenesL wrote: > I added this to the > erratahttps://mdp.cti.depaul.edu/wiki/default/_page/Errata_for_web2py_2nd_E... > > please help to keep it updated. --~--~-~--~~~---~--~~ You received this message because you are subscribed t

[web2py:32299] Re: Yet another bug :)

2009-10-06 Thread Thadeus Burgess
It did say it on http://web2py.com/AlterEgo/default/show/205 However, it has been changed. I have yet to purchase the book, waiting to see if a version 3 will be released soon :P >Where does it say that? >The example in page 219 says: >1 {{=form.custom.begin}} >2 Image name: {{=form.custom.wid

[web2py:32300] Re: Yet another error in the manual?

2009-10-06 Thread mdipierro
Ok, I am changing the title for this thread. :-) On Oct 6, 1:23 pm, Thadeus Burgess wrote: > It did say it on > > http://web2py.com/AlterEgo/default/show/205 > > However, it has been changed. > > I have yet to purchase the book, waiting to see if a version 3 will be > released soon :P > > >Wher

[web2py:32301] Re: I found this.

2009-10-06 Thread mdipierro
Scroll at the bottom. web2py powered. On Oct 6, 1:04 pm, Yarko Tymciurak wrote: > not sure what this is pointing to (maybe you need to login to see?) - I have > a long list of IIIT Hyderabad Publications > > On Mon, Oct 5, 2009 at 12:58 AM, mdipierro wrote: > > >http://web2py.iiit.ac.in/pub

[web2py:32302] Re: FORM factory

2009-10-06 Thread leone
Acc.!! It works fine, but form.accets(request.vars) returns always False. I have a button type=submit with an image before {{=form.custom.end}}. I suppose this could be an error and Ihave substitute it with {{=form.custom.submit}} with no result. I have difficult to find solutions using your manua

[web2py:32304] course on python+web development+web2py

2009-10-06 Thread mdipierro
Shameless advertisement: http://www.cdm.depaul.edu/ipd/Programs/Pages/WebDevelopmentwithPython.aspx This is an online only class, you can watch the recordings at your convenience. It is a bit costly and I get a very small fractions of the revenues but - if you pass it - you will get a certificat

[web2py:32305] deploying web2py on cpanel shared hosting

2009-10-06 Thread whiskeyjuvenile
I'm trying to get web2py to work with cpanel shared hosting. I have shell access. Is there some walkthrough guide on how to get it working without using apache as a proxy/not using the web2py-cherrypy server? --~--~-~--~~~---~--~~ You received this message because

[web2py:32303] Re: FORM factory

2009-10-06 Thread mdipierro
Let us know when you find out. Massimo On Oct 6, 2:43 pm, leone wrote: > Acc.!! > It works fine, but form.accets(request.vars) returns always False. > I have a button type=submit with an image before {{=form.custom.end}}. > I suppose this could be an error and Ihave substitute it with > {{=form

[web2py:32306] Re: deploying web2py on cpanel shared hosting

2009-10-06 Thread whiskeyjuvenile
http://groups.google.com/group/web2py/browse_thread/thread/10f93e6c50c11929/c2b3f1d93a5ae37e?lnk=gst&q=cpanel#c2b3f1d93a5ae37e I'm trying to follow these directions. I unzipped web2py_src.zip into /home/[username]/codebase/web2py/ I have .htaccess in /home/[username]/public_html/ that says: Op

[web2py:32307] Re: I found this.

2009-10-06 Thread Yarko Tymciurak
Hmmm maybe they pulled that off - all I see when I scroll is " Copyright © 2009 - IIIT Hyderabad . All Rights Reserved." But now I see when I change pages thru the menu on the left, there is that characteristic web2py "flash" little popup (albeit on this site, an em

[web2py:32308] Re: deploying web2py on cpanel shared hosting

2009-10-06 Thread mdipierro
http://web2py.com/examples/static/web2py_manual_cut.pdf includes a chapter with deployment recipes and shows how to use mod_wsgi. Massimo On Oct 6, 2:41 pm, whiskeyjuvenile wrote: > I'm trying to get web2py to work with cpanel shared hosting. I have > shell access. > > Is there some walkthrou

[web2py:32309] Re: I found this.

2009-10-06 Thread mdipierro
You can look at the js in the source code and the url. On Oct 6, 3:07 pm, Yarko Tymciurak wrote: > Hmmm maybe they pulled that off - all I see when I scroll is " > > Copyright © 2009 - IIIT Hyderabad . All Rights > Reserved." > > But now I see when I change pages thru

[web2py:32310] URLs in static files

2009-10-06 Thread Eric Vicenti
Hi, I understand most of my site CSS and Javascript (which need no database interface) should be static files, but there is often the need to include URLs in CSS or JS files. How should I do the URLs such that the site is still portable? -Eric --~--~-~--~~~---~--~---

[web2py:32311] Re: deploying web2py on cpanel shared hosting

2009-10-06 Thread whiskeyjuvenile
Particularly, the instructions in 11.8 are somewhat unclear. Does the web2py folder go in htdocs, or do the contents of the web2py folder go in htdocs? Where should .htaccess reside? On Oct 6, 4:12 pm, mdipierro wrote: > http://web2py.com/examples/static/web2py_manual_cut.pdf > > includes a chap

[web2py:32312] Re: deploying web2py on cpanel shared hosting

2009-10-06 Thread whiskeyjuvenile
I tried to follow the instructions in section 11.8 on page 81/295, but I'm getting 500 errors. On Oct 6, 4:12 pm, mdipierro wrote: > http://web2py.com/examples/static/web2py_manual_cut.pdf > > includes a chapter with deployment recipes and shows how to use > mod_wsgi. > > Massimo > > On Oct 6, 2

[web2py:32313] Re: URLs in static files

2009-10-06 Thread Dmitri Zagidulin
Put your css and javascript into the applications/myapp/static folder. And in the view, call them like: (static being the folder, base.css being the name of the file, etc). If you have subfolders in static, such as one for images and one for javascript, you would do: And so on. On Tue, Oct 6

[web2py:32314] Re: I found this.

2009-10-06 Thread Yarko Tymciurak
Well, right now this site is generating tickets - so I can't do that either ;-) On Tue, Oct 6, 2009 at 3:14 PM, mdipierro wrote: > > You can look at the js in the source code and the url. > > On Oct 6, 3:07 pm, Yarko Tymciurak wrote: > > Hmmm maybe they pulled that off - all I see when I sc

[web2py:32315] Re: URLs in static files

2009-10-06 Thread mdipierro
It is good practice to put in the CSS only relative urls to other static files. That is not a problem with web2py. If you need to include in the CSS urls generated by {{=URL()}} then you should promote the css from a static file to a dynamic page: 1) make a controller for it 2) make a view en

[web2py:32316] Re: advice on the routes py and database queries.

2009-10-06 Thread Mengu
anyone? On Oct 6, 10:23 am, mengu wrote: > hi everyone, > > i am coding a blog system with web2py that will be licensed under gpl. > hopefully, it will be a nice one with tagging, categorising, syntax > highlighting, built-in accordion menu and many other things. > > my first question is about r

[web2py:32317] Re: FORM factory

2009-10-06 Thread Thadeus Burgess
Massimo, How do you control the display of a widget? When using Field('blah', requires=IS_IN_DB(db, 'category.id', 'category.name'), widget=SQLFORM.widgets.radio.widget) It displays the radio list in a table... I want a UL If you do not select a radio option, it will also append "Value is not

[web2py:32318] Re: advice on the routes py and database queries.

2009-10-06 Thread mdipierro
Consider the former http://domain/post/a_post_title assuming your app is called "app" and in controller "defaul.py" you have an action def post(): post_title=request.args(0) return post_title then in routes.py routes_in=('/post/(?P.*)','/app/default/post/\g'),) routes_out=('/app/defau

[web2py:32320] Re: advice on the routes py and database queries.

2009-10-06 Thread Álvaro Justen [Turicas]
On Tue, Oct 6, 2009 at 04:23, mengu wrote: > > hi everyone, > > i am coding a blog system with web2py that will be licensed under gpl. > hopefully, it will be a nice one with tagging, categorising, syntax > highlighting, built-in accordion menu and many other things. I'm creating a blog app to u

[web2py:32319] Re: FORM factory

2009-10-06 Thread mdipierro
You need to make your own widget On Oct 6, 3:45 pm, Thadeus Burgess wrote: > Massimo, > > How do you control the display of a widget? > > When using > > Field('blah', requires=IS_IN_DB(db, 'category.id', 'category.name'), > widget=SQLFORM.widgets.radio.widget) > > It displays the radio list in a

[web2py:32321] Why does this pass validation?

2009-10-06 Thread Thadeus Burgess
Using SQLFORM.factory(Field('name', notnull=True)) If you submit the form without entering anything into name it will pass form.accepts. Just reading, it seems as if you have to specify requires=IS_NOT_EMPTY() Then what is the purpose of notnull=True? -Thadeus --~--~-~--~~

[web2py:32322] Re: FORM factory

2009-10-06 Thread leone
Find out. In normal condition SQLFORM constructs the html form. If you make it manually, is in your responsability to match the Field definition of the SQLFORM with their presence in html code. If you omit one form.accepts return always False. On 6 Ott, 22:45, Thadeus Burgess wrote: > Massimo,

[web2py:32323] Re: URLs in static files

2009-10-06 Thread Jonathan Lundell
On Oct 6, 2009, at 1:35 PM, mdipierro wrote: > It is good practice to put in the CSS only relative urls to other > static files. That is not a problem with web2py. > > If you need to include in the CSS urls generated by {{=URL()}} > then you should promote the css from a static file to a dyna

[web2py:32324] gluon.contrib.login_methods gae_google_account.py

2009-10-06 Thread mr.freeze
Is the ChunkedReader class supposed to be there? It seems to be missing some stuff. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web2py@googlegroups.com T

[web2py:32325] Re: Why does this pass validation?

2009-10-06 Thread mdipierro
notnull = True is enforced by the database, not by the framework. In the case of SQLFORM.factory there is no db io therefore it is not used. On Oct 6, 4:05 pm, Thadeus Burgess wrote: > Using > > SQLFORM.factory(Field('name', notnull=True)) > > If you submit the form without entering anything int

[web2py:32326] Re: FORM factory

2009-10-06 Thread Thadeus Burgess
Cool, changing from a table to a UL is fairly easy.. Now what about the error being displayed on EACH radio button? -Thadeus On Tue, Oct 6, 2009 at 4:11 PM, leone wrote: > anually, is in your responsability to match the Field definition of > the SQLF > --~--~-~--~~~

[web2py:32327] Re: URLs in static files

2009-10-06 Thread Eric Vicenti
Thanks, mdi and Jonathan. I will borrow your __cssheaders() function, if you don't mind. Is there any way to have some code in the css.py controller which will automatically define functions for all my css files in /views/css/ ? All it would need to do is run the __cssheaders() function and retur

[web2py:32328] crud.create on table 1 + update table 2

2009-10-06 Thread Web2py-SuperFan
Hi, How do I use crud.create on GAE so I can create a new record in table 1 and update a record in table 2 at the time I create the record in table 1? Thanks for your help. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google G

[web2py:32329] Re: URLs in static files

2009-10-06 Thread Jonathan Lundell
On Oct 6, 2009, at 2:54 PM, Eric Vicenti wrote: > > Thanks, mdi and Jonathan. I will borrow your __cssheaders() function, > if you don't mind. > > Is there any way to have some code in the css.py controller which will > automatically define functions for all my css files in /views/css/ ? > All it

[web2py:32330] Re: Why does this pass validation?

2009-10-06 Thread Thadeus Burgess
Gotchya, and a blank string (which is what is posted from the form) is not a Null value :) -Thadeus On Tue, Oct 6, 2009 at 4:38 PM, mdipierro wrote: > > notnull = True is enforced by the database, not by the framework. In > the case of SQLFORM.factory there is no db io therefore it is not >

[web2py:32331] Re: help on sending email on gae

2009-10-06 Thread Richard
It's not documented in the manual, but I think you need: mail.settings.server = 'gae' Also make sure the sender email is your gmail account, because GAE has restriction on the from address: http://code.google.com/appengine/docs/python/mail/emailmessagefields.html On Oct 6, 5:01 pm, vneve wrot

[web2py:32332] Re: GAE Tutorial to Web2py

2009-10-06 Thread murray3
This works really well now, thanks. I want to take it further have you configured any of the javascript xmpp client libraries to work with this on GAE? any help appreciated chrism On Oct 5, 7:35 am, Robin B wrote: > Try not checking for 'POST' or chat, to see if there is a problem with > those c

[web2py:32333] Re: anti spam, anti porn strategy?

2009-10-06 Thread Richard
what do you mean? On Oct 6, 6:44 pm, encompass wrote: > Just as a side note, I wanted to inform you that web2py groups is now > on the ban list of my business.  Just after I looked at this post with > my work computer.  I am not blaming you, but I thought it was funny. > Regards, > Jason > > On

[web2py:32334] Re: deploying web2py on cpanel shared hosting

2009-10-06 Thread whiskeyjuvenile
[ ]...@[ ] [~/www]# python web2py_modpython.py Traceback (most recent call last): File "web2py_modpython.py", line 1, in ? from mod_python import apache File "/usr/lib64/python2.4/site-packages/mod_python/apache.py", line 30, in ? import _apache ImportError: No module named _apac

[web2py:32335] Re: Try out admin editor

2009-10-06 Thread Richard
I found the autosave feature often fails, but when I manually click the save button it usually succeeds. On Oct 6, 11:30 pm, Kuba Kucharski wrote: > Still the main problem with admin editor is this > wrong-refreshing/wrong-displaying trauma - never solved or did I miss smth ? > > On Oct 5, 2009

[web2py:32336] Re: deploying web2py on cpanel shared hosting

2009-10-06 Thread whiskeyjuvenile
Here's the specific apache log error: [Tue Oct 06 18:30:54 2009] [error] [client MY IP] AttributeError: module '/home/[username]/public_html/web2py_modpython.py' contains no 'handler' [Tue Oct 06 18:30:54 2009] [error] [client MY IP] Filename: '/home/ [username]/public_html/500.shtml' [Tue Oct 06

[web2py:32337] Re: deploying web2py on cpanel shared hosting

2009-10-06 Thread Graham Dumpleton
You don't have mod_python installed for that Apache instance. The '_apache' module is a special embedded module created by mod_python Apache module within memory space of Apache process at run time. Graham On Oct 7, 10:14 am, whiskeyjuvenile wrote: > [   ]...@[     ] [~/www]# python web2py_modp

[web2py:32338] Re: deploying web2py on cpanel shared hosting

2009-10-06 Thread whiskeyjuvenile
Thanks Graham. I caught that after some googling, and it seems from the apache log that it isn't a problem. I can't figure out what they're complaining about the handler now though... On Oct 6, 7:38 pm, Graham Dumpleton wrote: > You don't have mod_python installed for that Apache instance. The >

[web2py:32339] Re: deploying web2py on cpanel shared hosting

2009-10-06 Thread Graham Dumpleton
On Oct 7, 10:35 am, whiskeyjuvenile wrote: > Here's the specific apache log error: > > [Tue Oct 06 18:30:54 2009] [error] [client MY IP] AttributeError: > module '/home/[username]/public_html/web2py_modpython.py' contains no > 'handler' Presumably you created: web2py_modpython.py That file

[web2py:32340] Re: deploying web2py on cpanel shared hosting

2009-10-06 Thread whiskeyjuvenile
from mod_python import apache import modpythonhandler def handler(req): req.subprocess_env['PATH_INFO'] = req.subprocess_env['SCRIPT_URL'] return modpythonhandler.handler(req) I'm following the instructions from http://groups.google.com/group/web2py/browse_thread/thread/bc354fb11

[web2py:32341] Error message when uploading a photo... Using postgresSQL DB

2009-10-06 Thread Yannick
Hello mate, When uploading a JPG photo from my application I have an error message referring to the encoding... here is the error coming from sql.py: " DataError: invalid byte sequence for encoding "UTF8": 0xff HINT: This error can also happen if the byte sequence does not match the encoding exp

[web2py:32342] Re: Adding a user name to user registration

2009-10-06 Thread Yannick
> 1) error messages for uniqueness of user name & email are not shown to > front end; is there any other js that I need to include? You can customize the error message of the "email" and "username" by using something like this: - {{if form.errors.email:}} {{=form.errors.email}}{{pass}} - {{if f

[web2py:32343] Re: deploying web2py on cpanel shared hosting

2009-10-06 Thread whiskeyjuvenile
If, following those instructions, I change, in .htaccess PythonHandler web2py_modpython to PythonHandler modpythonhandler The error is AttributeError: module '/home/[username]/public_html/ modpythonhandler.py' contains no 'handler' On Oct 6, 7:57 pm, whiskeyjuvenile wrote: > from mod_python

[web2py:32344] Re: Google app engine retrieve data from related table

2009-10-06 Thread Robin B
If you want to keep it normalized, and the intersection is less than 1000 entities, and joined by a primary key (ID), use a batch get, to fetch all the join items in parallel. If you are going to de-normalize, take a look at google ListProperty. Robin On Oct 6, 9:59 am, "Michael - afewtips.com"

[web2py:32345] Re: deploying web2py on cpanel shared hosting

2009-10-06 Thread whiskeyjuvenile
This works: from mod_python import apache def handler(req): req.content_type = 'text/plain' req.write("Hello World!") return apache.OK If I insert the line "import modpythonhandler" it fails. It seems like "import hashlib" in gluon/utils.py is failing --~--~-~--~~

[web2py:32346] Re: advice on the routes py and database queries.

2009-10-06 Thread Mengu
massimo, actually this wasn't what i am asking, but thank you for showing another way for it. i have my controller named as "post" and i have the action "view". i currently have my routes_in like the following: http://mengu.pastebin.com/m698f1726 this is working very well however please let me kn

[web2py:32347] Re: Error message when uploading a photo... Using postgresSQL DB

2009-10-06 Thread mdipierro
Can you show us the model and the action that does the upload? On Oct 6, 7:03 pm, Yannick wrote: > Hello mate, > When uploading a JPG photo from my application I have an error message > referring to the encoding... here is the error coming from sql.py: > > " > DataError: invalid byte sequence fo

[web2py:32348] Re: advice on the routes py and database queries.

2009-10-06 Thread mdipierro
items = db(dd.posts.relations.category==db.categories.id).select() for item in items: print item.posts.id,'belongs',item.categories.title On Oct 6, 8:23 pm, Mengu wrote: > massimo, > > actually this wasn't what i am asking, but thank you for showing > another way for it. i have my controller

[web2py:32349] Re: Error message when uploading a photo... Using postgresSQL DB

2009-10-06 Thread Yannick
### Here is the model db.define_table('photo', db.Field('photoname', type='string',length=20), db.Field('photodesc', type='string',length=250), db.Field('photoviewprv', type='boolean',default=False), db.Field('photocreattime', type='datetim

[web2py:32350] Re: Error message when uploading a photo... Using postgresSQL DB

2009-10-06 Thread mdipierro
The problem is in these lines: formPic = form_factory(db.photo, fields= ['photoname','fileupload','albphotoref_fk']) if formPic.accepts(...): feedback = db.photo.insert (fileupload=request.vars.fileupload,) You are bypassing the automatic upload mechanism, doing the upload man

[web2py:32351] web2py on top of SAP

2009-10-06 Thread weheh
I'm talking to a startup company that wants an SAP *enterprise* solution. For the size and complexity of the company's operations, this seems absurd to me because of the cost and complexity of getting an SAP solution in place. I would love to recommend a custom web2py implementation would be ideal

[web2py:32352] Re: advice on the routes py and database queries.

2009-10-06 Thread Mengu
i got this error for the query: >>> items = db(db.posts.relations.category==db.categories.id).select() Traceback (most recent call last): File "", line 1, in File "/home/mengu/web2py/gluon/sql.py", line 1265, in __getattr__ return dict.__getitem__(self,key) KeyError: 'relations' here i

[web2py:32353] Re: web2py on top of SAP

2009-10-06 Thread DenesL
SAP products range from the small business oriented Business One (B1) with a few users to the corporate Business Suite (ex R/3) with hundreds of them. B1 could be an appropriate solution for this company. My RFC proposal for legacy tables (in the developers forum) is geared towards interfacing wi

[web2py:32354] Re: web2py on top of SAP

2009-10-06 Thread mdipierro
Hi Denes, I apologize for not getting back to you on that. The problem is with the ramifications of the change you propose. we should talk about that. I will send you an email. Massimo On Oct 6, 10:10 pm, DenesL wrote: > SAP products range from the small business oriented Business One (B1) > w

[web2py:32355] Re: web2py on top of SAP

2009-10-06 Thread mdipierro
On the specific issue of SAP. I do know SAP but I have been working recently with some peoplesoft tables. The problem for me was not reading them (they had an ID). The problem was that I could not find a good description of what the tables are, how they are linked and what the field mean. Peoples

[web2py:32356] Re: advice on the routes py and database queries.

2009-10-06 Thread Álvaro Justen [Turicas]
On Tue, Oct 6, 2009 at 23:36, Mengu wrote: > > i got this error for the query: > items = db(db.posts.relations.category==db.categories.id).select() > Traceback (most recent call last): >  File "", line 1, in >  File "/home/mengu/web2py/gluon/sql.py", line 1265, in __getattr__ >    return di

[web2py:32357] Re: advice on the routes py and database queries.

2009-10-06 Thread mdipierro
Sorry I had to guess. Now that I know the tables: items = db(db.posts.id==db.relations.post) (db.relations.category==db.categories.id).select() On Oct 6, 9:36 pm, Mengu wrote: > i got this error for the query: > > >>> items = db(db.posts.relations.category==db.categories.id).select() > > Traceb

[web2py:32358] Re: anti spam, anti porn strategy?

2009-10-06 Thread Richard
oh, because of the keyword "p*rn" in the title! haha On Oct 7, 10:13 am, Richard wrote: > what do you mean? > > On Oct 6, 6:44 pm, encompass wrote: > > > Just as a side note, I wanted to inform you that web2py groups is now > > on the ban list of my business.  Just after I looked at this post

[web2py:32359] Re: Try out admin editor

2009-10-06 Thread mdipierro
Can you send me a patch? On Oct 6, 7:30 am, Kuba Kucharski wrote: > Still the main problem with admin editor is this > wrong-refreshing/wrong-displaying trauma - never solved or did I miss smth ? > > On Oct 5, 2009 3:47 AM, "Iceberg" wrote: > > Did not really try the admin editor until recently

[web2py:32360] submenus and IE

2009-10-06 Thread mdipierro
Has anybody tried submenus and IE. Do they work? I assumed they did not I tried once and it did not work for me. Massimo --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, se

[web2py:32361] Re: advice on the routes py and database queries.

2009-10-06 Thread Mengu
alvaro, i guess i cannot add relations to my posts table as Field ('relations', db.relations) since the relations table is not defined before the posts table. before using the current query, i have tried the query that you guys provided. my main problem with that query is that it selects all the

[web2py:32362] Re: submenus and IE

2009-10-06 Thread drayco
In virtualbox with IE7 and IE8 with WinXP, it's works. With two machines with WinXP with IE7 and IE8, it's works. However, some of my user report me that it didn't not work. On 6 oct, 22:31, mdipierro wrote: > Has anybody tried submenus and IE. Do they work? I assumed they did > not I tried onc

[web2py:32363] Re: advice on the routes py and database queries.

2009-10-06 Thread Yarko Tymciurak
On Tue, Oct 6, 2009 at 10:57 PM, Mengu wrote: > > alvaro, i guess i cannot add relations to my posts table as Field > ('relations', db.relations) since the relations table is not defined > before the posts table. > I don't think you need this in your posts table (cross references), but in any ca

[web2py:32364] Re: submenus and IE

2009-10-06 Thread Yarko Tymciurak
Seems to work fine in Windows 7 RC, with IE8 ... On Tue, Oct 6, 2009 at 11:31 PM, drayco wrote: > > In virtualbox with IE7 and IE8 with WinXP, it's works. > With two machines with WinXP with IE7 and IE8, it's works. > > However, some of my user report me that it didn't not work. > > On 6 oct, 22

[web2py:32365] Re: web2py on top of SAP

2009-10-06 Thread weheh
Massimo, the connection between Peoplesoft and SAP is not obvious to me, probably because I'm ignorant. Would it be possible to develop a DAL interface to SAP's database in the future? How difficult would it be to do that? Would it be easier if web2py drives a subset of SAP but still a complete we

[web2py:32366] Re: anti spam, anti porn strategy?

2009-10-06 Thread weheh
That's scary. Would deleting this thread get the group back on the permitted list? Probably not. Maybe this thread should be cut anyway before the bot censors all catch the scent. Yarko, you've got a sharp knife, don't you? On Oct 6, 11:24 pm, Richard wrote: > oh, because of the keyword "p*rn" i

[web2py:32367] Re: anti spam, anti porn strategy?

2009-10-06 Thread Yarko Tymciurak
A corp server will trigger on keywords, as a precaution - Jason just needs to inform his IT dept. to take this off their ban list, and point out why this was a mis-fired trigger (they will no doubt add an exception for web2py groups, given the topic). On Wed, Oct 7, 2009 at 12:06 AM, weheh wrote:

[web2py:32368] Re: anti spam, anti porn strategy?

2009-10-06 Thread weheh
How about people who haven't discovered web2py yet and won't bother asking IT to reclassify the site? On Oct 7, 1:09 am, Yarko Tymciurak wrote: > A corp server will trigger on keywords, as a precaution - Jason just needs > to inform his IT dept. to take this off their ban list, and point out why