Hello all,
New guy here... I've been looking all over the web for something that
meets all the needs of a couple projects I want to do, and it looks like
web2py will just about cover them!
I'm getting my feet wet with the examples, and got sidetracked ;) by the
gae sql designer - holy cow that thing is sweet, not too complicated,
just right! I was noticing that it seems to use the old DAL language of
'SQLField' instead of 'Field' for the table definitions... is there an
update or change in the works for that?
Also... maybe my understanding of foreign keys as used in web2py (or at
least the gae sql designer) is not up to snuff... it seems like this:
dbOBJECT.tbl_phone_numbers.id_tbl_members.requires=IS_IN_DB(dbOBJECT,
'tbl_members.id','tbl_members.title','tbl_members.first_name',
'tbl_members.mid_init','tbl_members.last_name','tbl_members.suffix',
'tbl_members.street1','tbl_members.street2','tbl_members.city','tbl_members.state',
'tbl_members.post_code','tbl_members.country','tbl_members.gender','tbl_members.nra_id')
should be just:
dbOBJECT.tbl_phone_numbers.id_tbl_members.requires=IS_IN_DB(dbOBJECT,'tbl_members.id')
since I'm just wanting to tie those two fields together, not the one
field to the whole other table... yes/no/maybe?
TIA,
Monte
