[web2py] Re: Support for MS Access?

2014-10-20 Thread ksotiris
finally the solution is in this site: http://linuxapuntes.blogspot.gr/2013/01/ms-access-desde-ubuntu-con-python-and.html step 1 (install lib) : sudo apt-get install mdbtools libmdbodbc1 pyodbc step 2 create a template file and use the odbcinst -i -d -f templatefile to add this to

[web2py] We could have something like this

2014-10-20 Thread António Ramos
http://meteorhelp.com/ -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups

[web2py] Is it sensible to generate images on the fly/use a base64 string as image source?

2014-10-20 Thread Spokes
For reasons of which I'm not totally sure, I was unable to use web2py's download function with a particular table's upload field https://groups.google.com/forum/#!topic/web2py/u60oQK-7EbM. Consequently, I hacked my way around it by doing something like this: def return_image_as_string(db,

[web2py] Re: Is it sensible to generate images on the fly/use a base64 string as image source?

2014-10-20 Thread Leonel Câmara
This is pretty inefficient, I still think your original code was failing due to the table not being defined. Specifically response.download does this: items = re.compile('(?Ptable.*?)\.(?Pfield.*?)\..*').match(name) if not items: raise HTTP(404) (t, f) =

[web2py] Re: Is it sensible to generate images on the fly/use a base64 string as image source?

2014-10-20 Thread Spokes
I still think your original code was failing due to the table not being defined I put a print statement in the 'download' function to check that the db instance being passed to that function contains the required table, and it did seem to confirm that the table was there. Specifically, I

[web2py] web2pyslices

2014-10-20 Thread Carlos Cesar Caballero Díaz
Hi, I am trying to upload a plugin (for images thumbnails creation) to web2pyslices, but I uploaded it 6 days ago, and there is no errors, no notifications, and the only trace of my plugin is in activities, but if I click on it, sends me to the web2pyslices home page. It is normal, o there is

[web2py] Re: float field search and grid/smartgrid

2014-10-20 Thread Mirko
Have this issue also with Linux(Ubuntu). On Saturday, October 18, 2014 8:17:59 PM UTC+2, Mirko wrote: Up... Anybody else had this issue ? Thanks, -Mirko On Friday, October 17, 2014 8:44:41 AM UTC+2, Mirko wrote: Hi all, maybe I should elaborate a little bit more: here's my model:

[web2py] Re: Support for MS Access?

2014-10-20 Thread ksotiris
I found 2 errors: when using db.(db.table).select() i get the following sql query : sql=SELECT tablename.fieldname1,tablename.fieldname2, ...FROM tablename WHERE tablename.fieldname1 IS NOT NULL fieldname1 : the primary key, i think that's why .. is not null errors : db.executesql crashes

[web2py] Re: float field search and grid/smartgrid

2014-10-20 Thread Mirko
Found it, 'float' is not a field type, I should have used 'double'. Nevertheless 'float' is accepted as field type in table definitions (shouldn't be) and is not displayed in search forms. hth -Mirko On Monday, October 20, 2014 3:21:21 PM UTC+2, Mirko wrote: Have this issue also with

[web2py] Re: Is it sensible to generate images on the fly/use a base64 string as image source?

2014-10-20 Thread Leonel Câmara
Ok you need to fix 2 things in your app, one of them shows I was right about the table definition problem: First, in create_image() change: image = IMG(_src = URL('default', 'download', record.user_image), _style = 'height:200px;width:200px') Into this: image = IMG(_src = URL('default',

[web2py] Re: Is it sensible to generate images on the fly/use a base64 string as image source?

2014-10-20 Thread Spokes
Indeed, you're right - the combination of the two changes solved the problem. I thought that I had tried this previously, but perhaps I had tried one or the other change, without doing both. Thank you! Still, isn't it possible to pretty much do away with modules without compromising

[web2py] Re: Is it sensible to generate images on the fly/use a base64 string as image source?

2014-10-20 Thread Leonel Câmara
It isn't as necessary as it used to be to move models into modules because of lazy tables and the fact that you can run models conditionally now. Either way I think that's usually a premature optimization. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) -

[web2py] Re: Is it sensible to generate images on the fly/use a base64 string as image source?

2014-10-20 Thread Spokes
Thanks - will keep this in mind. On Monday, October 20, 2014 11:23:01 AM UTC-5, Leonel Câmara wrote: It isn't as necessary as it used to be to move models into modules because of lazy tables and the fact that you can run models conditionally now. Either way I think that's usually a

[web2py] Re: Support for MS Access?

2014-10-20 Thread Willoughby
Remember SQL used by Access isn't the same as ANSI SQL - and compatibility varies by Access version. I think you'd run into this a lot... On Monday, October 20, 2014 10:24:48 AM UTC-4, ksotiris wrote: I found 2 errors: when using db.(db.table).select() i get the following sql query :

[web2py] Re: Support for MS Access?

2014-10-20 Thread Leonel Câmara
This is weird because according to the docs, access does support the tablename.fieldname syntax http://msdn.microsoft.com/en-us/library/bb208930(v=office.12).aspx Either way, just convert your access database to anything else, it's bound to be better for your sanity. Seriously, any time spent

[web2py] unittest with multiple test files

2014-10-20 Thread David Ripplinger
Hi, I'm using unittest in my app as suggested here http://www.web2py.com/AlterEgo/default/show/260, but I don't want all my tests to be in one file. As far as I can tell, my options are: 1. Bite the bullet and put all tests in one file. 2. Run each test file separately and have a shell

[web2py] Re: We could have something like this

2014-10-20 Thread Derek
Is that a question? Are you asking if you can build a site like that? I don't see why not. In fact, instantpress almost meets your needs, though you might want to customize the theme a bit. On Monday, October 20, 2014 3:12:29 AM UTC-7, Ramos wrote: http://meteorhelp.com/ -- Resources: -

Re: [web2py] Re: We could have something like this

2014-10-20 Thread António Ramos
it was not a question. we know everything is possible. Its just that finding info about web2py are sometimes dificult A site like this could help and also rate the source of info. Regards 2014-10-20 22:37 GMT+01:00 Derek sp1d...@gmail.com: Is that a question? Are you asking if you can build

Re: [web2py] Re: We could have something like this

2014-10-20 Thread Derek
here you go http://www.reddit.com/r/web2py On Monday, October 20, 2014 2:41:26 PM UTC-7, Ramos wrote: it was not a question. we know everything is possible. Its just that finding info about web2py are sometimes dificult A site like this could help and also rate the source of info.

Re: [web2py] Re: We could have something like this

2014-10-20 Thread Dave S
On Monday, October 20, 2014 2:41:26 PM UTC-7, Ramos wrote: it was not a question. we know everything is possible. Its just that finding info about web2py are sometimes dificult A site like this could help and also rate the source of info. In what way do you see it as being different

[web2py] Re: SAML2 Service Provider app in web2py?

2014-10-20 Thread Prasad Muley
Hi Massimo, Could you reply on my query? On Friday, August 22, 2014 7:26:31 AM UTC+5:30, Massimo Di Pierro wrote: Incidentally, I just committed an experimental SAML2 login method for Web2py. Please contact me privately and perhaps you can help me test it. Massimo On Thursday, 21

[web2py] did I structure my table and table reference wrong?

2014-10-20 Thread LoveWeb2py
Hi... I'm trying to create a grading system where I can reference the questions_answered with the questions id. I want to be able to load all of the questions from the first table and and see whether or not the student got them right in the second. If the student got them right I actually only