Re: [web2py] Re: Legacy table with reserved keyword in column name

[Fabiano Almeida]

Wow, thanks!

The rname parameter of Field solved the problem.

2017-10-27 6:14 GMT-02:00 Nico de Groot :

> No, that just changes how the DAL checks for conflicts with reserved SQL
> words. It depends on the backend which words are problematic. See the book.
> If you really want to use a reserved word check out the rname parameter of
> Field.
>
> Nico de Groot
>
> --
> 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.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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.
For more options, visit https://groups.google.com/d/optout.

[web2py] Legacy table with reserved keyword in column name

[Fabiano Almeida]

Hi!

How to put in the DAL a legacy table whose column name matches reserved SQL
words?

Traceback:

SyntaxError: invalid table/column name "Message" is a "ALL" reserved
SQL/NOSQL keywor



thanks

-- 
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.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Re: HTML5 widgets on SQLFORM.factory

[Fabiano Almeida]

Great Anthony!

Field('year', 'integer', label='Year',
  widget=lambda f, v: SQLFORM.widgets.string.widget(f, v, _type='number'
))

worked perfectly!

Thanks!

2017-09-11 19:59 GMT-03:00 Anthony <abasta...@gmail.com>:

> On Monday, September 11, 2017 at 4:30:40 PM UTC-4, Fabiano Almeida wrote:
>>
>> Hi @ll!
>>
>> How to use HTML5 widgets on SQLFORM.factory?
>>
>> I have this peace of code:
>> form = SQLFORM.factory(Field('year', 'integer', label='Year'))
>>
>
>> I like use this HTML5 input type="number" widget.
>>
>
> You can do:
>
> Field('year', 'integer', label='Year',
>   widget=lambda f, v: SQLFORM.widgets.string.widget(f, v, _type=
> 'number'))
>
> You could instead use SQLFORM.widgets.integer.widget (which is the default
> for integer fields), but that would set class="integer", which would
> activate web2py's built-in integer validator, which you may not want.
>
> Anthony
>
> --
> 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.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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.
For more options, visit https://groups.google.com/d/optout.

[web2py] HTML5 widgets on SQLFORM.factory

[Fabiano Almeida]

Hi @ll!

How to use HTML5 widgets on SQLFORM.factory?

I have this peace of code:
form = SQLFORM.factory(Field('year', 'integer', label='Year'))

I like use this HTML5 input type="number" widget.


Thanks

-- 
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.
For more options, visit https://groups.google.com/d/optout.

[web2py] How to install NLTK?

[Fabiano Almeida]

Hi all,

How to install NLTK on web2py?

Thanks,

Fabiano.

-- 
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.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Sites Powered by web2py

[Fabiano Almeida]

Thanks Alex!

2017-04-05 11:43 GMT-03:00 Alex <mrauc...@gmail.com>:

> Thanks Fabiano.
>
> Each subdomain refers to an own application, each with it's own database
> since the breeds are not related to each other.
>
> Alex
>
> On Wednesday, April 5, 2017 at 2:52:00 AM UTC+2, Fabiano Almeida wrote:
>>
>> Hi Alex!
>> Great design ! Congratulations!
>>
>> I see use of subdomain to breeds, how do you do it?
>>
>> thx,
>>
>> Fabiano.
>>
>> 2017-04-02 17:58 GMT-03:00 Alex <mrau...@gmail.com>:
>>
>>> The section for "Sites Powered by web2py" does not look very promising
>>> and also seems outdated. Most pages don't have a screenshot and some of
>>> them are not even working anymore. When I try to visit the first site I get
>>> a link to an internal error ticket.
>>>
>>> Submitting a new page does not work. We tried to add our website but it
>>> does not show up. Maybe you want to add it: https://breedarchive.com
>>>
>>> Further I'd encourage you to completely restructure the powered by
>>> section because the current page probably has the opposite desired effect
>>> and scares off new visitors. Hundreds of applications, many of them with
>>> questionable content, is not really helpful. It would be much better to
>>> only show a very small selection (~5) of high quality web2py sites. Each
>>> one with a screenshot and a short description.
>>>
>>> regards,
>>> Alex
>>>
>>> --
>>> 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+un...@googlegroups.com.
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>
>> --
> 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.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Sites Powered by web2py

[Fabiano Almeida]

Hi Alex!
Great design ! Congratulations!

I see use of subdomain to breeds, how do you do it?

thx,

Fabiano.

2017-04-02 17:58 GMT-03:00 Alex :

> The section for "Sites Powered by web2py" does not look very promising and
> also seems outdated. Most pages don't have a screenshot and some of them
> are not even working anymore. When I try to visit the first site I get a
> link to an internal error ticket.
>
> Submitting a new page does not work. We tried to add our website but it
> does not show up. Maybe you want to add it: https://breedarchive.com
>
> Further I'd encourage you to completely restructure the powered by section
> because the current page probably has the opposite desired effect and
> scares off new visitors. Hundreds of applications, many of them with
> questionable content, is not really helpful. It would be much better to
> only show a very small selection (~5) of high quality web2py sites. Each
> one with a screenshot and a short description.
>
> regards,
> Alex
>
> --
> 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.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Re: edit or delete child or detail table on SQLFORM.grid with left join

[Fabiano Almeida]

Thanks Massimo, I will try this.

2017-03-20 11:41 GMT-03:00 Massimo Di Pierro :

> Unfortunately not out of the box. You need a custom button that does a
> ajax query.
>
>
> On Friday, 3 March 2017 17:52:30 UTC-6, 黄祥 wrote:
>>
>> is it possible to edit or delete child or detail table on SQLFORM.grid
>> with left join?
>> i've tried before it seems the edit is for the first table (parent or
>> header), the child or detail table cannot be edited or deleted with left
>> join in SQLFORM.grid.
>> *e.g.*
>> def report_production_result():
>> table_header = db.production_result_header
>> table_detail = db.production_result_detail
>>
>> orderby = ~table_header.id
>> left = table_detail.on(table_header.id == table_detail.production_result
>> _no)
>> fields = [
>>  # header
>>  table_header.id, table_header.production_result_no,
>> table_header.production_result_date,
>>  table_header.shift, table_header.origin, table_header.status,
>>  # detail
>>  table_detail.stock, table_detail.quantity]
>> grid = SQLFORM.grid(table_header, fields = fields, left = left, orderby =
>> orderby)
>> return locals()
>>
>> thanks and best regards,
>> stifan
>>
> --
> 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.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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.
For more options, visit https://groups.google.com/d/optout.

[web2py] Radius Authentication

[Fabiano Almeida]

Hi All!

Is it possible to authenticate web2py users through the freeradius server?

Thx

-- 
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.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Re: Open Sourced dating website

[Fabiano Almeida]

Wow! Thanks for sharing! New ideas! New features!

Thanks a lot and best regards!

Fabiano

2017-02-26 21:03 GMT-03:00 Jaimee S :

> Yea, dude. There definitely aren't ‎many new ideas under the sun so its
> always best to find one and improve it a little.
>
> David Shavers
> Founder, Just Between Us
> jbthelpp...@gmail.com
> www.jbtus.com
> *From: *Donald McClymont
> *Sent: *Sunday, February 26, 2017 4:18 PM
> *To: *web2py-users
> *Reply To: *web2py@googlegroups.com
> *Subject: *[web2py] Re: Open Sourced dating website
>
> Thanks for sharing - I will take a look.  No plans to start a dating
> website for people - however currently quite enjoying reading "The
> evolution of everything" and this argues that human progress arises when
> ideas have sex - so perhaps it could be adapted to a dating site for ideas.
>
> Donald
>
>
>
> On Sunday, February 26, 2017 at 6:17:15 AM UTC, David Shavers wrote:
>>
>> Good Evening,
>>
>> I made a dating website when i was heavily into web2py. My original goal
>> was to overthrow Plenty of Fish. Didn't happen lol. Currently I'm into
>> android development and release new apps almost weekly. My dating website
>> has over 300 users and it's still growing even though i don't advertise or
>> put any effort into marketing. If you are interested/single/curious/looking
>> for love/etc, it's http://www.jbtus.com
>>
>>
>> About an hour ago, i open sourced it on github because i figured some
>> other developer may be trying to overtake pof too and would need a
>> jumpstart to help them get past all of the arbitraries. I'm also looking
>> for employment! The website has many features such as: user to user
>> messaging, a forum, a user feed similar to that of Facebook, bootstrap
>> slideshow, jumbotrons, sorting based on gender/preference, stripe(payment)
>> integration, featured users, user login page, and much more! This website
>> is easily customizable and i did most of the hard work for you. Also, this
>> app uses NO PLUGINS! Enjoy!
>>
>>
>> https://github.com/frontEndDevv/dating_website
>>
>>
>>
>>
>>
>> PS.. if you encounter any issues that you aren't able to fix, please
>> contact me so i can try my best to help!  And if you are into android
>> development, let me know and we can collaborate or swap ideas or something
>>
> --
> 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 a topic in the
> Google Groups "web2py-users" group.
> To unsubscribe from this topic, visit https://groups.google.com/d/
> topic/web2py/fKisIOIL1qE/unsubscribe.
> To unsubscribe from this group and all its topics, send an email to
> web2py+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>
>
> --
> 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.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Re: Non-Editable field in SQLFORM

[Fabiano Almeida]

db.table.field.writable = False -> don't write
db.table.field.readable = False  -> don't show (hide)

2016-12-12 14:17 GMT-02:00 lyn2py :

> It will always be allowed to take a value in insert, a value that you
> assign it to, for example, via "default", like so:
> db.table.field.default = some_value
>
> To make the field non-editable to the end user, use:
> db.table.field.editable = False
> ...
> form = SQLFORM(db.table)
>
> for the above examples, replace *table* with *your table name* and *field*
> with *your field name*.
>
> You can find out the details in Chapter in 06 The database abstraction
> layer
> 
>  and 07 Forms and validators
> 
>
>
> On Friday, December 9, 2016 at 11:38:55 PM UTC+8, Amit Kumar Modak wrote:
>>
>> Hello,
>>
>> How can I make a field non-editable in SQLFORM, while it should be
>> allowed to take a value in insert.
>>
>>
>> Regards,
>> Amit
>>
> --
> 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.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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.
For more options, visit https://groups.google.com/d/optout.

[web2py] treat url error

[Fabiano Almeida]

How to capture and treat the url before displaying error? For example, the
User entered the url with a controller that does not exist, and the
application takes the url points to an existing controller for any action
to be done.

Thanks,

Fabiano.

-- 
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.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] WEB2PY Creating Controls Dynamically

[Fabiano Almeida]

Hi!

See
http://www.web2pyslices.com/slice/show/1724/cascading-dropdowns-simplified



2016-05-25 14:43 GMT-03:00 Venkat :

> Hi
>
> I have a requirement of displaying data from database from 4 tables i used
> join to pull all the data but i should display that data in dropdown for
> each column, how can i build these dropdowns dynamically? user will see
> that past data and will be able to select an option from that drop down
> and submit that data. i should be able to build those controls dynamically
> for all the records that i pull based on user and dates
>
> --
> 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.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Re: random generator of stupid pages

[Fabiano Almeida]

Great work!

2016-03-07 3:24 GMT-03:00 Dave S :

> On Sunday, March 6, 2016 at 8:49:15 PM UTC-8, Massimo Di Pierro wrote:
>>
>> http://mdipierro.github.io/stupid.css/themes/random.html
>>
>
>
> Nice!  Thank you!
>
> /dps
>
>
> --
> 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.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] custom form no submiting

[Fabiano Almeida]

*view:*

{{extend 'layout.html'}}
{{=form.custom.begin}}

 

 {{=db.stud_person.first_name
.label}}
 {{=form.custom.widget.first_name}}
 

 {{=db.stud_person.middle_name
.label}}
 {{=form.custom.widget.middle_name}}
 

 {{=db.stud_person.last_name
.label}}
 {{=form.custom.widget.last_name}}
 
 

{{=form.custom.submit}}
{{=form.custom.end}}


Fabiano.

2016-03-03 14:58 GMT-03:00 prashant joshi :

>
>
> def register():
> form=SQLFORM(db.stud_person)
> print form.errors
> if form.process().accepted:
> response.flash='Bitte warten'
> elif form.errors:
> response.flash='Bitte fuellen sie das Formular richtig aus'
>
> return dict(form=form)
>
>
>
>
> view:-
> {{=form.custom.begin}}
> 
> 
>href="{{=URL('static','css/bootstrap.min.css')}}"/>
>  href="{{=URL('static','css/web2py-bootstrap3.css')}}"/>
> 
> 
>
> 
>   
>
> 
>   
> First Name
> Middle Name
> Last Name
>   
>   
>   {{=form.custom.widget.first_name}}
> {{=form.custom.widget.middle_name}}
> {{=form.custom.widget.last_name}}
>   
> 
> {{=form.custom.submit}}
> 
> {{=form.custom.end}}
>
>
> This form is not submited
> deta is not iserting on detabase...
> This code is right
>
>
>
> --
> 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.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Re: How to install web2py on CentOS 6.5 with Apache?

[Fabiano Almeida]

thanks Esau!

2016-02-24 19:48 GMT-03:00 Esau Hernandez Valles <esau.hernan...@gmail.com>:

> I prefer web2py nginx on Centos.  I think this combination is better.
>
> check this link
> http://mwiki.yyovkov.net/index.php/Install_Web2py_on_CentOS_6
>
> On DigitalOcean there are a lot of tutorial. Only You have to sign-in.
>
> I think You have to checkscripts/setup-web2py-centos7.sh
>
> good lock
>
>
> El viernes, 19 de febrero de 2016, 9:48:59 (UTC-5), Fabiano Almeida
> escribió:
>>
>> Hi all,
>>
>> How to install web2py on CentOS 6.5 with Apache?
>>
>> Tks!
>>
>> Fabiano.
>>
> --
> 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.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Re: Rich Text

[Fabiano Almeida]

Thanks Leonel!

2016-02-24 7:33 GMT-03:00 Leonel Câmara :

> Use Tim's plugin it works great
>
> https://github.com/timrichardson/web2py_ckeditor4
>
> --
> 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.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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.
For more options, visit https://groups.google.com/d/optout.

[web2py] Rich Text

[Fabiano Almeida]

Hi all,

How field type is used to store rich text (with formatting, table, figure)
in db?

How to use ckEditor or other rich text editor in web2py?

Thanks,

Fabiano.

-- 
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.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Re: How to install web2py on CentOS 6.5 with Apache?

[Fabiano Almeida]

I'm a Debian user / Ubuntu, CentOS testing for the first time ...

Thanks!

2016-02-19 12:57 GMT-02:00 Jim S <j...@qlf.com>:

> I'm not a CentOS guy, but there are a couple scripts (although not for
> 6.5) in the /scripts directory that may give you clues as to what needs to
> happen.
>
> -Jim
>
>
> On Friday, February 19, 2016 at 8:48:59 AM UTC-6, Fabiano Almeida wrote:
>>
>> Hi all,
>>
>> How to install web2py on CentOS 6.5 with Apache?
>>
>> Tks!
>>
>> Fabiano.
>>
> --
> 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.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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.
For more options, visit https://groups.google.com/d/optout.

[web2py] How to install web2py on CentOS 6.5 with Apache?

[Fabiano Almeida]

Hi all,

How to install web2py on CentOS 6.5 with Apache?

Tks!

Fabiano.

-- 
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.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Re: A guide how to install your web2py app on your own server (using DigitalOcean droplets)

[Fabiano Almeida]

Great! Thanks for sharing!

2016-02-15 9:30 GMT-02:00 'M Bailey' via web2py-users <
web2py@googlegroups.com>:

> Wow just read your blog. Really useful, clear instructions - thank you.
>
>
> On Monday, 15 February 2016 10:54:01 UTC, Dragan Matic wrote:
>>
>> Hey guys, I wrote a guide for beginners how to install and configure your
>> own server and how to host your web2py app on it, if anybody's interested
>> here's the link:
>>
>> http://blog.draganmatic.com/init/default/show_page/3
>>
> --
> 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.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Re: web2py included on Synology DSM

[Fabiano Almeida]

+1

2016-02-10 13:16 GMT-02:00 Ron Chatterjee :

> +1
>
>
> On Wednesday, February 10, 2016 at 8:44:46 AM UTC-5, xmarx wrote:
>>
>> +1
>>
>> 10 Şubat 2016 Çarşamba 15:32:24 UTC+2 tarihinde Gerd yazdı:
>>>
>>> Hi!
>>>
>>> I would like to see web2py as a package for the Synology NAS, so i wrote
>>> an inquery to the company at
>>> https://www.synology.com/en-global/form/inquiry/feedback
>>>
>>> If you feel the same i suggest you to fill out the form and tell them
>>> that we want it ;-)
>>>
>>> Thanks,
>>> Gerd
>>>
>> --
> 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.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Virtual field in SQLFORM.grid

[Fabiano Almeida]

Hi Marcello,

Can you see your tables in appadmin?

And your lambda, you can create and call function to count in konsulta's
table and return the number.

Field.Virtual('total', lambda row: kontagem(row.id))


Att.,

Fabiano.

2016-01-19 15:09 GMT-02:00 Marcello :

> Hello,
>
> I have a one to many configuration, using mysql database.
> I want to show a grid with the "one" table, and for each row, count the
> "many".
>
> For that I created a total virtual field.
> It works OK in the shel, for example
>
> But when I call the SQLFORM.grid I get an error
>
> Why do this happen ???
> Is there a way to get this ??
>
>
> Thanks
> Marcello
>
> db.define_table(
> 'trabalho',
> Field('descricao','string'),
> Field.Virtual('total', lambda row: row.trabalho.konsulta.count()),
> )
>
> db.define_table(
> 'konsulta',
> Field('trabalho_id', 'reference trabalho'),
> Field('name','string'),
> )
>
>
> I want to show a grid with:
> grid = SQLFORM.grid(db.trabalho, editable=True, create=False,
> deletable=False)
>
> When I call it, I get:
> 
>
>
>
> --
> 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.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Re: multi tenant

[Fabiano Almeida]

Great Massimo!

Thanks a lot!

Fabiano.

2016-01-17 23:00 GMT-02:00 Massimo Di Pierro <massimo.dipie...@gmail.com>:

> That URL structure assumes you have a single app running at the domain. So
> I am going to assume that is the case.
>
> first of all you have to map the tenant name ($domain) into
> request.args(0) using routes.py
>
> routes_in = [['/$domain','/yourapp/default/index/$domain'],
> ['/$domain/$c','/yourapp/$c/index/$domain'],
> ['/$domain/$c/$f','/yourapp/$c/$f/$domain'],
>
> ['/$domain/$c/$f/$anything','/yourapp/$c/$f/$domain/$anything']]
>
> routes_out = [(a,b) for (b,a) in routes_in]
>
> then you have to handle in code where the domain is now in request.args(0).
>
>
>
>
>
> On Friday, 15 January 2016 13:48:43 UTC-6, Fabiano Almeida wrote:
>>
>> Hi All!
>>
>> In the book shows multi tenant based on subdomain, with code
>> <http://www.web2py.com/books/default/chapter/29/06/the-database-abstraction-layer?search=tenancy#Common-fields-and-multi-tenancy>
>> :
>>
>>> db._common_fields.append(Field('request_tenant',
>>> default=request.env.http_host,writable=False))
>>
>>
>> Seeing commercial sites that use the concept of multi-tenant offices, the
>> url is usually www.domain.com/, and the  code that differs from
>> another tenant.
>>
>> It can deploy this type of multi-tenant access in web2py? how?
>>
>> thanks,
>>
>> Fabiano.
>>
> --
> 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.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Re: web3py

[Fabiano Almeida]

2016-01-15 17:29 GMT-02:00 Carlos Cesar Caballero Díaz <
desarro...@spicm.cfg.sld.cu>:

> Hi, I have written about my opinion before. The backward compatibility
> should never affect the system maintenance, sometimes is better just remove
> the old functionalities to make way for the new ones, the backward
> compatibility in the long term will become unsustainable.
>
> In my opinion, something like a 90% of compatibility and a good migration
> guide should be enough, there are alternatives as the yii framework
> migration from 1.x to 2.x, they in some way could run the two versions side
> by side (
> http://www.yiiframework.com/doc-2.0/guide-tutorial-yii-integration.html#using-both-yii2-yii1
> )
>
> I know that one of the main promises of web2py was the backward
> compatibility, but I am sure that developers (web2py users are developers)
> prefer a clean system with new useful features.
>

+1

-- 
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.
For more options, visit https://groups.google.com/d/optout.

[web2py] multi tenant

[Fabiano Almeida]

Hi All!

In the book shows multi tenant based on subdomain, with code

:

> db._common_fields.append(Field('request_tenant',
> default=request.env.http_host,writable=False))


Seeing commercial sites that use the concept of multi-tenant offices, the
url is usually www.domain.com/, and the  code that differs from
another tenant.

It can deploy this type of multi-tenant access in web2py? how?

thanks,

Fabiano.

-- 
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.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Re: what is difference between ajax() and web2py_component() ?

[Fabiano Almeida]

Great!

Can you show me examples of using web2py_component?

thanks!

Fabiano.

2016-01-07 13:57 GMT-02:00 Anthony :

> The ajax() function provides basic functionality for making an Ajax
> request, with some additional features, such as automatically sending
> values from named input fields and inserting the returned data into a
> particular target within the DOM (or optionally executing some returned
> Javascript code).
>
> web2py_component (which is a backward compatible alias for
> $.web2py.component) is a more sophisticated facility for embedding the
> output of controller actions within web pages. It is much like a page
> within a page, with the ability to load new content into the component. In
> particular, it is possible to trap both links and forms, so when you click
> a link or submit a form contained within a component, the new content will
> be loaded within the component (without reloading the rest of the page).
> Components also include functionality to automatically refresh themselves
> at a fixed interval.
>
> Anthony
>
>
> On Thursday, January 7, 2016 at 8:43:40 AM UTC-5, Ariya Owam-aram wrote:
>>
>> Hi everyone,
>>
>> I often use ajax and web2py_component for onclick action (for example)
>> but I never know what is difference between them and how to use them the
>> right way.  Can anyone guide me a good example, please?
>>
>> Thank your
>> Ariya
>>
>>
>> --
> 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.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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.
For more options, visit https://groups.google.com/d/optout.

[web2py] Role of users

[Fabiano Almeida]

Hi!

I'm trying to create a list of roles for each user:

for x in db(db.auth_user.id>0).select(db.auth_user.id):
groups = []
for g in db(db.auth_membership.id > 0).select(db.auth_group.role,
join=[db.auth_group.on(db.auth_group.id==db.auth_membership.group_id),
db.auth_user.on(db.auth_user.id==db.auth_membership.user_id)]):
groups.append(g.role)

and the error:

TypeError: reduce() of empty sequence with no initial value

How to do this list?

thanks,

Fabiano

-- 
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.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: Role of users

[Fabiano Almeida]

Hi Anthony!

The auth.user_groups.value() is only for logged user or I can define user 
id to get for all users?

Thanks!

Fabiano

Em quarta-feira, 2 de dezembro de 2015 14:47:50 UTC-2, Anthony escreveu:
>
> The roles for a user are stored as a dictionary in auth.user_groups, with 
> the keys being the group IDs and the values being the roles, so for just a 
> list of the roles:
>
> auth.user_groups.values()
>
> Anthony
>
> On Wednesday, December 2, 2015 at 11:31:14 AM UTC-5, Fabiano Almeida wrote:
>>
>> Hi!
>>
>> I'm trying to create a list of roles for each user:
>>
>> for x in db(db.auth_user.id>0).select(db.auth_user.id):
>> groups = []
>> for g in db(db.auth_membership.id > 0).select(db.auth_group.role, 
>> join=[db.auth_group.on(db.auth_group.id==db.auth_membership.group_id), 
>> db.auth_user.on(db.auth_user.id==db.auth_membership.user_id)]):
>> groups.append(g.role)
>>
>> and the error:
>>
>> TypeError: reduce() of empty sequence with no initial value
>>
>> How to do this list?
>>
>> thanks,
>>
>> Fabiano
>>
>

-- 
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.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: Role of users

[Fabiano Almeida]

It works using the example many to many of the book:

for x in db(db.auth_user.id>0).select(db.auth_user.id):
groups = []
users_and_groups = db((db.auth_user.id==x.id)& 
(db.auth_user.id==db.auth_membership.user_id) & 
(db.auth_group.id==db.auth_membership.group_id))
for g in users_and_groups.select(db.auth_group.role, 
orderby=db.auth_membership.group_id):
groups.append(g.role)
# [...]


Em quarta-feira, 2 de dezembro de 2015 14:31:14 UTC-2, Fabiano Almeida 
escreveu:
>
> Hi!
>
> I'm trying to create a list of roles for each user:
>
> for x in db(db.auth_user.id>0).select(db.auth_user.id):
> groups = []
> for g in db(db.auth_membership.id > 0).select(db.auth_group.role, 
> join=[db.auth_group.on(db.auth_group.id==db.auth_membership.group_id), 
> db.auth_user.on(db.auth_user.id==db.auth_membership.user_id)]):
> groups.append(g.role)
>
> and the error:
>
> TypeError: reduce() of empty sequence with no initial value
>
> How to do this list?
>
> thanks,
>
> Fabiano
>

-- 
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.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Re: record versioning

[Fabiano Almeida]

thanks!

2015-12-01 17:21 GMT-02:00 Anthony <abasta...@gmail.com>:

> web2py does not support the SQL UNION statement, but you can separately
> query the two tables and generate the union of the two Rows objects via
> Python:
>
> all_records = db(db.mytable).select() | db(db.mytable_archive).select()
>
> See
> http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Combining-rows
> .
>
> Anthony
>
>
> On Monday, November 30, 2015 at 12:31:46 PM UTC-5, Fabiano Almeida wrote:
>>
>> Hi All!
>>
>> I need create a report with record versioning. How to union table with
>> table_archive?
>>
>> Thanks!
>>
> --
> 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.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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.
For more options, visit https://groups.google.com/d/optout.

[web2py] record versioning

[Fabiano Almeida]

Hi All!

I need create a report with record versioning. How to union table with
table_archive?

Thanks!

-- 
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.
For more options, visit https://groups.google.com/d/optout.

[web2py] new connection string in scaffold

[Fabiano Almeida]

Hi all,

I will create a new app in web2py 2.12.3, and I see:

db = DAL(myconf.take('db.uri'), pool_size=myconf.take('db.pool_size',
cast=int), check_reserved=['all'])

How to configure this to connect with remote mysql database ?

Thx!

Fabiano

-- 
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.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Re: new connection string in scaffold

[Fabiano Almeida]

thanks!

2015-11-13 23:13 GMT-02:00 黄祥 :

> please take a look at appconfig.ini file in private folder and change the
> uri value with your own settings :
> e.g.
> private/appconfig.ini
> [db]
> uri   = mysql://MySQLUser:MySQLPassword@MySQLHost/MySQLDatabase
>
> best regards,
> stifan
>
>> --
> 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.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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.
For more options, visit https://groups.google.com/d/optout.

[web2py] Indexes

[Fabiano Almeida]

Hi All!

In book

I see example how to create index with executesql . How to use indexes in
querys?

Thx,

Fabiano.

-- 
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.
For more options, visit https://groups.google.com/d/optout.

[web2py] its possible get mac address?

[Fabiano Almeida]

Hi!

Web2py can obtain mac address from user?

Thanks in advance,

Fabiano.

-- 
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.
For more options, visit https://groups.google.com/d/optout.

[web2py] How to filter table data in field of SQLFORM.factory?

[Fabiano Almeida]

Hi,

How to filter table data in field of SQLFORM.factory?

my code:

form = SQLFORM.factory(
Field('cbPerson', label='Person', requires=IS_IN_DB(db,'
auth_user.id','%(first_name)s %(last_name)s', zero=None), default=
auth.user.id))

need show only db.auth_user.id == auth.user.id

Thx,

Fabiano.

-- 
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.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: How to show query on a grid?

[Fabiano Almeida]

Delete the db before ((db.guest.id>0)... worked

query = ((db.guest.id>0) & \
> (db.voucher.disp == False) & \
> (db.voucher.guest == db.guest.id) & \
> (db.auth_user.id == db.guest.fnd)) \
> .select(db.voucher.voucher, db.guest.name, db.auth_user.id ,
> db.auth_user.first_name, db.guest.dia)
> form = SQLFORM.grid(query)
>

Thx

-- 
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.
For more options, visit https://groups.google.com/d/optout.

[web2py] How to show query on a grid?

[Fabiano Almeida]

Hi!

I try to show query on a SQLFORM.grid, but returns error: AttributeError:
'Rows' object has no attribute '_db'

My code:

query = db((db.guest.id>0) & \
(db.voucher.disp == False) & \
(db.voucher.guest == db.guest.id) & \
(db.auth_user.id == db.guest.fnd)) \
.select(db.voucher.voucher, db.guest.name, db.auth_user.id ,
db.auth_user.first_name, db.guest.dia)
form = SQLFORM.grid(query)

How to show query on a grid?

thx in advance,

Fabiano.

-- 
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.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Re: qrcode

[Fabiano Almeida]

Hi Niphlod,

I trying to generate qr code with built-in feature, for local use, mobile
for reading.

thx

2015-10-13 18:20 GMT-03:00 Niphlod <niph...@gmail.com>:

> with any qrcode library or qrcode ondemand service out there ? What did
> you try ?
>
>
> On Tuesday, October 13, 2015 at 11:05:23 PM UTC+2, Fabiano Almeida wrote:
>>
>> Hi all!
>>
>> How to dynamically generate qr code in web2py?
>>
>> grateful,
>>
>> Fabiano.
>>
> --
> 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.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Re: qrcode

[Fabiano Almeida]

Hi Michael,

With your example, return this:

Qrpage
> StringIO:
> ToQRData:Fabiano Likes MLP:FIMimg: 0x7f02d1c0a9d0>img_tag: src="data:image/png;base64,iVBORw0KGgoNSUhEUgAAAQ4AAAEOAQBQysQIAAAB0klEQVR4nO2aQY7cIBBFXwVLs4Qb5Cj4BjnT3MwcZQ4wEl6OBPpZgJ3OIhopTnpsC1YNfouvUulTRbWJT1b99hkBA/nD0rL/ksq29WU79eVMcq+HeElSgRSAmPsXSZKW08m9GlLNLAAxO5G+lx7iZGZP13JfpIVzfZFew1druR8Ss9MvZ/haLfdAJsAJqJBmh+E/jJgrRD1Zy/2QCVbbNv7dlH6AUninn/pTyb0Y0kuDtjLtQns806jIjiDJzMxCNbPgRDOKdcLmdcLms8m9FIIWX9CCE/iCFi9p8RIxu5G7xxCk7NQ6tKjSTIG4G8Xo1Y4gPVmVnVrX1nIXAC+N6B5C+uuC1B8WNlMAKTffOJPciyHNcrvv4lqZ0NK2Vw8jun+P9FutPY/5PbBbOTac4V8gyV5EfDPrnfA6tXMpn1HulZDWCZvN+6tuCtX6CqeTeyHksS/r5cJePeA0brWDSNqyFFYzYq6mhWrgCzafTe7VkH02EduAwsnm5hbP13JDZJtNpADgP1oW29xS+XRyL4u4/rqwsJVqr+NWO4BMj5t1KobPWBQQ36bnarkf8jibwGeIS52UDMDruVruh/w2m6D2YMcc6B/GbOIAYuO/OP8R+Qk7Fi5D47GUFwBJRU5ErkJggg==">
> output:qr: instance at 0x7f02d1bf40e0>qrcode: '/usr/local/lib/python2.7/dist-packages/qrcode-5.1-py2.7.egg/qrcode/__init__.pyc'>
>

How to show de picture + text message?

thx

2015-10-14 13:05 GMT-03:00 Michael M <preact...@gmail.com>:

> def qrpage():
> #Install Python Modules: (Pillow,qrcode)
> #https://github.com/lincolnloop/python-qrcode
>
> ToQRData = auth.user.username + ' Likes MLP:FIM'
> import qrcode
> import StringIO
> qr = qrcode.QRCode(
> version=1,
> error_correction=qrcode.constants.ERROR_CORRECT_L,
> box_size=10,
> border=1,
> )
> qr.add_data(ToQRData)
> qr.make(fit=True)
>
> # use an in-memory object to save
> output = StringIO.StringIO()
> img = qr.make_image()
> img.save(output)
>
> # and the use getvalue() method to get the string
> img_tag = '' %
> output.getvalue().encode('base64').replace('\n', '')
> return locals()
>
>
> On Tuesday, October 13, 2015 at 2:05:23 PM UTC-7, Fabiano Almeida wrote:
>>
>> Hi all!
>>
>> How to dynamically generate qr code in web2py?
>>
>> grateful,
>>
>> Fabiano.
>>
> --
> 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.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Re: qrcode

[Fabiano Almeida]

Hi Stifan

I installed the semanticwebexample and not found reference to qr code on it.

thx

2015-10-13 18:28 GMT-03:00 黄祥 :

> i think there is web2py appliances that create some thing like this before
> : semanticwebexample
>
> best regards,
> stifan
>
> --
> 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.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Re: qrcode

[Fabiano Almeida]

Hi Richard,

elaphe worked! thank you!

How to show a text message with qrcode on same page?

Thx

2015-10-13 21:07 GMT-03:00 Richard Vézina :

> You can have a look on the side of elaphe :
> https://bitbucket.org/whosaysni/elaphe/
>
> For most type of code it works... But there were issue with bouding box
> for some of them in the pass, hope it has been solve since then...
>
> Richard
>
> On Tue, Oct 13, 2015 at 5:28 PM, 黄祥  wrote:
>
>> i think there is web2py appliances that create some thing like this
>> before : semanticwebexample
>>
>> best regards,
>> stifan
>>
>> --
>> 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.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
> --
> 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.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Re: qrcode

[Fabiano Almeida]

Hi Michael,

2015-10-14 16:00 GMT-03:00 Michael M :

> {{=XML(img_tag)}}


It worked! Grateful for all!

Fabiano.

-- 
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.
For more options, visit https://groups.google.com/d/optout.

[web2py] qrcode

[Fabiano Almeida]

Hi all!

How to dynamically generate qr code in web2py?

grateful,

Fabiano.

-- 
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.
For more options, visit https://groups.google.com/d/optout.

[web2py] Authenticate with Radius Server

[Fabiano Almeida]

Hi @ll!

I have an pfSense server with FreeRadius. Can I log in web2py app with
users from FreeRadius? How?

thx!

-- 
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.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] To display random questions one by one

[Fabiano Almeida]

Hi Sai,

Can you try this:

import  random

## first option to select question
s = number of lines of your table
i = random.randint(0,s)

## second option to select question - best: no broke if delete any record
on table
s = db(db.ins_ques.id  0).select(db.ins_ques.id)
i = random.sample(s,1)

## how to query your question
question=db(db.ins_ques.id == i).select(db.ins_ques.ALL).first()

[...]


Fabiano.

2015-07-28 5:51 GMT-03:00 Sai Harsh Tondomker saiharsh@iiits.in:

 I have trying to display random question for every login (Means client get
 different questions for every login).
 Here I gave my db.py and def doing paper. Please help me to solve the
 problem.


 db.define_table('ins_ques',
 Field('qnum','integer',notnull=True,readable=False,writable=False,label='Question
 Number'),
 Field('qupload','upload',label='Upload Image'),
 Field('question','text',notnull=True,label='Question'),
 Field('op1','string',notnull=True,label='Option A'),
 Field('op2','string',notnull=True,label='Option B'),
 Field('op3','string',notnull=True,label='Option C'),
 Field('op4','string',notnull=True,label='Option D'),
 Field('cor_ans',requires=IS_IN_SET(['A','B','C','D'],multiple=True),label='Correct
 Answer',widget=SQLFORM.widgets.checkboxes.widget)
 )
 db.define_table('ans_ques',
 Field('qdate','date',readable=False,writable=False,label='Date of Paper'),
 Field('qnum','integer',readable=False,writable=False),
 Field('studentid','integer',readable=False,writable=False),

 Field('answer','string',requires=IS_IN_SET(['A','B','C','D'],multiple=True),widget=SQLFORM.widgets.checkboxes.widget)
 )
 db.define_table('marks',
 Field('studentid',db.auth_user,requires=IS_IN_DB(db((db.auth_user.id==db.auth_membership.user_id)(db.auth_membership.group_id==
db.auth_group.id)(db.auth_group.role=='students')),'auth_user.id
 ','auth_user.first_name'),readable=False,writable=False),
 Field('marks','integer'))



 def doing_paper():
 pid=auth.user_id
 q_num=int(request.vars.q_num)
 question=db((q_num==db.ins_ques.qnum)).select(db.ins_ques.ALL)
 val=db(db.ins_ques).select(db.ins_ques.ALL)
 rmax=0
 for f in val:
   rmax+=1
 if (q_num = 0):
 response.flash='This is the first question'
 q_num=1
 redirect(URL(r=request,f='doing_paper?q_num=%s') % (q_num) )
 elif (len(question)  0) :
 for i in question:
 if i:
 question=i
 break
 else:
 q_num=q_num-1
 redirect(URL(r=request,f='preprocess?q_num=%s') % (q_num))
 else:
 q_num=q_num-1
 redirect(URL(r=request,f='preprocess?q_num=%s') % (q_num))
 if question:
 form=SQLFORM.factory(db.ans_ques)
 form.vars.qnum=q_num
 form.vars.studentid=pid

 answered=db((db.ans_ques.answer!='||')(db.ans_ques.studentid==pid)).select(db.ans_ques.qnum)
 n=[]
 for k in answered:
 n.append(k['qnum'])

 ans_yet=db((db.ans_ques.studentid==pid)(db.ans_ques.qnum==q_num)).select(db.ans_ques.answer)
 if(ans_yet and ans_yet[0]['answer']!='||'):
 form.vars.answer=ans_yet[0]['answer']
 if form.accepts(request.vars,session):
 if
 db((db.ans_ques.qnum==q_num)(db.ans_ques.studentid==pid)).select(db.ans_ques.answer):

 db((db.ans_ques.qnum==q_num)(db.ans_ques.studentid==pid)).update(answer=form.vars.answer)
 else:
 db.ans_ques.insert(answer=form.vars.answer,qnum=q_num,studentid=pid)
 q_num=q_num+1
 redirect(URL(r=request,f='doing_paper?q_num=%s') % (q_num))
 return locals()

 Regards
 Sai Harsh

 --
 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.
 For more options, visit https://groups.google.com/d/optout.


-- 
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.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Re: module vs plugin

[Fabiano Almeida]

Thanks Vikash!

2015-07-15 14:15 GMT-03:00 Vikash Sharma vikash0...@gmail.com:

 Module defines grouping logic at one place, the way you want to design it.
 Example, all customer database, order details, vendor details and
 respective operation are organised  implemented separately. Read more
 about cohesion and coupling on wiki

 Plugins is more like a features you can attach to your system or removed,
 if required. Now this plugin implementation might modularized within itself
 for better design. Example, you include features in eclipse ide as plugins.
 Another example would be: Lets say you are selling a base product to all
 your customer at a price X. Now, based on customer requirement, specify
 features/plugins can be added or attached to this base system.



 Regards,
 Vikash Sharma
 vikash0...@gmail.com

 On Wed, Jul 15, 2015 at 10:17 PM, Fabiano Almeida fabi...@techno7.com.br
 wrote:

 Hi Anthony,

 I think add plugins to build a system. Eg customer registration, product
 registration, shopping trolley, service order, reports, etc.

 thks

 Fabiano.

 --
 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.
 For more options, visit https://groups.google.com/d/optout.


  --
 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.
 For more options, visit https://groups.google.com/d/optout.


-- 
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.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Re: module vs plugin

[Fabiano Almeida]

Hi Anthony,

I think add plugins to build a system. Eg customer registration, product
registration, shopping trolley, service order, reports, etc.

thks

Fabiano.

-- 
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.
For more options, visit https://groups.google.com/d/optout.

[web2py] module vs plugin

[Fabiano Almeida]

Hi @ll!

I think about modularize my aplication. Then the question is: module or
plugin? What's the difference?

Thanks!

Fabiano.

-- 
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.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Re: does every controller function require a view?

[Fabiano Almeida]

or init function name with double underscore:

def __test():
pass

the __ make function usable in your code, but not visible in browser.

Fabiano.

2015-06-23 15:30 GMT-03:00 Niphlod niph...@gmail.com:

 if you plan to use functions in controllers that MAY NOT be seen by users,
 just define them with a parameter (a dummy one works fine)

 def this_function_is_accessible():
 pass

 def this_is_not_accessible(dummy=None):
 pass


 On Tuesday, June 23, 2015 at 7:27:42 PM UTC+2, Alex Glaros wrote:

 some functions are not viewed by user; they just return data to another
 function.  Do those need a view?

 I ask because if it crashes, then user may see the raw view

 thanks

 Alex Glaros

  --
 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.
 For more options, visit https://groups.google.com/d/optout.


-- 
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.
For more options, visit https://groups.google.com/d/optout.

[web2py] Convert picture to pdf

[Fabiano Almeida]

Hi!

It's possible convert one or many pictures in unique pdf file in web2py?
USer select one or more pictures stored in app and download a pdf file with
selected images.

Thanks,

Fabiano.

-- 
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.
For more options, visit https://groups.google.com/d/optout.

[web2py] How to register custom events in auth_event?

[Fabiano Almeida]

Hi @ll!

After performing a specific operation system, I need the record in
auth_event. How to do?

thanks in advance,

Fabiano.

-- 
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.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: How to register custom events in auth_event?

[Fabiano Almeida]

origin = ''
description=''
db.auth_event.insert(time_stamp=request.now, client_ip=request.client, 
user_id=auth.user.id, origin=origin, description=description)

Em quinta-feira, 11 de junho de 2015 13:20:29 UTC-3, Fabiano Almeida 
escreveu:

 Hi @ll!

 After performing a specific operation system, I need the record in 
 auth_event. How to do?

 thanks in advance,

 Fabiano.


-- 
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.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Re: How to register custom events in auth_event?

[Fabiano Almeida]

Great! Thanks a lot!

Fabiano.

2015-06-11 15:56 GMT-03:00 黄祥 steve.van.chris...@gmail.com:

 please take a look at this discussion :
 https://groups.google.com/forum/#!topic/web2py/sp4fpYz36HI

 best regards,
 stifan

  --
 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.
 For more options, visit https://groups.google.com/d/optout.


-- 
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.
For more options, visit https://groups.google.com/d/optout.

[web2py] Redirect page after submit load form

[Fabiano Almeida]

Hello,

I am using the LOAD to load a SQLFORM.factory another function as test.
Works correctly, except that does the redirect that has the function call.

My code:

def index():
user = db(db.auth_user.id == auth.user.id).select().first()
if not user.job: form = LOAD('ponto', 'function1.load', ajax=True)
elif user.inloco: form = LOAD('ponto', 'function2.load', ajax=True)
else: form = LOAD('ponto', 'function3.load', ajax=True)
return dict(form=form)

def function1():
form = SQLFORM.factory(...)
if form.accepts(request,session):
(...code...)
redirect(URL('default', 'index')
elif form.errors:
response.flash=Try again
else:
response.flash=Please, fill the form
return dict(form=form)


def function2():
form = SQLFORM.factory(...)
if form.accepts(request,session):
(...code...)
redirect(URL('default', 'index')
elif form.errors:
response.flash=Try again
else:
response.flash=Please, fill the form
return dict(form=form)


def function3():
form = SQLFORM.factory(...)
if form.accepts(request,session):
(...code...)
redirect(URL('default', 'index')
elif form.errors:
response.flash=Try again
else:
response.flash=Please, fill the form
return dict(form=form)

How to redirect after  submit?

Thanks in advance,

Fabiano.

-- 
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.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] SQLFORM.factory fails to save to database, id is null

[Fabiano Almeida]

try:

db.table.insert(f_name=form.vars.f_name)

2014-09-23 6:10 GMT-03:00 Andy Joel ak_j...@hotmail.com:

 I have a very simple form processing page in my controller:

 def new():
 form = SQLFORM.factory(
 Field('f_name', label='Your name', requires=IS_NOT_EMPTY()),
 )
 if form.process().accepted:
 db.table.insert(**form.vars)
 response.flash = 'form accepted'
 elif form.errors:
 response.flash = 'form has errors'
 else:
 response.flash = 'please fill the form'
 return dict(form=form)

 If I leave the form blank, it says there are errors, I fill it in, it says
 the form is accepted. But it fails to update the database, giving this
 error:

 class 'psycopg2.IntegrityError' null value in column id violates
 not-null constraint DETAIL: Failing row contains (null, Boris, T,
 2014-09-23 10:03:30, 11, 2014-09-23 10:03:30, 11).
 What is curious is that I have used this successfully to populate the
 table:
 db.table.insert(f_name='Mary')

 I am guessing form.vars includes a value for ID, and Web2Py is trying to
 write this to the database (postgreSQL by the way), rather than allowing
 the database to assign a value, and so the database objects.

 Looks like it may be a bug, but I may well be missing something.

 --
 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.
 For more options, visit https://groups.google.com/d/optout.


-- 
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.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] class 'sqlite3.IntegrityError' foreign key constraint failed

[Fabiano Almeida]

If your table definitions are right, try delete database and run your app
again...

2014-09-22 18:01 GMT-03:00 Anna Kostikova anna.kostik...@gmail.com:

 Hi everyone,

 I am having an issue when editing content of one of the tables in my
 database. When I try to edit a record in the table I have an error message
 class 'sqlite3.IntegrityError' foreign key constraint failed. The
 bizarre thing is that it doesn't matter which column I am trying to edit
 (via appadmin control panel) - i have exactly same message. For instance, I
 have a column description that doesn't have any keys on it (or
 references), but I can't edit the content of this field and I keep getting
 the error above.

 What might be causing the issue?
 I am using python 2.7.7 and web2py 2.9.5

 Thanks
 Anna

 --
 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.
 For more options, visit https://groups.google.com/d/optout.


-- 
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.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Re: Virtual Fields in auth_user?

[Fabiano Almeida]

Hi Massimo,

I tried this:

auth.settings.extra_fields['auth_user']= [
...
Field('dept_grid', compute = lambda row:
Departamento[row['departamento_id']].nome if row['departamento_id'] else
None, label = 'Departamento'),
Field.Virtual('dept_name', lambda row:
Departamento[row.departamento_id].nome if row.departamento_id else None,
label = 'Departamento')]

The compute field work, the virtual field does not work. And the error by
calling the table in SQLFORM.grid:

AttributeError: 'Row' object has no attribute 'dept_name'


Can I use virtual field to display information from another table?

Thanks,

Fabiano.


2014-07-10 3:55 GMT-03:00 Massimo Di Pierro massimo.dipie...@gmail.com:

 auth.settings.extra_fields['auth_user'] = [Field.Virtual(), ... ]


 On Wednesday, 9 July 2014 13:14:14 UTC-5, Fabiano Almeida wrote:

 Hi again,

 It's possible insert virtual field in auth_user? how?

 thanks,

 Fabiano.

  --
 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.
 For more options, visit https://groups.google.com/d/optout.


-- 
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.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Recompute all instances of a computed field

[Fabiano Almeida]

Hi Johann,

I recently update manually compute field. You have presented a better way,
and still counter to monitor the process. Very nice!

Congratulations!

Fabiano.


2014-07-10 10:39 GMT-03:00 Johann Spies johann.sp...@gmail.com:

 Sorry, I sent it before finishing


 #!/usr/bin/python
 # -*- coding: utf-8 -*-
 rows = db(db.urlop.id  0).select(db.urlop.ilosc_dni,
 db.termin_od, db.termin_do)
 howmany = len(rows)
 busy_with = 0
 for row in rows:
  busywith += 1
  print 'busy with %d of %d' % (busywith, howmany)
  row.update_record(ulosc_dni = db.urlop.ulosc_dni.compute(row))
 db.commit()


 Regards
 Johann

 --
 Because experiencing your loyal love is better than life itself,
 my lips will praise you.  (Psalm 63:3)




 --
 Because experiencing your loyal love is better than life itself,
 my lips will praise you.  (Psalm 63:3)

 --
 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.
 For more options, visit https://groups.google.com/d/optout.


-- 
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.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Re: SQLEDITABLE: redirect after submit

[Fabiano Almeida]

Hi Samurai,

I tried other way: use 2 buttons: sqleditable submit to save grid, then a
second button to process new data and redirect to other page. I think this
is not the best way...

Fabiano.


2014-07-09 5:33 GMT-03:00 samurai shub.jain1...@gmail.com:

 If u have got the answer then please share with us also.


 On Wednesday, July 9, 2014 4:30:59 AM UTC+5:30, Fabiano Almeida wrote:

 Hi,

 Has like 'accepted' attribute in SQLEDITABLE?

 I need redirect to other page after 'ok' click.

 Thanks,

 Fabiano.

  --
 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.
 For more options, visit https://groups.google.com/d/optout.


-- 
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.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Re: SQLEDITABLE: redirect after submit

[Fabiano Almeida]

Hi Kato,

Thanks again!!

Fabiano.


2014-07-09 8:52 GMT-03:00 'kato' via web2py-users web2py@googlegroups.com:

 Hi.

 You can write same as SQLFORM.

 example.
 def demo070():
 response.title = 'demo070'
 response.view = 'plugin_sqleditable/sample.html'
 editable = SQLEDITABLE(db.employee_sheet, showid=False, maxrow=5)
 if editable.accepts(request.vars, session):
 response.flash = T('editable accepted')
 elif editable.errors:
 response.flash = T('editable has errors')
 else:
 response.flash = T('please fill out the editable')
 return dict(editable=editable)

 def demo071():
 response.title = 'demo071'
 response.view = 'plugin_sqleditable/sample.html'
 editable = SQLEDITABLE(db.employee_sheet, showid=False, maxrow=5)
 if editable.process().accepted:
 response.flash = T('editable accepted')
 elif editable.errors:
 response.flash = T('editable has errors')
 else:
 response.flash = T('please fill out the editable')
 return dict(editable=editable)

 2014年7月8日火曜日 20時00分59秒 UTC-3 Fabiano Almeida:

 Hi,

 Has like 'accepted' attribute in SQLEDITABLE?

 I need redirect to other page after 'ok' click.

 Thanks,

 Fabiano.

  --
 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.
 For more options, visit https://groups.google.com/d/optout.


-- 
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.
For more options, visit https://groups.google.com/d/optout.

[web2py] query with multiple values

[Fabiano Almeida]

Hi,

How to make a query with multiple values to field?


q = db(db.auth_membership.group_id in [2,3,4]).select()

thanks,

Fabiano.

-- 
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.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Re: SQLEDITABLE: redirect after submit

[Fabiano Almeida]

Thanks Kato!

Fabiano.


2014-07-09 9:24 GMT-03:00 'kato' via web2py-users web2py@googlegroups.com:

 I was a little wrong. If you want to redirect, and will not work because
 such in the ajax.
 Please write as the following.

 def demo050():
 response.title = 'demo050'
 response.view = 'plugin_sqleditable/sample.html'
 editable = SQLEDITABLE(db.employee_sheet, showid=False, maxrow=5,
 deletable=True).process(next=URL('static', 'success.html'))
 return dict(editable=editable)



 2014年7月9日水曜日 8時52分21秒 UTC-3 kato:

 Hi.

 You can write same as SQLFORM.

 example.
 def demo070():
 response.title = 'demo070'
 response.view = 'plugin_sqleditable/sample.html'
 editable = SQLEDITABLE(db.employee_sheet, showid=False, maxrow=5)
 if editable.accepts(request.vars, session):
 response.flash = T('editable accepted')
 elif editable.errors:
 response.flash = T('editable has errors')
 else:
 response.flash = T('please fill out the editable')
 return dict(editable=editable)

 def demo071():
 response.title = 'demo071'
 response.view = 'plugin_sqleditable/sample.html'
 editable = SQLEDITABLE(db.employee_sheet, showid=False, maxrow=5)
 if editable.process().accepted:
 response.flash = T('editable accepted')
 elif editable.errors:
 response.flash = T('editable has errors')
 else:
 response.flash = T('please fill out the editable')
 return dict(editable=editable)

 2014年7月8日火曜日 20時00分59秒 UTC-3 Fabiano Almeida:

 Hi,

 Has like 'accepted' attribute in SQLEDITABLE?

 I need redirect to other page after 'ok' click.

 Thanks,

 Fabiano.

  --
 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.
 For more options, visit https://groups.google.com/d/optout.


-- 
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.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] query with multiple values

[Fabiano Almeida]

Hi Vinicius,

I tested it contains, but it did not work with integer field.

Thanks,

Fabiano.


2014-07-09 12:55 GMT-03:00 Vinicius Assef vinicius...@gmail.com:

 Use contains [1].

 [1]
 http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#like--regexp--startswith--endswith--contains--upper--lower

 On Wed, Jul 9, 2014 at 12:47 PM, Fabiano Almeida fabi...@techno7.com.br
 wrote:
  Hi,
 
  How to make a query with multiple values to field?
 
 
  q = db(db.auth_membership.group_id in [2,3,4]).select()
 
  thanks,
 
  Fabiano.
 
  --
  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.
  For more options, visit https://groups.google.com/d/optout.

 --
 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.
 For more options, visit https://groups.google.com/d/optout.


-- 
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.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Re: query with multiple values

[Fabiano Almeida]

Hi Leonel,

belongs solve my question.

Thanks.

Fabiano.


2014-07-09 13:02 GMT-03:00 Leonel Câmara leonelcam...@gmail.com:

 q = db(db.auth_membership.group_id.belongs([2,3,4]).select()

 Also see:

 http://www.web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#belongs

 --
 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.
 For more options, visit https://groups.google.com/d/optout.


-- 
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.
For more options, visit https://groups.google.com/d/optout.

[web2py] help with join

[Fabiano Almeida]

Hi,

I'm trying to do a join table auth_user and auth_membership. I need the
list of users with membership.group_id in [2,3,4].

I tried to create a query for membership before the join, but it did not
work.

Is to make this join? How?

Thanks in advance,

Fabiano.

-- 
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.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Re: help with join

[Fabiano Almeida]

Great Leonel!

Thanks a lot!

Fabiano.


2014-07-09 13:31 GMT-03:00 Leonel Câmara leonelcam...@gmail.com:

 list_of_users_in_all_groups = db( (db.auth_membership.group_id.belongs([2,
 3, 4]))  (db.auth_membership.userd_id == db.auth_user.id)
 ).select(db.auth_user.ALL)

 --
 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.
 For more options, visit https://groups.google.com/d/optout.


-- 
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.
For more options, visit https://groups.google.com/d/optout.

[web2py] Virtual Fields in auth_user?

[Fabiano Almeida]

Hi again,

It's possible insert virtual field in auth_user? how?

thanks,

Fabiano.

-- 
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.
For more options, visit https://groups.google.com/d/optout.

[web2py] How to mark mandatory fields in SQLFORM.grid?

[Fabiano Almeida]

Hi @all!

I am using SQLFORM.grid extensively in my application. How to visually mark 
the required fields on the form when the user adds record?

Thanks in advance,

Fabiano.

-- 
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.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Re: How to mark mandatory fields in SQLFORM.grid?

[Fabiano Almeida]

Hi Anthony,

Great plugin!

Thanks,

Fabiano.


2014-07-09 18:15 GMT-03:00 Anthony abasta...@gmail.com:

 There is also this plugin, which automates the process based on field
 validators: http://dev.s-cubism.com/plugin_notemptymarker

 Anthony


 On Wednesday, July 9, 2014 5:12:57 PM UTC-4, Anthony wrote:

 You can do something like this in your models:

 required = SPAN('* required', _class='required')

 db.define_table('mytable', Field('myfield', comment=required))

 Use CSS to style the comment (e.g., make the text red).

 Anthony

 On Wednesday, July 9, 2014 4:08:00 PM UTC-4, Fabiano Almeida wrote:

 Hi @all!

 I am using SQLFORM.grid extensively in my application. How to visually
 mark the required fields on the form when the user adds record?

 Thanks in advance,

 Fabiano.

  --
 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.
 For more options, visit https://groups.google.com/d/optout.


-- 
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.
For more options, visit https://groups.google.com/d/optout.

[web2py] SQLEDITABLE : writable=False dosen't work

[Fabiano Almeida]

Hi!,

I'm trying to use SQLEDITABLE plugin with readable and writable attributes.

readable = False, hide the field. OK.

writable = False, the field remains editable.

How to leave only a few editable fields?

Thanks,

Fabiano.

-- 
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.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: SQLEDITABLE : writable=False dosen't work

[Fabiano Almeida]

Sorry, my fault  I configured writable = False for wrong field o.O

thanks,

Fabiano.


Em terça-feira, 8 de julho de 2014 18h16min06s UTC-3, Fabiano Almeida 
escreveu:

 Hi!,

 I'm trying to use SQLEDITABLE plugin with readable and writable attributes.

 readable = False, hide the field. OK.

 writable = False, the field remains editable.

 How to leave only a few editable fields?

 Thanks,

 Fabiano.


-- 
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.
For more options, visit https://groups.google.com/d/optout.

[web2py] SQLEDITABLE: redirect after submit

[Fabiano Almeida]

Hi,

Has like 'accepted' attribute in SQLEDITABLE?

I need redirect to other page after 'ok' click.

Thanks,

Fabiano.

-- 
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.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] SQLEDITABLE plugin

[Fabiano Almeida]

Thanks Kato!!!

Now I get it!!


2014-07-07 8:30 GMT-03:00 kato hi21...@gmail.com:

 I will add a postscript. you can write as below.

 def demo031():
 def record():
 rows = db(db.employee_sheet.resigned == True).select(limitby=(0,3))
 return [row.id for row in rows.sort(lambda
 row:row.employee_number)]

 response.title = 'demo030'
 response.view = 'plugin_sqleditable/sample.html'
 editable = SQLEDITABLE(db.employee_sheet,
 record=record(),showid=False,

 maxrow=5).process()
 return dict(editable=editable)

 If you use primarykey and multiple key fields, you need to write list of
 list in record parameter.


 2014-07-07 5:51 GMT-03:00 'kato' via web2py-users web2py@googlegroups.com
 :

 Hi fabiano.

 It is not possible to pass a query currently.
 But record parameter is so callable, please set there.
 Please see to the demo5
 http://docs1.erp2py.com/sqleditable/demo/demo_en.html#demo5 .

 thanks.

 2014年7月6日日曜日 15時19分04秒 UTC-3 Fabiano Almeida:

 Hi kato!

 How to use SQLEDITABLE with a query?

 If I try this in your first example:

 query = db.employee_sheet.resigned == True
 editable = SQLEDITABLE(query, showid=False, maxrow=5).process()

 Return error:


 AttributeError: 'Query' object has no attribute '_id'

 How to filter table?

 Thanks,

 Fabiano



 2014-07-01 10:12 GMT-03:00 'kato' via web2py-users 
 web...@googlegroups.com:

 Hi.

 I tried to make SQLEDITABLE plugin.

 demo-page: http://docs1.erp2py.com/sqleditable/demo/demo_en.html

 It is similar as gluon/contrib/spreadsheet. But, it is easy to use more.
 If you are interested, please try.

 Thanks.

 --
 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+un...@googlegroups.com.
 For more options, visit https://groups.google.com/d/optout.


  --
 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 a topic in the
 Google Groups web2py-users group.
 To unsubscribe from this topic, visit
 https://groups.google.com/d/topic/web2py/PQE1JJwv0Bc/unsubscribe.
 To unsubscribe from this group and all its topics, send an email to
 web2py+unsubscr...@googlegroups.com.

 For more options, visit https://groups.google.com/d/optout.


  --
 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.
 For more options, visit https://groups.google.com/d/optout.


-- 
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.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] SQLEDITABLE plugin

[Fabiano Almeida]

Hi kato!

How to use SQLEDITABLE with a query?

If I try this in your first example:

query = db.employee_sheet.resigned == True
editable = SQLEDITABLE(query, showid=False, maxrow=5).process()

Return error:


AttributeError: 'Query' object has no attribute '_id'

How to filter table?

Thanks,

Fabiano



2014-07-01 10:12 GMT-03:00 'kato' via web2py-users web2py@googlegroups.com
:

 Hi.

 I tried to make SQLEDITABLE plugin.

 demo-page: http://docs1.erp2py.com/sqleditable/demo/demo_en.html

 It is similar as gluon/contrib/spreadsheet. But, it is easy to use more.
 If you are interested, please try.

 Thanks.

 --
 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.
 For more options, visit https://groups.google.com/d/optout.


-- 
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.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] How to choose a subcategory to create a post

[Fabiano Almeida]

Can you try use plugin:
http://dev.s-cubism.com/plugin_lazy_options_widget


2014-07-03 6:53 GMT-03:00 Капылов Данил kapylovda...@gmail.com:

 1) Post created in a particular category. -
 http://hostname/app/default/created_ad/category

 2)The category tied subcategories.

 How to make that SQLFORM display only radio button of equal sub
 categories. Not show subcategories not belong to this category.


 https://lh6.googleusercontent.com/-1fPHpZIZWus/U7Un7A7o-7I/GUM/ARW_lvfxgyw/s1600/web2py.png


 def get_category():
 category_url_name = request.args(0)
 category = db.category(url_name=category_url_name)
 if not category:
 session.flash = 'page not fount'
 redirect(URL('index'))
 return category

 def created_ad():
 category = get_category()
 db.ad_post.category.default = category.id
* form = SQLFORM(db.ad_post).process(next='view_post/[id]')*
 return locals()


 db.define_table('ad_post',
 Field('category', 'reference category'),
* Field('subcategory', 'reference subcategory',
 widget=SQLFORM.widgets.radio.widget,*
 *  requires=IS_IN_DB(db, db.subcategory.id
 http://db.subcategory.id, label='db.category.name
 http://db.category.name')),*
 Field('title', type='string', requires=IS_NOT_EMPTY()),
 Field('body', type='text', requires=IS_NOT_EMPTY()),
 auth.signature
 )

 --
 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.
 For more options, visit https://groups.google.com/d/optout.


-- 
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.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] create an update page (similar to profile page in default application)

[Fabiano Almeida]

Need convert request to int:
int(request.post_vars.pid)

Fabiano.


2014-07-02 8:05 GMT-03:00 Shubham Jain shub.jain1...@gmail.com:

 I want to create an update page just like profile page in default
 application. Actually I am passing the primary key of a table by a button
 click to the product_update page. In the controller of the update page I
 tried these 2 codes.

 def product_edit():
 db.products.product_id.writable=FALSE   # to make product_id
 non editable
 db.products.product_id.readable=TRUE
 testform =
 SQLFORM(db.products,db(db.products.product_id==request.post_vars.pid).select(),
  fields=['product_id','price','pro_type','tags','category','description']))
 return dict(form=testform)


  
 --OR-

 dform =
 SQLFORM(db.products,record=db(db.products.product_id==request.post_vars.pid).select(),
 fields=['product_id','price','pro_type','tags','category','description'])
 return dict(form=dform)

   pid - name of the input which has the product_id.
 But these don't work.

 Error Generated: TypeError: list indices must be integers, not str

  --
 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.
 For more options, visit https://groups.google.com/d/optout.


-- 
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.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] SQLEDITABLE plugin

[Fabiano Almeida]

Very Nice!

Thank you very much!


2014-07-01 10:12 GMT-03:00 'kato' via web2py-users web2py@googlegroups.com
:

 Hi.

 I tried to make SQLEDITABLE plugin.

 demo-page: http://docs1.erp2py.com/sqleditable/demo/demo_en.html

 It is similar as gluon/contrib/spreadsheet. But, it is easy to use more.
 If you are interested, please try.

 Thanks.

 --
 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.
 For more options, visit https://groups.google.com/d/optout.


-- 
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.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Re: lambda cannot contain assignment

[Fabiano Almeida]

Hi Anthony,

It worked! Now I understand better how to use callback.

Thank you very much!!

Fabiano.

2014-06-12 16:13 GMT-03:00 Anthony abasta...@gmail.com:

 lambda qset, f:
 f.update(cadastro=request.now if f['status'] in ['Edição', 'Enviado']
 else None)

-- 
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.
For more options, visit https://groups.google.com/d/optout.

[web2py] lambda cannot contain assignment

[Fabiano Almeida]

Hi,

In a table I need to change the field value (name: cadastro, type:
datetime) to request.now depending on the value assigned to another field
(name: status) of the same record.

I thought of using the _before_update callbcak for this purpose:

db.solicitacao._before_update.append(lambda f: f.cadastro=request.now if
(f.status == 'Edição') or (f.status =='Enviado') else None)

Thus returns the message *lambda cannot contain assignment*

Any suggestions?

Thanks in advance,

Fabiano.

-- 
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.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Uploading a Package

[Fabiano Almeida]

Hi,

If you have application in tgz, unpack and copy to
web2py_folder/application/your_application.


2014-06-10 6:26 GMT-03:00 Priyank Yadav priyankyada...@gmail.com:

 Hello,
 I am new to web2py. Somebody sent me a tgz file which contained the source
 code.
 I am trying to upload thar code in my admin interface but first i have to
 convert that into w2p extension...
 Help
 Thank you

 --
 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.
 For more options, visit https://groups.google.com/d/optout.


-- 
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.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] create a link SQLFORM to another table with id.belongs

[Fabiano Almeida]

Hi,

Sorry for my poor english, by lazy, sometimes I use google translate
(portuguese - english), and don't check the translation.

table1_inv_record = request.args(0)

In this line you get de first args, but on click to edit record in grid,
the function it's called again and url change args, then first args in url
is 'edit', and this is literal, not numerical.

row = db(db.table1.id==table1_inv_record).select()

In edit mode (and changed url), get error because var table1_inv_record is
not numerical at this time. I think this is a line in your traceback error.

So I use try...except block to convert first arg in integer, if ok, use
session to store de right id sent in the original url.

 alm = None # this is for prevent error case haven't args(0)
 if request.args: alm = request.args(0)
   try:
   if alm:
   alm = int(alm)
   *session.almoxarifado*=alm# this line executes only if the
 previous line no error
   except ValueError:
   pass
 Objeto.almoxarifado_id.default = *session.almoxarifado*






2014-06-09 13:47 GMT-03:00 LoveWeb2py atayloru...@gmail.com:

 Hi Fabiano,

 Thank you for your reply. What do you mean by *edit the registry of URL
 arguments are changed. *

 Here is my code:
 def query_table2():
table2_records = []
table1_inv_record = request.args(0)
row = db(db.table1.id==table1_inv_record).select()
for line in row:
   joined_records = line.inv_id
query=db.table1.id.belongs(joined_records)
grid=SQLFORM.grid(query, user_signature=False)
return dict(grid=grid)

 view for query_table2.html:
{{=grid}}



 On Friday, June 6, 2014 3:43:12 PM UTC-4, Fabiano Almeida wrote:

 type 'exceptions.ValueError' invalid literal for int() with base 10:
 'edit'

 In some part of your code has converting string to numeric type. Probably
 you should be picking up the URL argument and doing the conversion, but
 when you edit the registry of URL arguments are changed.

 In my example, I use session and try...except to resolve this.



 2014-06-06 15:29 GMT-03:00 Fabiano Almeida fab...@techno7.com.br:

 Show your code


 2014-06-06 15:18 GMT-03:00 LoveWeb2py atayl...@gmail.com:

 Now I get this error when I try to click edit on the query database:

 type 'exceptions.ValueError' invalid literal for int() with base 10:
 'edit'

 I've tried changing signature to false, but I don't think thats the
 problem.


 On Friday, June 6, 2014 1:17:39 PM UTC-4, LoveWeb2py wrote:

 yes


 On Fri, Jun 6, 2014 at 1:09 PM, Fabiano Almeida fab...@techno7.com.br
  wrote:

 Are you logged in your app?



 On Friday, June 6, 2014 1:03:35 PM UTC-4, Fabiano Almeida wrote:

 Try:

 grid = SQLFORM.grid(db.table,  user_signature=False)

 Em sexta-feira, 6 de junho de 2014 13h10min34s UTC-3, LoveWeb2py
 escreveu:

 Hi Fabiano,

 I actually was already using grid= SQLFORM.grid(db.new_table).
 That is when I get the error.

 If I do grid='' to test it and just return the table without
 SQLFORM I can see it in the view, but when I apply SQLFORM I get the 
 error
 'Rows' object has no attribute '_db'.

 I'm guessing this is because of the way SQLFORM handles the grid?
 Could there be something in  my model messing it up?

 On Friday, June 6, 2014 12:02:05 PM UTC-4, Fabiano Almeida wrote:

 Hi,

 You send var grid (see: return dict(grid=grid)). The first var
 grid is a send var to your view, de second var grid is a local
 var of your function.

 Then,
 in controller use:
 grid = SQLFORM.grid(db.new_table)
 return dict(grid=grid)

 in the view use:
 {{=grid}}

 Fabiano.


 2014-06-06 12:45 GMT-03:00 LoveWeb2py atayl...@gmail.com:

  SQLFORM isn't working for me with


 new_table = db(db.table1.id.belongs(record_ids)).select()
 if I do {{=new_table}} in my view I can see the records which
 belong to record_ids, but if I do:

 SQLFORM.grid(new_table)
 return dict(grid=grid)


 I get an error 'Rows' object has no attribute '_db'

  --
 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+un...@googlegroups.com.
 For more options, visit https://groups.google.com/d/optout.


  --
 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+un...@googlegroups.com.

 For more options, visit https://groups.google.com/d/optout.


  --
 Resources:
 - http://web2py.com
 - http://web2py.com/book (Documentation)
 - http://github.com/web2py/web2py (Source code

Re: [web2py] Re: Adding information to certain input before added to db?

[Fabiano Almeida]

Other way is before and after callbacks
http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#before-and-after-callbacks

If necessary, you can call function:
db.table1._before_insert.append( lambda f: my_function(f))

This way you do not need to manually enter the registry


2014-06-07 13:19 GMT-03:00 Anthony abasta...@gmail.com:

 Aside from the code below, somewhat simpler approaches would be to
 manipulate request.post_vars *before* calling SQLFORM, or using an
 onvalidation function (which allows you to change form.vars after
 validation but before the db insert). With those approaches, you don't have
 to manually do the db insert.


 On Friday, June 6, 2014 11:02:21 PM UTC-4, 黄祥 wrote:

 i think you can achieve it using form.validate :
 e.g.
 def booking():
 form = SQLFORM(db.booking_header)
 if form.validate():
 db.booking_header.insert(booking_date = form.vars.booking_date,
  buyer = form.vars.buyer,
  notes = form.vars.notes)


 Note, to avoid having to explicitly list each field, you can simply do:

 db.booking_header.insert(**db.booking_header._filter_fields(form.vars
 ))

 That will insert all the fields in form.vars that belong to
 db.booking_header.

 Anthony


 redirect(URL('report', 'report_booking') )
 return dict(form = form)

 ref :
 http://web2py.com/books/default/chapter/29/07/forms-and-validators

 best regards,
 stifan

  --
 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.
 For more options, visit https://groups.google.com/d/optout.


-- 
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.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] create a link SQLFORM to another table with id.belongs

[Fabiano Almeida]

Objeto it's the table

almoxarifado_id it's a FK (reference field)


2014-06-09 14:48 GMT-03:00 LoveWeb2py atayloru...@gmail.com:

 No problem at all and I appreciate you trying to respond to English.

 Is Object your table name and Almoxarifado_id is your id field in Objeto?

 Objeto.almoxarifado_id


 On Monday, June 9, 2014 1:30:49 PM UTC-4, Fabiano Almeida wrote:

 Hi,

 Sorry for my poor english, by lazy, sometimes I use google translate
 (portuguese - english), and don't check the translation.

 table1_inv_record = request.args(0)

 In this line you get de first args, but on click to edit record in grid,
 the function it's called again and url change args, then first args in url
 is 'edit', and this is literal, not numerical.

 row = db(db.table1.id==table1_inv_record).select()

 In edit mode (and changed url), get error because var table1_inv_record
 is not numerical at this time. I think this is a line in your traceback
 error.

 So I use try...except block to convert first arg in integer, if ok, use
 session to store de right id sent in the original url.

 alm = None # this is for prevent error case haven't args(0)
 if request.args: alm = request.args(0)
   try:
   if alm:
   alm = int(alm)
   *session.almoxarifado*=alm# this line executes only if
 the previous line no error
   except ValueError:
   pass
 Objeto.almoxarifado_id.default = *session.almoxarifado*






 2014-06-09 13:47 GMT-03:00 LoveWeb2py atayl...@gmail.com:

 Hi Fabiano,

 Thank you for your reply. What do you mean by *edit the registry of
 URL arguments are changed. *

 Here is my code:
 def query_table2():
table2_records = []
table1_inv_record = request.args(0)
row = db(db.table1.id==table1_inv_record).select()
for line in row:
   joined_records = line.inv_id
query=db.table1.id.belongs(joined_records)
grid=SQLFORM.grid(query, user_signature=False)
return dict(grid=grid)

 view for query_table2.html:
{{=grid}}



 On Friday, June 6, 2014 3:43:12 PM UTC-4, Fabiano Almeida wrote:

 type 'exceptions.ValueError' invalid literal for int() with base 10:
 'edit'

 In some part of your code has converting string to numeric type.
 Probably you should be picking up the URL argument and doing the
 conversion, but when you edit the registry of URL arguments are changed.

 In my example, I use session and try...except to resolve this.



 2014-06-06 15:29 GMT-03:00 Fabiano Almeida fab...@techno7.com.br:

 Show your code


 2014-06-06 15:18 GMT-03:00 LoveWeb2py atayl...@gmail.com:

 Now I get this error when I try to click edit on the query database:

 type 'exceptions.ValueError' invalid literal for int() with base
 10: 'edit'

 I've tried changing signature to false, but I don't think thats the
 problem.


 On Friday, June 6, 2014 1:17:39 PM UTC-4, LoveWeb2py wrote:

 yes


 On Fri, Jun 6, 2014 at 1:09 PM, Fabiano Almeida 
 fab...@techno7.com.br wrote:

 Are you logged in your app?



 On Friday, June 6, 2014 1:03:35 PM UTC-4, Fabiano Almeida wrote:

 Try:

 grid = SQLFORM.grid(db.table,  user_signature=False)

 Em sexta-feira, 6 de junho de 2014 13h10min34s UTC-3, LoveWeb2py
 escreveu:

 Hi Fabiano,

 I actually was already using grid= SQLFORM.grid(db.new_table).
 That is when I get the error.

 If I do grid='' to test it and just return the table without
 SQLFORM I can see it in the view, but when I apply SQLFORM I get 
 the error
 'Rows' object has no attribute '_db'.

 I'm guessing this is because of the way SQLFORM handles the
 grid? Could there be something in  my model messing it up?

 On Friday, June 6, 2014 12:02:05 PM UTC-4, Fabiano Almeida wrote:

 Hi,

 You send var grid (see: return dict(grid=grid)). The first var
 grid is a send var to your view, de second var grid is a local
 var of your function.

 Then,
 in controller use:
 grid = SQLFORM.grid(db.new_table)
 return dict(grid=grid)

 in the view use:
 {{=grid}}

 Fabiano.


 2014-06-06 12:45 GMT-03:00 LoveWeb2py atayl...@gmail.com:

  SQLFORM isn't working for me with


 new_table = db(db.table1.id.belongs(record_ids)).select()
 if I do {{=new_table}} in my view I can see the records which
 belong to record_ids, but if I do:

 SQLFORM.grid(new_table)
 return dict(grid=grid)


 I get an error 'Rows' object has no attribute '_db'

  --
 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+un...@googlegroups.com.
 For more options, visit https://groups.google.com/d/optout.


  --
 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

Re: [web2py] create a link SQLFORM to another table with id.belongs

[Fabiano Almeida]

def query_table2():
   table1_inv_record = None
   table2_records = []
   if request.args:
  try:
 session.table1_id = int(request.args(0))
  except:
 pass
   row = db(db.table1.id==session.table1_id).select()
   for line in row:
  joined_records = line.inv_id
   query=db.table1.id.belongs(joined_records)
   db.table1.id.default = session.table1_id
   grid=SQLFORM.grid(query, user_signature=False)
   return dict(grid=grid)


2014-06-09 17:09 GMT-03:00 LoveWeb2py atayloru...@gmail.com:

 Hi Fabiano,

 I'm still trying to get this

 For your Objeto.almoxarifado_id.default = session.almoxarifado

 Shouldn't there be a db.Objeto.almoxarifado_id ? If I try to just put
 table2.id I get an error saying table2 isn't defined.

 Here is what I have so far

 def query_table2():
table1_inv_record = None

table2_records = []
table1_inv_record = request.args(0)
row = db(db.table1.id==table1_inv_record).select()
for line in row:
   joined_records = line.inv_id
if table1_inv_record:
  inv1_record = int(table1_inv_record)
  session.table1_id = inv1_record
query=db.table1.id.belongs(joined_records)
db.table1.id.default = session.table1.id
grid=SQLFORM.grid(query, user_signature=False)
return dict(grid=grid)

 Still getting the same error though

 My db.model is like this: db.define_table('table2',
 Field('table1_inv_record', 'list:integer')

  --
 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.
 For more options, visit https://groups.google.com/d/optout.


-- 
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.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] create a link SQLFORM to another table with id.belongs

[Fabiano Almeida]

My db.py:


Almoxarifado = db.define_table('almoxarifado', Field('name'))

Objeto = db.define_table('objeto', Field('name'), Field('almoxarifado_id',
db.almoxarifado))
Objeto.almoxarifado_id.requires=IS_IN_DB(db, 'almoxarifado.id', '%(nome)s')



2014-06-09 17:09 GMT-03:00 LoveWeb2py atayloru...@gmail.com:

 Hi Fabiano,

 I'm still trying to get this

 For your Objeto.almoxarifado_id.default = session.almoxarifado

 Shouldn't there be a db.Objeto.almoxarifado_id ? If I try to just put
 table2.id I get an error saying table2 isn't defined.

 Here is what I have so far

 def query_table2():
table1_inv_record = None

table2_records = []
table1_inv_record = request.args(0)
row = db(db.table1.id==table1_inv_record).select()
for line in row:
   joined_records = line.inv_id
if table1_inv_record:
  inv1_record = int(table1_inv_record)
  session.table1_id = inv1_record
query=db.table1.id.belongs(joined_records)
db.table1.id.default = session.table1.id
grid=SQLFORM.grid(query, user_signature=False)
return dict(grid=grid)

 Still getting the same error though

 My db.model is like this: db.define_table('table2',
 Field('table1_inv_record', 'list:integer')

  --
 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.
 For more options, visit https://groups.google.com/d/optout.


-- 
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.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] create a link SQLFORM to another table with id.belongs

[Fabiano Almeida]

Hi,

Good!

db.table1.id.default = session.table1.id


This line is used to insert new record automatically by SQLFORM. For the id
field is unnecessary, it is useful when you want to set a default value, eg
FK.

All beers!!

-- 
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.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] create a link SQLFORM to another table with id.belongs

[Fabiano Almeida]

Hi,

You send var grid (see: return dict(grid=grid)). The first var grid is a
send var to your view, de second var grid is a local var of your function.

Then,
in controller use:
grid = SQLFORM.grid(db.new_table)
return dict(grid=grid)

in the view use:
{{=grid}}

Fabiano.


2014-06-06 12:45 GMT-03:00 LoveWeb2py atayloru...@gmail.com:

  SQLFORM isn't working for me with


 new_table = db(db.table1.id.belongs(record_ids)).select()
 if I do {{=new_table}} in my view I can see the records which belong to
 record_ids, but if I do:

 SQLFORM.grid(new_table)
 return dict(grid=grid)


 I get an error 'Rows' object has no attribute '_db'

  --
 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.
 For more options, visit https://groups.google.com/d/optout.


-- 
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.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] create a link SQLFORM to another table with id.belongs

[Fabiano Almeida]

Try:

grid = SQLFORM.grid(db.table,  user_signature=False)

Em sexta-feira, 6 de junho de 2014 13h10min34s UTC-3, LoveWeb2py escreveu:

 Hi Fabiano,

 I actually was already using grid= SQLFORM.grid(db.new_table). That is 
 when I get the error.

 If I do grid='' to test it and just return the table without SQLFORM I can 
 see it in the view, but when I apply SQLFORM I get the error 'Rows' object 
 has no attribute '_db'.

 I'm guessing this is because of the way SQLFORM handles the grid? Could 
 there be something in  my model messing it up?

 On Friday, June 6, 2014 12:02:05 PM UTC-4, Fabiano Almeida wrote:

 Hi,

 You send var grid (see: return dict(grid=grid)). The first var grid is a 
 send var to your view, de second var grid is a local var of your 
 function.

 Then, 
 in controller use:
 grid = SQLFORM.grid(db.new_table)
 return dict(grid=grid)

 in the view use: 
 {{=grid}}

 Fabiano.


 2014-06-06 12:45 GMT-03:00 LoveWeb2py atayl...@gmail.com:

  SQLFORM isn't working for me with 


 new_table = db(db.table1.id.belongs(record_ids)).select()
 if I do {{=new_table}} in my view I can see the records which belong to 
 record_ids, but if I do:

 SQLFORM.grid(new_table)
 return dict(grid=grid)


 I get an error 'Rows' object has no attribute '_db'

  -- 
 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+un...@googlegroups.com.
 For more options, visit https://groups.google.com/d/optout.




-- 
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.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] create a link SQLFORM to another table with id.belongs

[Fabiano Almeida]

How do you define tables?


2014-06-06 14:03 GMT-03:00 Fabiano Almeida fabi...@techno7.com.br:

 Try:

 grid = SQLFORM.grid(db.table,  user_signature=False)

 Em sexta-feira, 6 de junho de 2014 13h10min34s UTC-3, LoveWeb2py escreveu:

 Hi Fabiano,

 I actually was already using grid= SQLFORM.grid(db.new_table). That is
 when I get the error.

 If I do grid='' to test it and just return the table without SQLFORM I
 can see it in the view, but when I apply SQLFORM I get the error 'Rows'
 object has no attribute '_db'.

 I'm guessing this is because of the way SQLFORM handles the grid? Could
 there be something in  my model messing it up?

 On Friday, June 6, 2014 12:02:05 PM UTC-4, Fabiano Almeida wrote:

 Hi,

 You send var grid (see: return dict(grid=grid)). The first var grid is
 a send var to your view, de second var grid is a local var of your
 function.

 Then,
 in controller use:
 grid = SQLFORM.grid(db.new_table)
 return dict(grid=grid)

 in the view use:
 {{=grid}}

 Fabiano.


 2014-06-06 12:45 GMT-03:00 LoveWeb2py atayl...@gmail.com:

  SQLFORM isn't working for me with


 new_table = db(db.table1.id.belongs(record_ids)).select()
 if I do {{=new_table}} in my view I can see the records which belong to
 record_ids, but if I do:

 SQLFORM.grid(new_table)
 return dict(grid=grid)


 I get an error 'Rows' object has no attribute '_db'

  --
 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+un...@googlegroups.com.
 For more options, visit https://groups.google.com/d/optout.


  --
 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.
 For more options, visit https://groups.google.com/d/optout.


-- 
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.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] create a link SQLFORM to another table with id.belongs

[Fabiano Almeida]

Are you logged in your app?


2014-06-06 14:07 GMT-03:00 LoveWeb2py atayloru...@gmail.com:

 That was it! THANK YOU! Why does it work without a signature though?


 On Friday, June 6, 2014 1:03:35 PM UTC-4, Fabiano Almeida wrote:

 Try:

 grid = SQLFORM.grid(db.table,  user_signature=False)

 Em sexta-feira, 6 de junho de 2014 13h10min34s UTC-3, LoveWeb2py escreveu:

 Hi Fabiano,

 I actually was already using grid= SQLFORM.grid(db.new_table). That is
 when I get the error.

 If I do grid='' to test it and just return the table without SQLFORM I
 can see it in the view, but when I apply SQLFORM I get the error 'Rows'
 object has no attribute '_db'.

 I'm guessing this is because of the way SQLFORM handles the grid? Could
 there be something in  my model messing it up?

 On Friday, June 6, 2014 12:02:05 PM UTC-4, Fabiano Almeida wrote:

 Hi,

 You send var grid (see: return dict(grid=grid)). The first var grid is
 a send var to your view, de second var grid is a local var of your
 function.

 Then,
 in controller use:
 grid = SQLFORM.grid(db.new_table)
 return dict(grid=grid)

 in the view use:
 {{=grid}}

 Fabiano.


 2014-06-06 12:45 GMT-03:00 LoveWeb2py atayl...@gmail.com:

  SQLFORM isn't working for me with


 new_table = db(db.table1.id.belongs(record_ids)).select()
 if I do {{=new_table}} in my view I can see the records which belong
 to record_ids, but if I do:

 SQLFORM.grid(new_table)
 return dict(grid=grid)


 I get an error 'Rows' object has no attribute '_db'

  --
 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+un...@googlegroups.com.
 For more options, visit https://groups.google.com/d/optout.


  --
 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.
 For more options, visit https://groups.google.com/d/optout.


-- 
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.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] create a link SQLFORM to another table with id.belongs

[Fabiano Almeida]

Show your code


2014-06-06 15:18 GMT-03:00 LoveWeb2py atayloru...@gmail.com:

 Now I get this error when I try to click edit on the query database:

 type 'exceptions.ValueError' invalid literal for int() with base 10:
 'edit'

 I've tried changing signature to false, but I don't think thats the
 problem.


 On Friday, June 6, 2014 1:17:39 PM UTC-4, LoveWeb2py wrote:

 yes


 On Fri, Jun 6, 2014 at 1:09 PM, Fabiano Almeida fabi...@techno7.com.br
 wrote:

 Are you logged in your app?



 On Friday, June 6, 2014 1:03:35 PM UTC-4, Fabiano Almeida wrote:

 Try:

 grid = SQLFORM.grid(db.table,  user_signature=False)

 Em sexta-feira, 6 de junho de 2014 13h10min34s UTC-3, LoveWeb2py
 escreveu:

 Hi Fabiano,

 I actually was already using grid= SQLFORM.grid(db.new_table). That
 is when I get the error.

 If I do grid='' to test it and just return the table without SQLFORM
 I can see it in the view, but when I apply SQLFORM I get the error 'Rows'
 object has no attribute '_db'.

 I'm guessing this is because of the way SQLFORM handles the grid?
 Could there be something in  my model messing it up?

 On Friday, June 6, 2014 12:02:05 PM UTC-4, Fabiano Almeida wrote:

 Hi,

 You send var grid (see: return dict(grid=grid)). The first var grid
 is a send var to your view, de second var grid is a local var of
 your function.

 Then,
 in controller use:
 grid = SQLFORM.grid(db.new_table)
 return dict(grid=grid)

 in the view use:
 {{=grid}}

 Fabiano.


 2014-06-06 12:45 GMT-03:00 LoveWeb2py atayl...@gmail.com:

  SQLFORM isn't working for me with


 new_table = db(db.table1.id.belongs(record_ids)).select()
 if I do {{=new_table}} in my view I can see the records which
 belong to record_ids, but if I do:

 SQLFORM.grid(new_table)
 return dict(grid=grid)


 I get an error 'Rows' object has no attribute '_db'

  --
 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+un...@googlegroups.com.
 For more options, visit https://groups.google.com/d/optout.


  --
 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.

 For more options, visit https://groups.google.com/d/optout.


  --
 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 a topic in the
 Google Groups web2py-users group.
 To unsubscribe from this topic, visit https://groups.google.com/d/
 topic/web2py/I8aGvbVcQxk/unsubscribe.
 To unsubscribe from this group and all its topics, send an email to
 web2py+unsubscr...@googlegroups.com.
 For more options, visit https://groups.google.com/d/optout.


  --
 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.
 For more options, visit https://groups.google.com/d/optout.


-- 
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.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] create a link SQLFORM to another table with id.belongs

[Fabiano Almeida]

type 'exceptions.ValueError' invalid literal for int() with base 10:
'edit'

In some part of your code has converting string to numeric type. Probably
you should be picking up the URL argument and doing the conversion, but
when you edit the registry of URL arguments are changed.

In my example, I use session and try...except to resolve this.



2014-06-06 15:29 GMT-03:00 Fabiano Almeida fabi...@techno7.com.br:

 Show your code


 2014-06-06 15:18 GMT-03:00 LoveWeb2py atayloru...@gmail.com:

 Now I get this error when I try to click edit on the query database:

 type 'exceptions.ValueError' invalid literal for int() with base 10:
 'edit'

 I've tried changing signature to false, but I don't think thats the
 problem.


 On Friday, June 6, 2014 1:17:39 PM UTC-4, LoveWeb2py wrote:

 yes


 On Fri, Jun 6, 2014 at 1:09 PM, Fabiano Almeida fabi...@techno7.com.br
 wrote:

 Are you logged in your app?



 On Friday, June 6, 2014 1:03:35 PM UTC-4, Fabiano Almeida wrote:

 Try:

 grid = SQLFORM.grid(db.table,  user_signature=False)

 Em sexta-feira, 6 de junho de 2014 13h10min34s UTC-3, LoveWeb2py
 escreveu:

 Hi Fabiano,

 I actually was already using grid= SQLFORM.grid(db.new_table). That
 is when I get the error.

 If I do grid='' to test it and just return the table without SQLFORM
 I can see it in the view, but when I apply SQLFORM I get the error 
 'Rows'
 object has no attribute '_db'.

 I'm guessing this is because of the way SQLFORM handles the grid?
 Could there be something in  my model messing it up?

 On Friday, June 6, 2014 12:02:05 PM UTC-4, Fabiano Almeida wrote:

 Hi,

 You send var grid (see: return dict(grid=grid)). The first var grid
 is a send var to your view, de second var grid is a local var of
 your function.

 Then,
 in controller use:
 grid = SQLFORM.grid(db.new_table)
 return dict(grid=grid)

 in the view use:
 {{=grid}}

 Fabiano.


 2014-06-06 12:45 GMT-03:00 LoveWeb2py atayl...@gmail.com:

  SQLFORM isn't working for me with


 new_table = db(db.table1.id.belongs(record_ids)).select()
 if I do {{=new_table}} in my view I can see the records which
 belong to record_ids, but if I do:

 SQLFORM.grid(new_table)
 return dict(grid=grid)


 I get an error 'Rows' object has no attribute '_db'

  --
 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+un...@googlegroups.com.
 For more options, visit https://groups.google.com/d/optout.


  --
 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.

 For more options, visit https://groups.google.com/d/optout.


  --
 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 a topic in the
 Google Groups web2py-users group.
 To unsubscribe from this topic, visit https://groups.google.com/d/
 topic/web2py/I8aGvbVcQxk/unsubscribe.
 To unsubscribe from this group and all its topics, send an email to
 web2py+unsubscr...@googlegroups.com.
 For more options, visit https://groups.google.com/d/optout.


  --
 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.
 For more options, visit https://groups.google.com/d/optout.




-- 
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.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] create a link SQLFORM to another table with id.belongs

[Fabiano Almeida]

I use this:

grid for table1
def index():
return dict(grid=SQLFORM.grid(Almoxarifado, links = [lambda row:
A('Listar Objetos',_href=URL('objeto','index',args=[row.id]))],
user_signature=False, csv=False))

grid for table2
def index():
if (not request.args)  and (not request.vars):
redirect(URL('almoxarifado','index'))
alm = None
if request.args: alm = request.args(0)
try:
if alm:
alm = int(alm)
session.almoxarifado=alm
session.nomealmox = Almoxarifado[alm].nome
except ValueError:
pass
Objeto.almoxarifado_id.default = session.almoxarifado
form = SQLFORM.grid(Objeto.almoxarifado_id == session.almoxarifado,
fields=[Objeto.nome, Objeto.quantidade, Objeto.localizacao],
user_signature=False, csv=False)
return dict(form=form, nome=session.nomealmox)

-- 
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.
For more options, visit https://groups.google.com/d/optout.

[web2py] How to add button on SQLFORM.grid?

[Fabiano Almeida]

Hi,

How to add button/field on SQLFORM.grid? I need create link to edit slave
table with row id.

Thanks,

Fabiano

-- 
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.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Re: web2py CMS

[Fabiano Almeida]

Plone +1


2014-06-03 15:52 GMT-03:00 Derek sp1d...@gmail.com:

 I would recommend Plone (http://plone.org/). It's a very good Python CMS
 with a 13 year history. There's also Tactic (
 http://community.southpawtech.com/get-started) which is good, if you
 handle digital assets like video files.


 On Friday, May 30, 2014 7:21:04 AM UTC-7, Andrey K wrote:

 I am interested to add in CMS system for our web2py application.
  Quick search does not give me any solutions. Is there any CMS plugin
 already or any recipes on it?
 Any thoughts, suggestions, links and comments would be very appreciated.
 Thank you in advance!

  --
 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.
 For more options, visit https://groups.google.com/d/optout.


-- 
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.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Re: How to add button on SQLFORM.grid?

[Fabiano Almeida]

Thanks Niphlod,

Using links worked!

Fabiano.


2014-06-03 19:21 GMT-03:00 Niphlod niph...@gmail.com:

 two simple steps:
 1)  read ALL this
 http://web2py.com/books/default/chapter/29/07/forms-and-validators#SQLFORM-grid-and-SQLFORM-smartgrid
 2) if you don't know how to do it with the links argument, go to step 1)

 ^_^


 On Tuesday, June 3, 2014 9:24:26 PM UTC+2, Fabiano Almeida wrote:

 Hi,

 How to add button/field on SQLFORM.grid? I need create link to edit slave
 table with row id.

 Thanks,

 Fabiano

  --
 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.
 For more options, visit https://groups.google.com/d/optout.


-- 
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.
For more options, visit https://groups.google.com/d/optout.

[web2py] How to use createargs in SQLFORM.grid?

[Fabiano Almeida]

Hi,

How to use creatargs in SQLFORM.grid?

Table:
Objeto = db.define_table('objeto',
  SQLField('almoxarifado_id', db.almoxarifado, notnull=True, 
readable=True, writable=True, label='Almoxarifado'),
  SQLField('nome', 'string', length='50', notnull=True, label='Nome'),
  SQLField('quantidade', 'integer', notnull=True, default=0),
  SQLField('localizacao', 'string', length='50', label='Localização'),
  SQLField('obs', 'text', label='Especificação'))
Objeto.almoxarifado_id.requires=IS_IN_DB(db, 'almoxarifado.id', '%(nome)s')

def index():
alm = request.args(0) or redirect(URL('almoxarifado','index'))
form = SQLFORM.grid(Objeto.almoxarifado_id == alm, fields=[Objeto.nome, 
Objeto.quantidade, Objeto.localizacao], 
createargs={'Objeto.almoxarifado_id':alm}, user_signature=False, csv=False)
return dict(form=form)

I try create new record with field Objeto.almoxarifado_id = args(0), to 
hide this field in form.

Thanks in advance,

Fabiano.

-- 
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.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: How to use createargs in SQLFORM.grid?

[Fabiano Almeida]

In manual dont have example of createargs:

while createargs, editargs and viewargs are passed only to the specific 
 create, edit and details SQLFORMs


this is the only reference manual


Em quarta-feira, 4 de junho de 2014 00h43min27s UTC-3, Fabiano Almeida 
escreveu:

 Hi,

 How to use creatargs in SQLFORM.grid?

 Table:
 Objeto = db.define_table('objeto',
   SQLField('almoxarifado_id', db.almoxarifado, notnull=True, 
 readable=True, writable=True, label='Almoxarifado'),
   SQLField('nome', 'string', length='50', notnull=True, label='Nome'),
   SQLField('quantidade', 'integer', notnull=True, default=0),
   SQLField('localizacao', 'string', length='50', label='Localização'),
   SQLField('obs', 'text', label='Especificação'))
 Objeto.almoxarifado_id.requires=IS_IN_DB(db, 'almoxarifado.id', 
 '%(nome)s')

 def index():
 alm = request.args(0) or redirect(URL('almoxarifado','index'))
 form = SQLFORM.grid(Objeto.almoxarifado_id == alm, 
 fields=[Objeto.nome, Objeto.quantidade, Objeto.localizacao], 
 createargs={'Objeto.almoxarifado_id':alm}, user_signature=False, csv=False)
 return dict(form=form)

 I try create new record with field Objeto.almoxarifado_id = args(0), to 
 hide this field in form.

 Thanks in advance,

 Fabiano.


-- 
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.
For more options, visit https://groups.google.com/d/optout.