Nowhere in this thread is the word "risk" used. Bottom line, there's
probably a reluctance to bet on web2py when it's not a known quantity
in an application with the stated demands. Most people are risk
adverse because they don't want to get beat about the head and
shoulders if something turns ou
FYI, something to consider is that SQLite doesn't natively support
foreign key constraints. For example, ON DELETE CASCADE doesn't
work. It is possible to write triggers to handle referential
integrity, but a dbms like postgresql just does it. So, depending on
your requirements, postgresql migh
Yes, right again. Quoting around the path placeholder does allow
specifying a "long" format path including with spaces.
Thanks again.
On Aug 27, 12:26 pm, Yarko Tymciurak wrote:
> On Thu, Aug 27, 2009 at 9:16 AM, ctalley wrote:
>
> > Thanks guys. Yarko, you are nothing
Thanks guys. Yarko, you are nothing if not prolific - all I ever
wanted to know and more. :-)
I just felt like there must be some mechanism to tell python where to
find files from the command prompt short of typing the entire path and
that I was missing something. I didn't really think pythonpa
This is probably off topic, but here goes...
I can't run "python web2py.py --upgrade yes" from any directory except
the directory containing web2py.py
I get this error => python: can't open file 'web2py.py': [Errno 2] No
such file or directory
I've added the web2py.py path to the Windows PATH s
I followed Massimo's advice and replaced appadmin.py and appadmin.html
with the most recent version and that seems to have fixed it. Thanks.
On Aug 25, 10:48 am, Jonathan Lundell wrote:
> On Aug 25, 2009, at 1:45 AM, mdipierro wrote:
>
>
>
>
>
>
>
> > There are two issues here:
>
> > 1) cgi.Fie
reviously on this list. Which version of 2.6? 2.6.1
> or 2.6.2?
>
> Massimo
>
> On Aug 24, 2:04 pm, ctalley wrote:
>
>
>
> > using web2py version 1.66.0 source
> > and python 2.6
>
> > from this page...http://127.0.0.1:8000/mydb/appadmin/index
>
> &
using web2py version 1.66.0 source
and python 2.6
from this page...
http://127.0.0.1:8000/mydb/appadmin/index
click a table link such as db.mytable
lists query => db.mytable.id>0, and rows in table -- all is well :-)
now, still on the same page, click Submit; should just reload the page
with t
cute them) - but it is not in your path;
>
> You either need to type the path to your python executable (on windows, the
> default would be something like c:/python/python.exe) or add it to your
> path variable - then try the import statement from the python prompt...
>
b2py.exe then?
>
>
>
> On Mon, Aug 17, 2009 at 11:37 AM, ctalley wrote:
>
> > from the command prompt...
>
> > C:\>python
> > 'python' is not recognized as an internal or external command,
> > operable program or batch file.
>
> > On A
.2
> Type "help", "copyright", "credits" or "license" for more information.
>
>
>
> >>> import psycopg2
> >>> dir('psycopg2')
> On Mon, Aug 17, 2009 at 10:57 AM, ctalley wrote:
>
> > I've been using SQ
I've been using SQLite and am trying to migrate to PostgreSQL.
I'm getting this error immediately when starting my application...
NameError: global name 'psycopg2' is not defined
...on this configuration...
operating system: Windows XP
web2py: version 1.66.0 source
python: version 2.6.2 Window
Just for another data point, recurring problem for me too.
XP, IE7
On Jul 15, 12:49 am, Yarko Tymciurak wrote:
> On Tue, Jul 14, 2009 at 11:44 PM, Yarko Tymciurak wrote:
>
> > On Tue, Jul 14, 2009 at 11:33 PM, Arch wrote:
>
> >> I was using Google Chrome when I was having the problem.
>
> >>
g','sqlite')))
>
> why are you doing this again?
>
> On Apr 5, 7:17 pm, ctalley wrote:
>
>
>
> > Just getting back to this after a week.
>
> > Massimo, the syntax you provided for the case indicated does indeed
> > work. Thanks. Now I'm
too, like one sanitize() at the end with multiple
arguments. Also, no luck.
Any assistance is appreciated.
On Mar 30, 10:03 am, mdipierro wrote:
> On Mar 30, 8:51 am, ctalley wrote:
>
> > Is it possible to use a session variable as a parameter in a SQL
> > "WHERE" clause? S
Is it possible to use a session variable as a parameter in a SQL
"WHERE" clause? See example below.
#assign value to session variable
session.mysession = ...
#use session variable in web2py DAL query
#*this works*
rows=db(db.table.column==session.mysession).select(...)
#use session variable in
th the names of all my tables?
On Mar 22, 5:22 pm, mdipierro wrote:
> On Mar 22, 3:09 pm, ctalley wrote:
>
> > 1. There doesn't seem to be any provision for setting password policy
> > (length, character mix) and enforcing it at the time a user
> > registers. As cur
No doubt this is off topic ... I'm pretty sure it's an issue with
sqlite not web2py. But maybe someone's run into it before so I guess
it doesn't hurt to ask.
I'm using sqlite bundled with web2py. I have a "Team" table (each
record has name, phone, e-mail, ...), and a "DocReview" table with
thr
Registration (http:///[app]/default/user/register) behaves
differently depending on whether a user is logged in or not logged in.
If logged in: a prepopulated form with first name, last name, and e-
mail of the logged-in user.
If not logged in: an empty form with first name, last name, e-mai
1. There doesn't seem to be any provision for setting password policy
(length, character mix) and enforcing it at the time a user
registers. As currently implemented, a user can enter anything - or
nothing - for a password. Something as simple as IS_NOT_EMPTY and a
minimum length would help a lo
oller. The resulting URL combined the two and
therefore made no sense.
On Mar 1, 9:51 pm, Yarko Tymciurak wrote:
> On Sun, Mar 1, 2009 at 3:15 PM, ctalley wrote:
>
> > Is it possible to do this...
>
> > go to xyz page
>
> > ...which yields this URL...
>
> &g
Is it possible to do this...
go to xyz page
...which yields this URL...
http://127.0.0.1:8000/admin/default/design/myapp
...using an HTML helper, like this...
{{=A('go to xyz page',_href=URL(r=request,f='/admin/default/design/
myapp'))}}
...which yields this URL...
http://127.0.0.1:8000/cur
I'm sure all the tools mentioned (Trac, web2py, Sphinx) have certain
advantages and disadvantages, and I don't claim to know what they all
are, but a strong argument for Sphinx is that it is what
docs.python.org uses. Of course the downside might be the learning
curve if nobody's ever used it.
That worked (with index [0]).
Now I can populate a drop down list in a FORM (vs. SQLFORM) from data
in a database. Not sure if this is the 'best' way to do it, but it
works.
rows=db(db.colortable.color!=None).select() #query the database
optionlist=[str(c[0]) for c in rows.response] #convert q
Given these statements...
rows=db(db.colortable.color!=None).select()
print rows
...that return something like this...
colortable.color
red
green
blue
How can 'rows' (a SQLRows object) be converted to a list like this...
colorlist=['red','green','blue']
...such that 'print colorlist' would prod
select
> (db.InfoSys.ISName, db.Assessment.ALL)
> requites=IS_IN_SET([r.InfoSys.id for r in rows],["%s %s %s" %
> (r.InfoSys.ISName, r.Assessment.AssessmentStartDate, r.
> Assessment.Assessment.DateEnd) for r in row])
>
> It is not that different. The only difference is that depending on
&g
Based on this partial model...
db.define_table('InfoSys',
SQLField('ISName', 'string'),
SQLField('ISAbbrev', 'string'),
SQLField('ISType_id', db.ISType),
SQLField('AppQuarter_id', db.AppQuarter),
SQLField('ISOwnerType_id', db.ISOwnerType))
db.define_table('Assessment',
SQ
27 matches
Mail list logo
