[web2py:26014] IS_IN_DB for multiple tables

hi, i am having about 8 different lookup tables in my database. i need to validate whether the entry is in any one of the 8 tables. Thanks. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" gr

[web2py:26019] Re: IS_IN_DB for multiple tables

only need to validate. On Jul 8, 11:03 pm, mdipierro wrote: > only validate or you need a selection dropdown? You need your own > validator. Look into the code for IS_IN_DB and it is not difficult to > make your own. > > On Jul 8, 11:53 pm, phneoix wrote: > > > hi, &g

[web2py:27141] temporary table

how do i create temporary table thanks --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to

[web2py:27542] Re: temporary table

thanks for the replies. sorry for the delay in replying. i am having 8 different lookup tables which contains the master list of all the materials.(endmills, gauging instruments, drills,tooling systems, etc).these contain the material name and respective product id's. there is another table whi

[web2py:27600] Re: temporary table

thanks for the suggestion this is what iam trying to achieve db (db.material_issue.product_id==created_temporary_table.product_id).select (db.material_issue.product_id,created_temporary_table.name,db.material_issue.issued_qty) On Jul 29, 11:21 am, Fran wrote: > On Jul 29, 3:14 pm, phne

[web2py:17703] any method to control column access

hi, i would like to know to know whether it is possibe to control the column access for users. i am having multiple users accessing the same table where i need to control the column access individually for each user and generate the forms automatically based on the column priviliges. is there any

[web2py:18023] any good examples of auth and crud implementations

hi, i would like to know whether there are any good examples using auth and crud. iam struggling with crud quite a bit. thanks --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post t

[web2py:18060] Re: any method to control column access

somefield" mean > > > db.sometable.somefield.writable=auth.has_permission > > > ("edit_somefield",db.sometable) > > > > Hope this helps. I wish I had time to document this better. Hopefully > > > in a couple of weeks. > > > > Mas

[web2py:18063] Re: any method to control column access

i have set permissions for individual fields and implemented them successfully using SQLFORM(db.sometable, writable=True) but if i want to create a custom form it does not work. eg: SQLFORM(db.sometable,fields= ['somef1','somef2','somef3'],writable=True) #somef3 is denied access is there a way o

[web2py:18070] Re: any method to control column access

=True or False > > just before you call SQLFROM > > On Mar 15, 6:05 am, phneoix wrote: > > > > > i have set permissions for individual fields and implemented them > > successfully using > > SQLFORM(db.sometable, writable=True) > > > but if i want to c

[web2py:18071] Re: any method to control column access

CORRECTION somefield1 and somefield2 have create permission. while ***somefield3*** has been denied access by me. On Mar 15, 9:06 pm, phneoix wrote: > SORRY put my question in wrong way. > > somefield1 and somefield2 have create permission. while somefield has > been denied

[web2py:18444] store multiple records in storage and commit all at once

hi, i would like to know whether it is possible to store multiple records in storage and commit them all at once to the table. if not is there any other way. thanks --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "

[web2py:18986] set id of table tags

how to get an output from SQLTABLE or crud.select in the following way. . thanks --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@g

[web2py:18989] Re: set id of table tags

thanks On Apr 2, 10:22 pm, Kacper Krupa wrote: > SQLFORM(db.table, row, ..., _id="foo") > > On Apr 2, 7:06 pm, phneoix wrote: > > > how to get an output from SQLTABLE or crud.select in the following > > w