[web2py] Re: Problem with DB2 and text field type when accessing db2 using ODBC ...

2012-01-19 Thread David Marko
Thank you !!! This setting s in db2cli.ini is really working for me without any further chnage in web2py tables. Nice. Also how do you access db2 from web2py? Do you use ODBC or native driver? I'm asking because ODBC is working for me just fine, but I also installed DB2 python driver and change

Re: [web2py] Re: Record Versioning

2012-01-19 Thread JF
No, I'm simply playing with SQLite. It's only for evaluation only. Anyway, I also noticed that it would store a new record regardless there is a modification in a field or not. Is it normal? Is there a way to avoid storing new record if in the end there is no difference when compared to prev

[web2py] passing navigational links in the header and ajax woes

2012-01-19 Thread web-dev-m
Currently, in my application, I am passing navigational links in the header, such as /app/controller/view/1/2/3 Where 1/2/3 are things the controller and view use to set the correct page. In my application, I am finding two problems with this. First is security. Although I have written validati

[web2py] Re: using sum with left join

2012-01-19 Thread Adi
+1 Thanks Massimo! This one helped a lot!

[web2py] Re: Using ?attachnment problem with '.enc' file suffix

2012-01-19 Thread JoeCodeswell
Dear Anthony, Big thanks. Works great. Love and peace, Joe On Jan 19, 7:29 pm, Anthony wrote: > On Thursday, January 19, 2012 10:18:24 PM UTC-5, JoeCodeswell wrote: > > > Dear web2py folks, > > > I am trying to force the download of a a file named > > 'allLists.xls.enc'. using '?attachment' af

[web2py] Re: Using ?attachnment problem with '.enc' file suffix

2012-01-19 Thread Anthony
On Thursday, January 19, 2012 10:18:24 PM UTC-5, JoeCodeswell wrote: > > Dear web2py folks, > > I am trying to force the download of a a file named > 'allLists.xls.enc'. using '?attachment' after the URL. > > I am getting similar errors from Firefox and Opera: "Firefox doesn't > know how to op

[web2py] Using ?attachnment problem with '.enc' file suffix

2012-01-19 Thread JoeCodeswell
Dear web2py folks, I am trying to force the download of a a file named 'allLists.xls.enc'. using '?attachment' after the URL. I am getting similar errors from Firefox and Opera: "Firefox doesn't know how to open this address, because the protocol (e) isn't associated with any program." Here is

[web2py] Re: permissions problems on ubuntu 11.10

2012-01-19 Thread Likit
Solved. Needed to add the www-data group to the location where I installed web2py and to phpmyadmin. Everything works as I want it to including a little static file served by apache to make sure the server is up, access via ssl to phpmyadmin, access to the test app for wsgi to make sure wsgi is r

[web2py] cluster: distributed locks

2012-01-19 Thread sebastian
Hi All, just thinking on how to implement a distributed locking system in web2py using a DB: one row per each lock, lock_name is unique, if the row doesn't exist, then it is locked, if the row exist already, then it cannot be lock as it is already locked ! I'd like to create a module like thi

[web2py] Re: begin a transaction manually ?

2012-01-19 Thread Massimo Di Pierro
1) db.commit() closes a transactions and starts a new one. 2) yes but not concurrently, unless you have two db objects. 3) it is the same. On Jan 19, 5:02 pm, sebastian wrote: > hi all, > > 1) is it possible to begin a transaction manually within a controller ? > > 2) can I start more than one

[web2py] begin a transaction manually ?

2012-01-19 Thread sebastian
hi all, 1) is it possible to begin a transaction manually within a controller ? 2) can I start more than one transaction ? 3) question 1 for DAL in a non web2py application ? thanks

[web2py] permissions problems on ubuntu 11.10

2012-01-19 Thread Likit
I thought this was going to be easy. Boy, was I wrong. Lots of good documentation for ubuntu 11.10 from both ubuntu and linode. I got apache, ssl, mysql, php, mod_wsgi, and phpmyadmin working perfectly first time, no stumbles. But, then I tried to make the mods to httpd.conf (really, its includ

Re: [web2py] Re: SQLFORM.smartgrid query/search don't work for related tables

2012-01-19 Thread Jim Steil
Massimo I'm referring to the issue I reported in this thread: http://groups.google.com/group/web2py/browse_thread/thread/280f6b746e2b7201# It is where I'm using an id column not named 'id'. -Jim On 1/19/2012 4:41 PM, Massimo Di Pierro wrote: when you say "quit working" can you get more d

[web2py] Re: SQLFORM.smartgrid query/search don't work for related tables

2012-01-19 Thread Massimo Di Pierro
when you say "quit working" can you get more details? trackeback? wrong behaviour? what behaviour? On Jan 19, 10:47 am, Jim Steil wrote: > Cliff - I was getting a bunch of stuff together this morning to show you > what I'm doing, but when I updated to the latest trunk most of my > smartgrids quit

Re: [web2py] Setting mysql collation in web2py?

2012-01-19 Thread mdorval
Thanks for the note! I've tried passing to the driver_args a Charset object (defined by the pymysql lib like so): from gluon.contrib.pymysql import charset passing into DAL DAL(,driver_args={'charset':charset.charset_by_id(83)) in the charset module this is the Charset object I'm referring t

Re: [web2py] Setting mysql collation in web2py?

2012-01-19 Thread Bruno Rocha
BTW, DAL receives another argument driver_args = None You can pass args to the mysql driver

Re: [web2py] Setting mysql collation in web2py?

2012-01-19 Thread Bruno Rocha
may be this argument db = DAL("mysql://", * db_codec*='UTF-8') On Thu, Jan 19, 2012 at 6:47 PM, mdorval wrote: > Hey, > I was wondering if there's any way to set the collation of the mysql > tables created by web2py to utf8_bin. Thanks! > -- Bruno Rocha [http://rochacbruno.com.br]

[web2py] Re: Paypal Mass Pay API

2012-01-19 Thread Web2Py Freak
How will i use it ?

[web2py] Setting mysql collation in web2py?

2012-01-19 Thread mdorval
Hey, I was wondering if there's any way to set the collation of the mysql tables created by web2py to utf8_bin. Thanks!

[web2py] Re: Problem with DB2 and text field type when accessing db2 using ODBC ...

2012-01-19 Thread Paolo Caruccio
On windows7 I solved the issue by adding to db2cli.ini these rows (replace MYDATABASE and MYDATABASEALIAS with your data): [MYDATABASE] dbalias=MYDATABASEALIAS LONGDATACOMPAT=1 LOBMAXCOLUMNSIZE=1048575 if you need more info about db2cli.ini go to this page http://publib.boulder.ibm.com/infocent

[web2py] error importing custom modules into controller

2012-01-19 Thread monotasker
I'm moving a whole bunch of (perfectly functional) business logic from model files to custom modules. But when I try to import the modules in my controllers custom_import is throwing an error. Here's the traceback: File "/home/ian/web2py/gluon/restricted.py", line 204, in restricted exec c

[web2py] Re: SQLFORM.smartgrid query/search don't work for related tables

2012-01-19 Thread Simon Ashley
+1 for a resolution on this. On Jan 19, 1:20 pm, Jim Steil wrote: > Adnan > > I did not get this working, but that doesn't mean it has been resolved. > I've given up on the search that is included in grid/smartgrid and have > been working on a solution whereby you can override the default behavio

[web2py] Re: An error in a SQLFORM.grid with multi-byte characters?

2012-01-19 Thread Martin Weissenboeck
Proposal (see issue 626): Try: >>> s = 'äöü€' >>> for i in range(10): ... print s[:i]+'...' ... ... �... ä... ä�... äö... äö�... äöü... äöü�... äöü��... äöü€... >>> for i in range(10): ... print s*.decode('utf-8')*[:i]*.encode('utf-8')*+'...'... ... ä... äö... äöü... äöü€... äöü€... äöü€... äöü

[web2py] Re: Problem with .smartgrid on tables with links

2012-01-19 Thread Massimo Di Pierro
Now I know where to look for the fix. :-) On Jan 19, 12:58 pm, Jim Steil wrote: > Yes, my tables are all similar to this: > > assetType = db.define_table('assetType', >              Field('assetTypeId', 'id'), >              Field('name', length=50, required=True, unique=True), >              for

[web2py] Re: Standalone DAL

2012-01-19 Thread Albert Abril
Ok, I found this. *oops* Thanks anyway ;) http://web2py.com/books/default/chapter/29/6#Using-DAL-without-define-tables 2012/1/19 Albert Abril > I know this was discussed before on the maillist, but i I can't find a > clair guide to make DAL working. > > Anyone can help me or give me a link to a

[web2py] Standalone DAL

2012-01-19 Thread Albert Abril
I know this was discussed before on the maillist, but i I can't find a clair guide to make DAL working. Anyone can help me or give me a link to a slice? I just want to use the web2py DAL on other python project. Thank you.

Re: [web2py] Re: Announcement

2012-01-19 Thread Richard Vézina
Thanks guys! Richard On Thu, Jan 19, 2012 at 9:30 AM, Cliff wrote: > Congratulations, Richard. > > All the best to your family. > > On Jan 19, 3:38 am, Gour wrote: > > On Wed, 18 Jan 2012 21:26:48 -0500 > > Richard Vézina > > > > wrote: > > > Hello Everybody, > > > > > I just would like to an

Re: [web2py] Re: Problem with .smartgrid on tables with links

2012-01-19 Thread Jim Steil
Yes, my tables are all similar to this: assetType = db.define_table('assetType', Field('assetTypeId', 'id'), Field('name', length=50, required=True, unique=True), format='%(name)s') -Jim On 1/19/2012 11:34 AM, Massimo Di Pierro wrote: Do the tables hav

[web2py] Re: sqlhtml unicode error

2012-01-19 Thread Alan Etkin
The text encoding is read from an email.message.Message created when the mail is fetched from the server and before sending the data to the base adapter parse function (by the way, I sent new versions of the adapter these days to the issue page after it was marked as fixed) In IMAPAdapter I am pas

[web2py] Re: Trouble with creating static file on the fly.

2012-01-19 Thread JoeCodeswell
Dear Anthony, Thanks for the tip. No I am able to create a file for download on the fly. Here's the final code. def make_dl(): import os myurl = URL('static', 'excel.txt') myfile = os.path.join(request.folder, 'static', 'excel.txt') f = open(myfile,'w') for i in range(20):

Re: [web2py] HOWTO: getting web2py to run on Android mobile devices

2012-01-19 Thread Vinicius Assef
Very nice. Really! On Thu, Jan 19, 2012 at 2:56 PM, fpp wrote: > > In response to a question in another thread, here is a summary of how > I got web2py running on my Android device (a Samsung Note), using > hints found here and there. > > Maybe it can save some time for those wanting to do the sa

[web2py] Re: Problem with .smartgrid on tables with links

2012-01-19 Thread Massimo Di Pierro
Do the tables have id fields called other than id? On Jan 19, 10:45 am, Jim Steil wrote: > Hi > > Just updated to the latest trunk this morning and now my smartgrids > aren't working where the table being used has links. > > Here is what I'm getting: > > Traceback(most recent call last): >    Fil

[web2py] HOWTO: getting web2py to run on Android mobile devices

2012-01-19 Thread fpp
In response to a question in another thread, here is a summary of how I got web2py running on my Android device (a Samsung Note), using hints found here and there. Maybe it can save some time for those wanting to do the same thing. Note : I am just getting started with Android, so there are prob

Re: [web2py] Re: SQLFORM.smartgrid query/search don't work for related tables

2012-01-19 Thread Jim Steil
Cliff - I was getting a bunch of stuff together this morning to show you what I'm doing, but when I updated to the latest trunk most of my smartgrids quit working. I will get a sample here for you once I get my installation working again. -Jim On 1/19/2012 8:34 AM, Cliff wrote: Jim, Gr

[web2py] Problem with .smartgrid on tables with links

2012-01-19 Thread Jim Steil
Hi Just updated to the latest trunk this morning and now my smartgrids aren't working where the table being used has links. Here is what I'm getting: Traceback(most recent call last): File"C:\dev\web2py\gluon\restricted.py",line204,inrestricted execccodeinenvironment File"C:/dev/web2p

[web2py] Re: DAL IMAPAdapter

2012-01-19 Thread LightDot
Sounds really good. I guess webmail application would also be an interesting web2py project. Eh, if work days had about 49 hours, I'd be on it right now...

[web2py] Re: Trouble with creating static file on the fly.

2012-01-19 Thread Anthony
On Thursday, January 19, 2012 11:12:53 AM UTC-5, JoeCodeswell wrote: > > Dear web2py folks, > > I am having trouble creating a static file on the fly. > > Here is the code in dnload_file/controllers/default.py. > > def make_dl(): > myurl = URL('static', 'excel.txt') > f = open(myurl,

Re: [web2py] Re: Implementing tornado chat server with web2py

2012-01-19 Thread Phyo Arkar
Websocket is not ready , it is just a draft protocol. i wont recommend any serious use on it. On Wed, Jan 18, 2012 at 6:57 AM, Abhishek Gupta < abhishekgupta.i...@gmail.com> wrote: > I implemented a similar solution, but the user keeps on getting > disconnected from the tornado server. This happe

[web2py] Trouble with creating static file on the fly.

2012-01-19 Thread JoeCodeswell
Dear web2py folks, I am having trouble creating a static file on the fly. Here is the code in dnload_file/controllers/default.py. def make_dl(): myurl = URL('static', 'excel.txt') f = open(myurl,'w') for i in range(20): f.write('This is a test %2s\n'%(i)) f.close() re

[web2py] Re: sqlhtml unicode error

2012-01-19 Thread Massimo Di Pierro
Is the page html header declaring the utf8 encoding or are using in a layout that uses a different encoding? On Jan 19, 7:21 am, Alan Etkin wrote: > I found that the Unicode errors are originated because of incompatible > encodings when web2py tries to read the raw message and render the > data f

[web2py] Re: login with blank password:problem

2012-01-19 Thread Massimo Di Pierro
This should absolutely not be the case. If this is a problem on the web2py side than it is a security issue and it needs to be fixed urgently. I am not convinced this is a web2py problem anyway. Can you show use the code you use to pre-fill the random password? On Jan 19, 6:27 am, Saurabh S wrote

[web2py] Re: bitcoin

2012-01-19 Thread Massimo Di Pierro
Not yet sorry. On Jan 19, 4:40 am, btcgriffin wrote: > I like to support web2py project with bitcoin (http://bitcoin.org/). Can I > send you this currency ? > btcgriffin

[web2py] Re: DAL IMAPAdapter

2012-01-19 Thread Alan Etkin
New features: - set.update() - set.delete() I also fixed Unicode problems on parsing the complete RFC822 message http://code.google.com/p/web2py/issues/detail?id=610#c5 On 17 ene, 13:05, Alan Etkin wrote: > The new version of the adapter with fixes and size queries > > http://code.google.com/p/

[web2py] Re: TYMR - web2py social network - Invitations for this community

2012-01-19 Thread Francisco Costa
Thanks all for the feedback! @Ovidio, the code is not available. @Marin, you shouldn't be able to not select a place to host events at the moment (that functionality is still in development). I've already corrected it. Thanks On Jan 18, 8:07 pm, Marin Pranjić wrote: > I tried to create an event

Re: [web2py] Re: SQLFORM.smartgrid query/search don't work for related tables

2012-01-19 Thread Adi
Even though users can navigate through a "parent" table's smartgrid to get to "children", it would be very valuable to filter "children" records based on a referenced ("parent") table criteria. Unfortunately, I'm not sure yet how to create my own search widget, but I saw a feature available..

[web2py] Re: Problem with DB2 and text field type when accessing db2 using ODBC ...

2012-01-19 Thread Omi Chiba
David, I'm successfully using DB2 for internal web app. We used to use i595: O/S V5R3M0 and now we use Power 770: O/S V7R1M0. Yes, it will be created as 'CLOB' and I don't have the problem. (See attachment). Model db.define_table('mytable', Field('mys

[web2py] Re: SQLFORM.smartgrid query/search don't work for related tables

2012-01-19 Thread Cliff
Jim, Grid has a parameter "searchwidget" Doesn't that point to a custom search widget? I would very much like to see your solution. On Jan 18, 10:20 pm, Jim Steil wrote: > Adnan > > I did not get this working, but that doesn't mean it has been resolved. > I've given up on the search that is in

[web2py] Re: Announcement

2012-01-19 Thread Cliff
Congratulations, Richard. All the best to your family. On Jan 19, 3:38 am, Gour wrote: > On Wed, 18 Jan 2012 21:26:48 -0500 > Richard Vézina > > wrote: > > Hello Everybody, > > > I just would like to announce that Mathilde is born the 8 of january. > > > I will be away from my computer a few mo

[web2py] bitcoin

2012-01-19 Thread btcgriffin
I like to support web2py project with bitcoin (http://bitcoin.org/). Can I send you this currency ? btcgriffin

[web2py] Integration with OpenID, Facebook

2012-01-19 Thread Web2Py Freak
Dear All, I am using the Integration with OpenID, Facebook from the book , now what i want to do is to get users images from facebook and anyother accounts that use to register , so any ideas ?

[web2py] Re: sqlhtml unicode error

2012-01-19 Thread Alan Etkin
I found that the Unicode errors are originated because of incompatible encodings when web2py tries to read the raw message and render the data for browser output. I solved it encoding the RFC822 raw text before parsing the response data as Rows. Still i am not sure if this is the correct way for pr

[web2py] Re: string not recognized

2012-01-19 Thread davidjensen
Thank you for the reply. I ran into the situation because I wanted to copy the raw wikipedia markup of a wikipedia page, which does use "{{". I had trouble copying the browser formatted page. Possibly, there could be a special tag for that. Since the view accepts Python code, there is probably a n

[web2py] login with blank password:problem

2012-01-19 Thread Saurabh S
Hi , i am developing an online booking system in web2py on GAE. The problem that i am facing is when i create an entity (client/ volunteer/employee) in my system , i store a random password in the db (auth_random_password()) and 'pending' in the registration key initially. but when i enable the lo

[web2py] Re: Postgres unknown reference field type

2012-01-19 Thread Simon Ashley
Fixed. +1 to Massimo although it wasn't this error, but one lower down in the list. First error was failure to add a 'requires' constraint to pair with the db.Client. Thanks, was too tired to spot these. On Jan 19, 1:58 pm, Massimo Di Pierro wrote: > from the error looks like you have > > Fiel

[web2py] Re: [off topic] Announcement

2012-01-19 Thread Gour
On Wed, 18 Jan 2012 21:26:48 -0500 Richard Vézina wrote: > Hello Everybody, > > I just would like to announce that Mathilde is born the 8 of january. > > I will be away from my computer a few more weeks... Congratulation and enjoy your fathership- ;) Sincerely, Gour -- As a strong wind swe

[web2py] Re: new book now available in HTML (english, japanese, italian)

2012-01-19 Thread Stefan Scholl
Stefan Scholl wrote: > Johann Spies wrote: >> [-- text/plain, encoding 7bit, charset: ISO-8859-1, 8 lines --] >> >> It is working for me. Perhaps you should try again. > > Nope, still gone. When I look at the response header I see it's a > 404 NOT FOUND. > > http://web2py.com/book/ instead of

[web2py] Re: Too many redirects when trying to use interactive demo

2012-01-19 Thread Gerd
Hi! I'm having problem with web2py.com/demo_admin. Tried it on a Windows XP SP3 with FF 9.0.1 and IE 8 regards Gerd