[web2py] error with uploadfield and blob

2010-11-08 Thread richard.ree
I want to upload a file and store it in a blob field: db.define_table( "data", Field("citation", "string", required=True, notnull=True), Field("datafile", "upload", uploadfield="data"), Field("data", "blob"), ) But if I insert a record (through SQLFORM or admin) but leave the

[web2py] Re: error with uploadfield and blob

2010-11-10 Thread richard.ree
Not long at all. Many thanks! On Nov 10, 8:51 am, mdipierro wrote: > bug. Fixed in trunk. Sorry it took so long. > > On Nov 8, 10:38 pm, "richard.ree" wrote: > > > I want to upload a file and store it in a blob field: > > > db.define_table( > >  

[web2py:32917] Re: Error with Database (MySQL) when using latest release....

2009-10-14 Thread richard.ree
The sql that fails is: CREATE TABLE expedition( id INT AUTO_INCREMENT NOT NULL, name VARCHAR(512) UNIQUE, from_date DATE, to_date DATE, description LONGTEXT, PRIMARY KEY(id) ) ENGINE=InnoDB CHARACTER SET utf8; The table definition is: db.define_ta

[web2py:32927] Re: Error with Database (MySQL) when using latest release....

2009-10-14 Thread richard.ree
No error if unique=False. The problem seems to be with the VARCHAR (512) UNIQUE. -Rick On Oct 14, 6:29 pm, mdipierro wrote: > Do you have the error if unique=False? > > Massimo > > On Oct 14, 5:25 pm, "richard.ree" wrote: > > > The sql that fails

[web2py:13812] close popup window on successful SQLFORM submit?

2008-12-18 Thread richard.ree
Can anyone suggest how I can close a popup window that shows a SQLFORM, after a successful form.accepts()? Thanks in advance, -Rick --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To po

[web2py:14538] Re: Suggestion for web2py hosting

2009-01-04 Thread richard.ree
I followed the instructions, but am still having trouble. I can't seem to get the dispatch.fcgi rewrite rules in .htaccess to work properly. I have a shell account on dreamhost with web content served from ~/ www, which is visible as www.mydomain.net/myusername. I'd like to set up web2py such t

[web2py:14652] web2py on dreamhost shell account?

2009-01-06 Thread richard.ree
Anyone running web2py on dreamhost? I folllowed the instructions at http://wiki.dreamhost.com/Web2py but couldn't figure out how to adapt them to my case. I have a shell account but not a WebID so I have no access to the control panel. In my home directory, web content is served from ~/www, whi

[web2py:14690] Re: web2py on dreamhost shell account?

2009-01-07 Thread richard.ree
python2.5 (1st line in dispatch.fcgi) because dreamhost's default > `python` points to python 2.4.4 > -tim > richard.ree wrote:Anyone running web2py on dreamhost? I folllowed the > instructions athttp://wiki.dreamhost.com/Web2pybut couldn't figure out how to > adap

[web2py:14694] Re: web2py on dreamhost shell account?

2009-01-07 Thread richard.ree
Let me know if we need to fiddle some more. > -tim > richard.ree wrote:I followed your steps but got the following errors. 1. The > .htaccess file causes this snippet of html to be returned for all requests: > Error 2. When I run dispatch.fcgi unmodified, it > bails wi

[web2py:14977] Re: web2py on dreamhost shell account?

2009-01-14 Thread richard.ree
, "richard.ree" wrote: > The permissions checked out, but I still get the same error html > snippet.  The problem seems to be with the last line in .htacces: > > RewriteRule ^(.*)$ dispatch.fcgi/$1 [L] > > If I comment it out, I get the directory index where dispatch.fcgi &g

[web2py] Re: plugin_matplotlib

2010-11-14 Thread richard.ree
matplotlib recently added an HTML5 backend: http://code.google.com/p/mplh5canvas/ It supports interactive plots using something called websockets. I've been wondering if it would be possible to implement an interactive plot widget for plugin_wiki. I use matplotlib a lot, both for interactive de

[web2py] bug? SQLTABLE with null values for reference fields

2010-11-19 Thread richard.ree
db.define_table("a", Field("name")) db.define_table("b", Field("a", db.a)) In appadmin, insert some records in db.a, then insert a record in db.b, leaving the 'a' field empty. Rendering db(db.b.id>0).select() as a SQLTABLE raises RuntimeError: Using a recursive select but encountered a broken re

[web2py] Re: bug? SQLTABLE with null values for reference fields

2010-11-20 Thread richard.ree
I see. I guess I just assumed that a validator like IS_NULL_OR(IS_IN_DB(db, db.other.id)) would be assigned by default to reference fields, since null values are allowed by default in other types of fields. Thanks, -Rick