[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

[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.id0).select() as a SQLTABLE raises RuntimeError: Using a recursive select but encountered a broken reference

[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 mdipie...@cs.depaul.edu wrote: bug. Fixed in trunk. Sorry it took so long. On Nov 8, 10:38 pm, richard.ree richard.h@gmail.com wrote: I want to upload a file and store it in a blob field: db.define_table(     data

[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 datafile field

[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:

[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 mdipie...@cs.depaul.edu wrote: Do you have the error if unique=False? Massimo On Oct 14, 5:25 pm, richard.ree richard.h@gmail.com wrote: The sql that fails

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

2009-01-14 Thread richard.ree
, richard.ree richard.h@gmail.com 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 and .htaccess

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

2009-01-07 Thread richard.ree
) 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 adapt them to my case. I have a shell account but not a WebID so I have

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

2009-01-07 Thread richard.ree
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: htmlbodyError/body/html 2. When I run dispatch.fcgi unmodified, it bails with ImportError: No module named fcgi

[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,

[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