[web2py] DAL: basic join question

I have a table called pics and a table called picnotes, where the definitions are like db.define_table("pics", Field(...)) db.define_table("picnotes", Field("about", 'reference pics', Field("note", "string")) And I want to extract all rows of pics that have a note referring to them (this is a

[web2py] Re: Server Deployement issue

On Tuesday, October 25, 2022 at 10:57:55 PM UTC-7 silvia...@gmail.com wrote: > Hey snide, > > do you mind helping me setting it up in an ngnix enviromenet I would also > pay you somthing for your time > > Pay sounds good to me, but I'm not sure you'd get your money's worth. It's been a while

[web2py] Re: DAL: basic join question

Can you try vrows = db(db.picsntoes.id > 0 ).select(db.pics.ALL, db.picnotes.ALL, left=db.pics.on(db.pics.id == db.picnotes.about)) instead of vrows = db(db.pics.id == db.picnotes.about).select(db.pics.on(db.pics.id == db.picnotes.about)) If that doesn't work, can you share

[web2py] Re: Server Deployement issue

Yeah the book example is the issue I tried it with apache with the script after the script ran trough I run in an issue that my apache does not work anymore I dont know If I need to maybe change some things in the config file the ngnix setup I will try out today and see how that works Kind Rega