Re: [web2py] display items only entered by a logged in user in a dropdown menu of a reference table

2020-07-20 Thread villas 
>> Please advise how to create multiple rows insert by usung SQL form .

You have to create a form with multiple rows and then loop through multiple 
records when the form is accepted.

To give you a better idea,  here is a snippet from some code I used in the 
distant past. It updates multiple records from a custom form. You could 
also use this same technique using update_or_insert 
.
 
I hope you can figure it out.

 controller -- 
myrecords=db(query).select(db.table.ALL) 
if form.accepts ... 
for r in myrecords: 
if request.vars.has_key('id%i_price' % r.table.id): 
r.table.update_record(price=request.vars['id%i_price'% 
r.table.id]) 

- view -- 
 
{{for record in myrecords:}} 
   
{{=record.carprice.id}} 
 
   
{{pass}} 
... 

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/2d772d6e-7de6-4a01-bc5a-72d389f01d3eo%40googlegroups.com.

Re: [web2py] display items only entered by a logged in user in a dropdown menu of a reference table

2020-07-19 Thread AGRogers 
I'm not sure that is possible Sanka. At least I have not read it in the
book nor seen it referenced by anyone.

I expect you have to write a custom form and handle it manually. But web2py
can still help with those tasks.

On Mon, 20 Jul 2020, 12:45 pm Sanka kanaka krupakar, 
wrote:

> Dear group members
>
> Please advise how to create multiple rows insert by usung SQL form .
>
> On Mon 20 Jul, 2020, 05:37 AGRogers,  wrote:
>
>> Great. It's a cool feature.
>>
>> You would have read that you can turn it off in code temporarily just by
>> setting common_filter =none.
>>
>> That has caught me a few times.
>>
>> On Sun, 19 Jul 2020, 11:06 pm mostwanted,  wrote:
>>
>>> Hey AGRogers, thanks for that suggestion, I added the highlited lines to
>>> my model code & it gave results, thank you very much:
>>>
>>>
>>> db.define_table('lecturer',
>>> Field('surname'),
>>> Field('name'),
>>> Field('title'),
>>> Field('posted_by', 'reference auth_user', default=auth.
>>> user_id, readable=False, writable=False),
>>> *common_filter = lambda query: db.lecturer.posted_by ==
>>> auth.user_id,*
>>> format="%(surname)s %(name)s %(title)s")
>>> def lecturer(details): return '%(surname)s %(name)s' % details
>>>
>>> db.define_table('subject',
>>> Field('subject_name'),
>>> Field('posted_by', 'reference auth_user', default=auth.
>>> user_id, readable=False, writable=False),
>>> *common_filter = lambda query: db.subject.posted_by ==
>>> auth.user_id,*
>>> format="%(subject_name)s"
>>>)
>>> db.define_table('departments',
>>> Field('department_name'),
>>> Field('posted_by', 'reference auth_user', default=auth.
>>> user_id, readable=False, writable=False),
>>> *common_filter = lambda query: db.departments.posted_by
>>> == auth.user_id,*
>>> format="%(department_name)s")
>>>
>>> db.define_table('lecture',
>>>
>>> *Field('subject_name', 'reference subject'),
>>> Field('department', 'reference departments'),* #HERE
>>> Field('theLevels', label=SPAN('Levels'), requires=
>>> IS_IN_SET(['1.1', '1.2', '2.1', '2.2', '3.1', '3.2', '4.1', '4.2'], zero
>>> ='---Select A Level---')), #HERE
>>> *Field('lecturer', 'reference lecturer'),*
>>> Field('class_session', requires=IS_IN_SET(['single
>>> session', 'double session', 'evening single session', 'evening double
>>> session'], zero='Select A Session Period')),
>>> Field('the_time2', readable=False, writable=False),
>>> Field('class_room', requires=IS_IN_SET(['500', '501',
>>> '502', '503', '504', '505', '506'], zero='---Select A Class Room---')),
>>> Field('controller', readable=False, writable=False),
>>> Field('posted_by', 'reference auth_user', default=auth.
>>> user_id, readable=False, writable=False))
>>>
>>> Regards;
>>>
>>> Mostwanted
>>>
>>> On Sunday, July 19, 2020 at 1:13:06 PM UTC+2, AGRogers wrote:

 I would try using a common_filter on the drop down list table. Could
 that work?

 On Sun, 19 Jul 2020, 6:10 pm mostwanted,  wrote:

> In my application I have 4 tables, 3 of them referenced in the fourth
> table but every user should be able to view only what they have entered
> into the database. Is there a way that in a dropdown list of a referenced
> table in an SQLFORM users can only view & select from items they have
> entered?
>
> *MODELS CODE:*
> db.define_table('lecturer',
> Field('surname'),
> Field('name'),
> Field('title'),
> Field('posted_by', 'reference auth_user', default=auth
> .user_id, readable=False, writable=False), #HERE
> format="%(surname)s %(name)s %(title)s")
> def lecturer(details): return '%(surname)s %(name)s' % details
>
> db.define_table('subject',
> Field('subject_name'),
> Field('posted_by', 'reference auth_user', default=auth
> .user_id, readable=False, writable=False), #HERE
> format="%(subject_name)s"
>)
> db.define_table('departments',
> Field('department_name'),
> Field('posted_by', 'reference auth_user', default=auth
> .user_id, readable=False, writable=False), #HERE
> format="%(department_name)s")
>
> db.define_table('lecture',
>
> *Field('subject_name', 'reference subject'),
> Field('department', 'reference departments'),* #HERE
> Field('theLevels', label=SPAN('Levels'), requires=
> IS_IN_SET(['1.1', '1.2', '2.1', '2.2', '3.1', '3.2', '4.1', '4.2'],
> zero='---Select A Level---')), #HERE
> *Field('lecturer', 'refer

Re: [web2py] display items only entered by a logged in user in a dropdown menu of a reference table

2020-07-19 Thread Sanka kanaka krupakar 
Dear group members

Please advise how to create multiple rows insert by usung SQL form .

On Mon 20 Jul, 2020, 05:37 AGRogers,  wrote:

> Great. It's a cool feature.
>
> You would have read that you can turn it off in code temporarily just by
> setting common_filter =none.
>
> That has caught me a few times.
>
> On Sun, 19 Jul 2020, 11:06 pm mostwanted,  wrote:
>
>> Hey AGRogers, thanks for that suggestion, I added the highlited lines to
>> my model code & it gave results, thank you very much:
>>
>>
>> db.define_table('lecturer',
>> Field('surname'),
>> Field('name'),
>> Field('title'),
>> Field('posted_by', 'reference auth_user', default=auth.
>> user_id, readable=False, writable=False),
>> *common_filter = lambda query: db.lecturer.posted_by ==
>> auth.user_id,*
>> format="%(surname)s %(name)s %(title)s")
>> def lecturer(details): return '%(surname)s %(name)s' % details
>>
>> db.define_table('subject',
>> Field('subject_name'),
>> Field('posted_by', 'reference auth_user', default=auth.
>> user_id, readable=False, writable=False),
>> *common_filter = lambda query: db.subject.posted_by ==
>> auth.user_id,*
>> format="%(subject_name)s"
>>)
>> db.define_table('departments',
>> Field('department_name'),
>> Field('posted_by', 'reference auth_user', default=auth.
>> user_id, readable=False, writable=False),
>> *common_filter = lambda query: db.departments.posted_by
>> == auth.user_id,*
>> format="%(department_name)s")
>>
>> db.define_table('lecture',
>>
>> *Field('subject_name', 'reference subject'),
>> Field('department', 'reference departments'),* #HERE
>> Field('theLevels', label=SPAN('Levels'), requires=
>> IS_IN_SET(['1.1', '1.2', '2.1', '2.2', '3.1', '3.2', '4.1', '4.2'], 
>> zero='---Select
>> A Level---')), #HERE
>> *Field('lecturer', 'reference lecturer'),*
>> Field('class_session', requires=IS_IN_SET(['single
>> session', 'double session', 'evening single session', 'evening double
>> session'], zero='Select A Session Period')),
>> Field('the_time2', readable=False, writable=False),
>> Field('class_room', requires=IS_IN_SET(['500', '501',
>> '502', '503', '504', '505', '506'], zero='---Select A Class Room---')),
>> Field('controller', readable=False, writable=False),
>> Field('posted_by', 'reference auth_user', default=auth.
>> user_id, readable=False, writable=False))
>>
>> Regards;
>>
>> Mostwanted
>>
>> On Sunday, July 19, 2020 at 1:13:06 PM UTC+2, AGRogers wrote:
>>>
>>> I would try using a common_filter on the drop down list table. Could
>>> that work?
>>>
>>> On Sun, 19 Jul 2020, 6:10 pm mostwanted,  wrote:
>>>
 In my application I have 4 tables, 3 of them referenced in the fourth
 table but every user should be able to view only what they have entered
 into the database. Is there a way that in a dropdown list of a referenced
 table in an SQLFORM users can only view & select from items they have
 entered?

 *MODELS CODE:*
 db.define_table('lecturer',
 Field('surname'),
 Field('name'),
 Field('title'),
 Field('posted_by', 'reference auth_user', default=auth.
 user_id, readable=False, writable=False), #HERE
 format="%(surname)s %(name)s %(title)s")
 def lecturer(details): return '%(surname)s %(name)s' % details

 db.define_table('subject',
 Field('subject_name'),
 Field('posted_by', 'reference auth_user', default=auth.
 user_id, readable=False, writable=False), #HERE
 format="%(subject_name)s"
)
 db.define_table('departments',
 Field('department_name'),
 Field('posted_by', 'reference auth_user', default=auth.
 user_id, readable=False, writable=False), #HERE
 format="%(department_name)s")

 db.define_table('lecture',

 *Field('subject_name', 'reference subject'),
 Field('department', 'reference departments'),* #HERE
 Field('theLevels', label=SPAN('Levels'), requires=
 IS_IN_SET(['1.1', '1.2', '2.1', '2.2', '3.1', '3.2', '4.1', '4.2'],
 zero='---Select A Level---')), #HERE
 *Field('lecturer', 'reference lecturer'),*
 Field('class_session', requires=IS_IN_SET(['single
 session', 'double session', 'evening single session', 'evening double
 session'], zero='Select A Session Period')),
 Field('the_time2', readable=False, writable=False),
 Field('class_room', requires=IS_IN_SET(['500', '501',
 '502', '503', '504'

Re: [web2py] display items only entered by a logged in user in a dropdown menu of a reference table

2020-07-19 Thread AGRogers 
Great. It's a cool feature.

You would have read that you can turn it off in code temporarily just by
setting common_filter =none.

That has caught me a few times.

On Sun, 19 Jul 2020, 11:06 pm mostwanted,  wrote:

> Hey AGRogers, thanks for that suggestion, I added the highlited lines to
> my model code & it gave results, thank you very much:
>
>
> db.define_table('lecturer',
> Field('surname'),
> Field('name'),
> Field('title'),
> Field('posted_by', 'reference auth_user', default=auth.
> user_id, readable=False, writable=False),
> *common_filter = lambda query: db.lecturer.posted_by ==
> auth.user_id,*
> format="%(surname)s %(name)s %(title)s")
> def lecturer(details): return '%(surname)s %(name)s' % details
>
> db.define_table('subject',
> Field('subject_name'),
> Field('posted_by', 'reference auth_user', default=auth.
> user_id, readable=False, writable=False),
> *common_filter = lambda query: db.subject.posted_by ==
> auth.user_id,*
> format="%(subject_name)s"
>)
> db.define_table('departments',
> Field('department_name'),
> Field('posted_by', 'reference auth_user', default=auth.
> user_id, readable=False, writable=False),
> *common_filter = lambda query: db.departments.posted_by ==
> auth.user_id,*
> format="%(department_name)s")
>
> db.define_table('lecture',
>
> *Field('subject_name', 'reference subject'),
> Field('department', 'reference departments'),* #HERE
> Field('theLevels', label=SPAN('Levels'), requires=
> IS_IN_SET(['1.1', '1.2', '2.1', '2.2', '3.1', '3.2', '4.1', '4.2'], 
> zero='---Select
> A Level---')), #HERE
> *Field('lecturer', 'reference lecturer'),*
> Field('class_session', requires=IS_IN_SET(['single
> session', 'double session', 'evening single session', 'evening double
> session'], zero='Select A Session Period')),
> Field('the_time2', readable=False, writable=False),
> Field('class_room', requires=IS_IN_SET(['500', '501',
> '502', '503', '504', '505', '506'], zero='---Select A Class Room---')),
> Field('controller', readable=False, writable=False),
> Field('posted_by', 'reference auth_user', default=auth.
> user_id, readable=False, writable=False))
>
> Regards;
>
> Mostwanted
>
> On Sunday, July 19, 2020 at 1:13:06 PM UTC+2, AGRogers wrote:
>>
>> I would try using a common_filter on the drop down list table. Could that
>> work?
>>
>> On Sun, 19 Jul 2020, 6:10 pm mostwanted,  wrote:
>>
>>> In my application I have 4 tables, 3 of them referenced in the fourth
>>> table but every user should be able to view only what they have entered
>>> into the database. Is there a way that in a dropdown list of a referenced
>>> table in an SQLFORM users can only view & select from items they have
>>> entered?
>>>
>>> *MODELS CODE:*
>>> db.define_table('lecturer',
>>> Field('surname'),
>>> Field('name'),
>>> Field('title'),
>>> Field('posted_by', 'reference auth_user', default=auth.
>>> user_id, readable=False, writable=False), #HERE
>>> format="%(surname)s %(name)s %(title)s")
>>> def lecturer(details): return '%(surname)s %(name)s' % details
>>>
>>> db.define_table('subject',
>>> Field('subject_name'),
>>> Field('posted_by', 'reference auth_user', default=auth.
>>> user_id, readable=False, writable=False), #HERE
>>> format="%(subject_name)s"
>>>)
>>> db.define_table('departments',
>>> Field('department_name'),
>>> Field('posted_by', 'reference auth_user', default=auth.
>>> user_id, readable=False, writable=False), #HERE
>>> format="%(department_name)s")
>>>
>>> db.define_table('lecture',
>>>
>>> *Field('subject_name', 'reference subject'),
>>> Field('department', 'reference departments'),* #HERE
>>> Field('theLevels', label=SPAN('Levels'), requires=
>>> IS_IN_SET(['1.1', '1.2', '2.1', '2.2', '3.1', '3.2', '4.1', '4.2'], zero
>>> ='---Select A Level---')), #HERE
>>> *Field('lecturer', 'reference lecturer'),*
>>> Field('class_session', requires=IS_IN_SET(['single
>>> session', 'double session', 'evening single session', 'evening double
>>> session'], zero='Select A Session Period')),
>>> Field('the_time2', readable=False, writable=False),
>>> Field('class_room', requires=IS_IN_SET(['500', '501',
>>> '502', '503', '504', '505', '506'], zero='---Select A Class Room---')),
>>> Field('controller', readable=False, writable=False),
>>> Field('posted_by', 'reference auth_user', default=auth.
>>> user_id, readable=False, writable=False))
>>>

Re: [web2py] display items only entered by a logged in user in a dropdown menu of a reference table

2020-07-19 Thread mostwanted 
Hey AGRogers, thanks for that suggestion, I added the highlited lines to my 
model code & it gave results, thank you very much:


db.define_table('lecturer',
Field('surname'),
Field('name'),
Field('title'),
Field('posted_by', 'reference auth_user', default=auth.
user_id, readable=False, writable=False),
*common_filter = lambda query: db.lecturer.posted_by == 
auth.user_id,*
format="%(surname)s %(name)s %(title)s")
def lecturer(details): return '%(surname)s %(name)s' % details

db.define_table('subject',
Field('subject_name'),
Field('posted_by', 'reference auth_user', default=auth.
user_id, readable=False, writable=False),
*common_filter = lambda query: db.subject.posted_by == 
auth.user_id,*
format="%(subject_name)s"
   )
db.define_table('departments',
Field('department_name'),
Field('posted_by', 'reference auth_user', default=auth.
user_id, readable=False, writable=False),
*common_filter = lambda query: db.departments.posted_by == 
auth.user_id,*
format="%(department_name)s")

db.define_table('lecture',

*Field('subject_name', 'reference subject'),
Field('department', 'reference departments'),* #HERE
Field('theLevels', label=SPAN('Levels'), requires=IS_IN_SET
(['1.1', '1.2', '2.1', '2.2', '3.1', '3.2', '4.1', '4.2'], zero='---Select 
A Level---')), #HERE
*Field('lecturer', 'reference lecturer'),*
Field('class_session', requires=IS_IN_SET(['single session', 
'double 
session', 'evening single session', 'evening double session'], zero='Select 
A Session Period')),
Field('the_time2', readable=False, writable=False),
Field('class_room', requires=IS_IN_SET(['500', '501', '502', 
'503', '504', '505', '506'], zero='---Select A Class Room---')),
Field('controller', readable=False, writable=False),
Field('posted_by', 'reference auth_user', default=auth.
user_id, readable=False, writable=False))

Regards;

Mostwanted

On Sunday, July 19, 2020 at 1:13:06 PM UTC+2, AGRogers wrote:
>
> I would try using a common_filter on the drop down list table. Could that 
> work? 
>
> On Sun, 19 Jul 2020, 6:10 pm mostwanted, > 
> wrote:
>
>> In my application I have 4 tables, 3 of them referenced in the fourth 
>> table but every user should be able to view only what they have entered 
>> into the database. Is there a way that in a dropdown list of a referenced 
>> table in an SQLFORM users can only view & select from items they have 
>> entered?
>>
>> *MODELS CODE:*
>> db.define_table('lecturer',
>> Field('surname'),
>> Field('name'),
>> Field('title'),
>> Field('posted_by', 'reference auth_user', default=auth.
>> user_id, readable=False, writable=False), #HERE
>> format="%(surname)s %(name)s %(title)s")
>> def lecturer(details): return '%(surname)s %(name)s' % details
>>
>> db.define_table('subject',
>> Field('subject_name'),
>> Field('posted_by', 'reference auth_user', default=auth.
>> user_id, readable=False, writable=False), #HERE
>> format="%(subject_name)s"
>>)
>> db.define_table('departments',
>> Field('department_name'),
>> Field('posted_by', 'reference auth_user', default=auth.
>> user_id, readable=False, writable=False), #HERE
>> format="%(department_name)s")
>>
>> db.define_table('lecture',
>> 
>> *Field('subject_name', 'reference subject'),
>> Field('department', 'reference departments'),* #HERE
>> Field('theLevels', label=SPAN('Levels'), requires=
>> IS_IN_SET(['1.1', '1.2', '2.1', '2.2', '3.1', '3.2', '4.1', '4.2'], 
>> zero='---Select 
>> A Level---')), #HERE
>> *Field('lecturer', 'reference lecturer'),*
>> Field('class_session', requires=IS_IN_SET(['single 
>> session', 'double session', 'evening single session', 'evening double 
>> session'], zero='Select A Session Period')),
>> Field('the_time2', readable=False, writable=False),
>> Field('class_room', requires=IS_IN_SET(['500', '501', 
>> '502', '503', '504', '505', '506'], zero='---Select A Class Room---')),
>> Field('controller', readable=False, writable=False),
>> Field('posted_by', 'reference auth_user', default=auth.
>> user_id, readable=False, writable=False))
>>
>>
>>
>> *CONTROLLER CODE:*
>> I tried the highlighted part but it didnt work, I felt it wouldnt work 
>> but tried it anyway & it didnt work (shocker!)
>> Please help me figure this out.
>> def index():
>> 
>>
>> *user=db.auth_user(auth.user_id)if not user or 
>> not(use

Re: [web2py] display items only entered by a logged in user in a dropdown menu of a reference table

2020-07-19 Thread AGRogers 
I would try using a common_filter on the drop down list table. Could that
work?

On Sun, 19 Jul 2020, 6:10 pm mostwanted,  wrote:

> In my application I have 4 tables, 3 of them referenced in the fourth
> table but every user should be able to view only what they have entered
> into the database. Is there a way that in a dropdown list of a referenced
> table in an SQLFORM users can only view & select from items they have
> entered?
>
> *MODELS CODE:*
> db.define_table('lecturer',
> Field('surname'),
> Field('name'),
> Field('title'),
> Field('posted_by', 'reference auth_user', default=auth.
> user_id, readable=False, writable=False), #HERE
> format="%(surname)s %(name)s %(title)s")
> def lecturer(details): return '%(surname)s %(name)s' % details
>
> db.define_table('subject',
> Field('subject_name'),
> Field('posted_by', 'reference auth_user', default=auth.
> user_id, readable=False, writable=False), #HERE
> format="%(subject_name)s"
>)
> db.define_table('departments',
> Field('department_name'),
> Field('posted_by', 'reference auth_user', default=auth.
> user_id, readable=False, writable=False), #HERE
> format="%(department_name)s")
>
> db.define_table('lecture',
>
> *Field('subject_name', 'reference subject'),
> Field('department', 'reference departments'),* #HERE
> Field('theLevels', label=SPAN('Levels'), requires=
> IS_IN_SET(['1.1', '1.2', '2.1', '2.2', '3.1', '3.2', '4.1', '4.2'], 
> zero='---Select
> A Level---')), #HERE
> *Field('lecturer', 'reference lecturer'),*
> Field('class_session', requires=IS_IN_SET(['single
> session', 'double session', 'evening single session', 'evening double
> session'], zero='Select A Session Period')),
> Field('the_time2', readable=False, writable=False),
> Field('class_room', requires=IS_IN_SET(['500', '501',
> '502', '503', '504', '505', '506'], zero='---Select A Class Room---')),
> Field('controller', readable=False, writable=False),
> Field('posted_by', 'reference auth_user', default=auth.
> user_id, readable=False, writable=False))
>
>
>
> *CONTROLLER CODE:*
> I tried the highlighted part but it didnt work, I felt it wouldnt work but
> tried it anyway & it didnt work (shocker!)
> Please help me figure this out.
> def index():
>
>
> *user=db.auth_user(auth.user_id)if not user or
> not(user.id==auth.user_id): redirect(URL('index'))
> form=SQLFORM(db.lecture.posted_by==user.id)*
> if form.process(onvalidation=my_form_processing).accepted:
> response.flash=T('Lecture Entered')
> return locals()
>
>
> Regards;
>
> Mostwanted
>
> --
> Resources:
> - http://web2py.com
> - http://web2py.com/book (Documentation)
> - http://github.com/web2py/web2py (Source code)
> - https://code.google.com/p/web2py/issues/list (Report Issues)
> ---
> You received this message because you are subscribed to the Google Groups
> "web2py-users" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to web2py+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/web2py/e98d4e6a-69a2-4c1c-9028-3d98579a0f59o%40googlegroups.com
> 
> .
>

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/CACWMBMP2fFWv9HjEjKD2rN1LrEWw6%3DGfppLu3GE-_cNrDPp%3Dow%40mail.gmail.com.

[web2py] display items only entered by a logged in user in a dropdown menu of a reference table

2020-07-19 Thread mostwanted 
In my application I have 4 tables, 3 of them referenced in the fourth table 
but every user should be able to view only what they have entered into the 
database. Is there a way that in a dropdown list of a referenced table in 
an SQLFORM users can only view & select from items they have entered?

*MODELS CODE:*
db.define_table('lecturer',
Field('surname'),
Field('name'),
Field('title'),
Field('posted_by', 'reference auth_user', default=auth.
user_id, readable=False, writable=False), #HERE
format="%(surname)s %(name)s %(title)s")
def lecturer(details): return '%(surname)s %(name)s' % details

db.define_table('subject',
Field('subject_name'),
Field('posted_by', 'reference auth_user', default=auth.
user_id, readable=False, writable=False), #HERE
format="%(subject_name)s"
   )
db.define_table('departments',
Field('department_name'),
Field('posted_by', 'reference auth_user', default=auth.
user_id, readable=False, writable=False), #HERE
format="%(department_name)s")

db.define_table('lecture',

*Field('subject_name', 'reference subject'),
Field('department', 'reference departments'),* #HERE
Field('theLevels', label=SPAN('Levels'), requires=IS_IN_SET
(['1.1', '1.2', '2.1', '2.2', '3.1', '3.2', '4.1', '4.2'], zero='---Select 
A Level---')), #HERE
*Field('lecturer', 'reference lecturer'),*
Field('class_session', requires=IS_IN_SET(['single session', 
'double 
session', 'evening single session', 'evening double session'], zero='Select 
A Session Period')),
Field('the_time2', readable=False, writable=False),
Field('class_room', requires=IS_IN_SET(['500', '501', '502', 
'503', '504', '505', '506'], zero='---Select A Class Room---')),
Field('controller', readable=False, writable=False),
Field('posted_by', 'reference auth_user', default=auth.
user_id, readable=False, writable=False))



*CONTROLLER CODE:*
I tried the highlighted part but it didnt work, I felt it wouldnt work but 
tried it anyway & it didnt work (shocker!)
Please help me figure this out.
def index():


*user=db.auth_user(auth.user_id)if not user or 
not(user.id==auth.user_id): redirect(URL('index'))
form=SQLFORM(db.lecture.posted_by==user.id)*
if form.process(onvalidation=my_form_processing).accepted:
response.flash=T('Lecture Entered')
return locals()


Regards;

Mostwanted

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/e98d4e6a-69a2-4c1c-9028-3d98579a0f59o%40googlegroups.com.