Thank you that works beautifully.
(Sorry, only skimmed the crud chapter , and the info regarding custom
forms is in there.)
One more thing though:
if I omit some widget fields from the HTML form,
(in this case, a reference field to another table),
form.accepts fails like it has null values, eve
I too have tried this without success.
I seems that you cannot use a custom form together with SQLFORM with
record=
Is that true?
Paul
On Apr 9, 6:14 am, JmiXIII wrote:
> Hello,
>
> I'm using a SQLFORM with a html custom (as described in book/7.2 =>
> SQLFORM in HTML)
> My fonction inside my c
When using the packaged web2py distribution, is thare a way to use
assert statements for development, then switch them off for production
use?
Not knowing the details of how .pyo files are used, I tested this by
inserting an 'assert 1==2' and compiling that controller file with -
O, but the optim
Hello
I would like to make some administative build/test tasks for a web2py
application available via the web interface, with the output presented
to the html page in real time, like console output.
The code below seems to work reasonably well, but is this sort of
thing recommended/safe? Is there
uestion)
result = db(db.question.id.belongs(thatQ)).select(db.question.ALL)
I guess none of these would work on GAE though, would they?
Paul
On Apr 12, 10:40 am, Paul Wray wrote:
> Thank you Massimo
>
> I didnt know about the chained queries like this ie db(q1)(q2) .
> Is this feature documented
dipierro wrote:
> I would do
>
> db(db.question.id.belongs(db(db.keyword.keyword=='this'))._select(db.keyword.question))
> (db.question.id.belongs(db(db.keyword.keyword=='that'))._select(db.keyword.question)).select(db.problem.ALL)
>
> It will be faster.
&g
dipierro wrote:
> I would do
>
> db(db.question.id.belongs(db(db.keyword.keyword=='this'))._select(db.keyword.question))
> (db.question.id.belongs(db(db.keyword.keyword=='that'))._select(db.keyword.question)).select(db.problem.ALL)
>
> It will be faster.
&g
l
On Apr 9, 1:40 pm, mdipierro wrote:
> Inner joins in DAL do not support AS. Can you show an SQL example of
> how you would use it?
>
> Massimo
>
> On Apr 8, 10:08 pm, Paul Wray wrote:
>
> > Hello
>
> > I'm attempting a simple self join and having trouble
Hello
I'm attempting a simple self join and having trouble with the aliases.
The slightly simplified query is:
k1 = db.qkeyword.with_alias('k1')
k1 = db.qkeyword.with_alias('k2')
print db( (k1.keyword == 'this')
& (k2.keyword == 'that')
& (k1.question == k2.question)
& (
9 matches
Mail list logo
