[web2py] Re: py4web T examples

2019-10-02 Thread greenpoise
In the Grid Example if I was to type anything on the search bar but clicked Create, it allows you to create the object but goes on a loop and does not finalize On Tuesday, October 1, 2019 at 10:35:07 PM UTC-7, Massimo Di Pierro wrote: > > Posted a couple of pluralization and

[web2py] Py4Web

2019-10-01 Thread greenpoise
Wow, I am impressed so far. I like it better than web2py. It gives developers more flexibility. Great job. -- 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)

[web2py] import Requests Error

2019-03-21 Thread greenpoise
This used to work for me: import requests import requests.auth Not anymore. I was working on OAuth2.0 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

[web2py] Interesting Project

2018-07-12 Thread greenpoise
Been jumping around different python frameworks and stumbled into Websauna . Its built on top of Pyramid (Pylons). I share it here because I thought it borough a few things from web2py (or so it looks like) and perhaps it has a few features web2py can borough from.

[web2py] Re: Strange behaviour in grid with computed field

2018-04-11 Thread greenpoise
me back to the grid nor updates whichever field I change. On Wednesday, April 11, 2018 at 1:39:56 PM UTC-7, greenpoise wrote: > > So, I have this two applications with different bootstrap versions. One is > older version with Bootstrap 3 and the grid works perfectly. I am able

[web2py] Strange behaviour between two grids and different Bootstrap versions

2018-04-11 Thread greenpoise
So, I have this two applications with different bootstrap versions. One is older version with Bootstrap 3 and the grid works perfectly. I am able to view and edit the item and it takes me back to the grid. Meanwhile the new version, Bootstrap4, I click on Edit for a specific item and I edit a

[web2py] Re: How could I create a validator to show the field based on the membership?

2018-04-10 Thread greenpoise
thanks! On Thursday, March 29, 2018 at 5:31:51 PM UTC-7, 黄祥 wrote: > > *pls try (not tested)* > has_membership_admin = 'Admin' in set(auth.user_groups.values() ) > db.table.field.readable = has_membership_admin > or > has_membership_admin = 'Admin' in set(auth.user_groups.values() ) >

[web2py] Re: Allow to add new record from formdropdown list

2018-04-05 Thread greenpoise
nevermind. Figured this one out. It does take you away from the page though. Or so it seams like. On Wednesday, April 4, 2018 at 4:33:15 PM UTC-7, greenpoise wrote: > > how can I test this? I tried following your example. Trying to accomplish > the same. Thanks > > On Thursday,

[web2py] Re: Allow to add new record from formdropdown list

2018-04-04 Thread greenpoise
how can I test this? I tried following your example. Trying to accomplish the same. Thanks On Thursday, March 22, 2018 at 3:33:29 AM UTC-7, 黄祥 wrote: > > perhaps you can do it with bootstrap modal (in views) and dal table > constructor comment > *e.g. (not tested)* > *models/db.**py* >

[web2py] Re: FYI: A tutorial on how to customize export in SQLFORM.grid

2018-04-02 Thread greenpoise
Very cool thanks On Sunday, April 1, 2018 at 12:08:30 AM UTC-7, Ray (a.k.a. Iceberg) wrote: > > Stumbled upon this blog post "Export in web2py's SQLFORM.grid > " by Prasad Muley. It provides > concrete example on how to customize an exporter TO REMOVE

[web2py] How could I create a validator to show the field based on the membership?

2018-03-29 Thread greenpoise
Is it possible to create a validator (in this case readable) only if the user belongs to a specific membership?? -- 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

[web2py] Re: How to select a table and represent the foreign key values

2018-03-29 Thread Greenpoise
On Thursday, March 29, 2018 at 12:50:45 PM UTC-4, Greenpoise wrote: >> >> Like this, in the model: >> db.define_table('table1', >> Field('field_1'), >> format='%(field_1)s') >> >> db.define_table('table2', >&g

[web2py] Re: How to select a table and represent the foreign key values

2018-03-29 Thread Greenpoise
018 at 12:28:02 PM UTC-4, Greenpoise wrote: >> >> db.table2.field_1.requires = IS_IN_DB >> <http://localhost:8000/examples/global/vars/IS_IN_DB>(db,db.table_1.field_1,'%(field_1)s') >> >> >> On Thursday, March 29, 2018 at 9:20:34 AM UTC-7, LoveWeb2py wro

[web2py] Re: How to select a table and represent the foreign key values

2018-03-29 Thread Greenpoise
db.table2.field_1.requires = IS_IN_DB (db,db.table_1.field_1,'%(field_1)s') On Thursday, March 29, 2018 at 9:20:34 AM UTC-7, LoveWeb2py wrote: > > > How can I select a foreign key and represent the value? I want to > represent the entire

[web2py] Re: OAUTH2.0 help

2018-03-20 Thread greenpoise
Thanks Dave. I will take a lookt that. The workflow is pretty much the one you sent. I found a few examples that i was able to follow with some modifications. OAuth documentation had the best one that followed exactly the same workflow i needed with the difference that the provider has a

[web2py] Re: OAUTH2.0 help

2018-03-19 Thread Greenpoise
will help me on this one), I receive json garble when I try to pull customers data. How do I parse this all nicely in a table form??? thanks On Thursday, March 15, 2018 at 2:38:08 PM UTC-7, greenpoise wrote: > > I need a push on this one. Now that I know how to properly Authenticate,

[web2py] Re: Where is Auth table on Database Administration?

2018-03-15 Thread greenpoise
; On Thursday, March 1, 2018 at 6:20:07 PM UTC-5, greenpoise wrote: >>> >>> Did anything changed that now the AUth table is not displayed on the >>> Database Administration tool?? >>> >>> >>> Thanks >>> >> -- Resources: -

[web2py] Re: self.error ProgrammingError(u'ERROR', u'42P07', u'relation ..., u'1066', u'heap_create_with_catalog'

2018-03-15 Thread greenpoise
: > > never see that error. use postgres all the time. Can you try with a fresh > db and nothing in databases... adding one table at the time? My help narrow > it down. > > On Thursday, 1 March 2018 16:37:04 UTC-6, greenpoise wrote: >> >> Hello there. >> >> Been t

[web2py] Re: OAUTH2.0 help

2018-03-15 Thread greenpoise
en = access_token *Refresh:* refresh_token_request = requests.get('https://jimbaroo.com/oauth/access_token.php', data=payload).json() payload = { "refresh_token":current.session.token, "client_secret":CLIENT_SECRET, "client_id":CLIENT_ID, &

[web2py] Re: Off Topic:Pony

2018-03-08 Thread greenpoise
Nice indeed. Thanks On Wednesday, March 7, 2018 at 3:19:14 AM UTC-8, Ramos wrote: > > Nice ... > https://ponyorm.com/ > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list

[web2py] Re: OAUTH2.0 help

2018-03-07 Thread greenpoise
Hi Dave, thanks for the input. I was able to post the temporary code and get an authentication code. I will post tomorrow my updated code. I feel i am close. Thanks -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) -

[web2py] OAUTH2.0 help

2018-03-07 Thread greenpoise
I feel I am almost there making a connection. So, following the steps of the server side, I have to: 1. Request an Authorization and Temporary Token 2. Once I receive the temporary token, 3. I have to exchanged it for an access token which I can use to access the data I have the first 2 i

[web2py] Where is Auth table on Database Administration?

2018-03-01 Thread greenpoise
Did anything changed that now the AUth table is not displayed on the Database Administration tool?? 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)

[web2py] self.error ProgrammingError(u'ERROR', u'42P07', u'relation ..., u'1066', u'heap_create_with_catalog'

2018-03-01 Thread greenpoise
Hello there. Been trying to revive an app I had and somewhere in between updates it broke which is not a big deal but here is the thing. I switched (on a new blank .py model), to postgresql from SQLITE and all I get is errors similar to this: self.errorProgrammingError(u'ERROR', u'42P07',

Re: [web2py] Re: Future releases and support

2017-10-02 Thread greenpoise
the best and easy framework to learn. Can't compare > with others on performace, robustness and other aspect, but, I repeat, for > the ease to learn was the best. > > Marvi > > > > > 2017-10-01 19:22 GMT+02:00 greenpoise <danel@gmail.com >: > >>

[web2py] Re: Future releases and support

2017-10-01 Thread greenpoise
Ill post one now: https://www.udemy.com/the-build-a-saas-app-with-flask-course/ On Scotch there is also a few very good ones complete tutorials -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) -

[web2py] Re: Future releases and support

2017-09-27 Thread greenpoise
To me and this is my opinion only, I have followed web2py for as long as I can remember. The difference between web2py and flask or even web2py and ruby (just to name another framework/language) is that web2py examples are outdated and very limited. I am able to find more updated tutorials on

Re: {Disarmed} [web2py] Re: Once again stuck with a calculation

2017-02-10 Thread Greenpoise
Perhaps its not the frameworks fault, perhaps the term MVC should not be applicable to all the frameworks or in this case to the flexibility of web2py? In any case it is certainly very interesting. I for one cant see all the code being ran down in the view specially if there is going to be

[web2py] Re: Once again stuck with a calculation

2017-02-09 Thread Greenpoise
, February 9, 2017 at 12:50:58 PM UTC-8, Greenpoise wrote: > > Thanks Leonel!! > > On Thursday, February 9, 2017 at 10:45:52 AM UTC-8, Leonel Câmara wrote: >> >> This line is wrong: >> suplidor = db().select(db.supplier.id,db.supplier.discount) >> >> It

[web2py] Re: Once again stuck with a calculation

2017-02-09 Thread Greenpoise
Thanks Leonel!! On Thursday, February 9, 2017 at 10:45:52 AM UTC-8, Leonel Câmara wrote: > > This line is wrong: > suplidor = db().select(db.supplier.id,db.supplier.discount) > > It should be *after *form.process().accepted and it should be: > > suplidor = db(db.supplier.id ==

[web2py] Re: Once again stuck with a calculation

2017-02-09 Thread Greenpoise
I posted the Traceback below. Your idea of printing the value first, how so? Thanks again On Wednesday, February 8, 2017 at 9:50:56 PM UTC-8, 黄祥 wrote: > > is there any error traceback occured? > just an idea why not print the value first? if it correct perhaps you > should change the data

[web2py] Re: Once again stuck with a calculation

2017-02-09 Thread Greenpoise
Thanks Stifan and Anthony. Anthony, I changed the code accordingly. Is a no go. Below the traceback. I am expecting the result back. Is a simple multiplication between the discount (which is according to the supplier selected by the user) and the price the user inputs in the system. THanks

[web2py] Once again stuck with a calculation

2017-02-08 Thread greenpoise
Hi, I dont work with Web2py on a daily basis but when I need a small project, I tend to come back to it to do it. I always struggle with computing/calculating values. This time I have two values, one from a db and one from a form. I want to calculate both. This is what I have for now:

[web2py] Re: How to create a front end for an external API?

2016-10-21 Thread greenpoise
Want to pull some data. There is no option to write, just pull data. -- 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

[web2py] Re: web2py + cordova + APIs

2016-10-19 Thread greenpoise
I tried cloning this to try it out (it might be the answer to my API question) but it did not work and there is no w2p extension file. How can I install to try it? thanks On Friday, October 14, 2016 at 10:41:25 AM UTC-7, Massimo Di Pierro wrote: > > So I made this: > >

[web2py] Re: How to create a front end for an external API?

2016-10-19 Thread greenpoise
RESTFUL API I meant to write On Wednesday, October 19, 2016 at 2:42:52 PM UTC-7, greenpoise wrote: > > First, I am new to API. I did read and went through the web2py book > section of API but I am still a bit lost. Is there a good example for this? > Am I asking/searching t

[web2py] How to create a front end for an external API?

2016-10-19 Thread greenpoise
First, I am new to API. I did read and went through the web2py book section of API but I am still a bit lost. Is there a good example for this? Am I asking/searching the right way? thanks -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) -

[web2py] Re: How can I customize the look and feel of SQLFORM.grid???

2016-06-17 Thread Greenpoise
The typo is just here. Where can I see the components of the grid? Thanks On Friday, June 17, 2016 at 3:42:55 PM UTC-7, Anthony wrote: > > Not sure if this is the issue, but you are missing a closing quote. > > On Friday, June 17, 2016 at 6:39:18 PM UTC-4, Greenpoise wrote

[web2py] Re: How can I customize the look and feel of SQLFORM.grid???

2016-06-17 Thread Greenpoise
like this for example? 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

[web2py] How can I customize the look and feel of SQLFORM.grid???

2016-06-17 Thread greenpoise
Should I edit web2py-bootstrap3.css directly? 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

Re: [web2py] Why is this simple join not rendering?

2016-06-17 Thread greenpoise
Thanks Massimiliano! On Friday, June 17, 2016 at 3:46:05 AM UTC-7, Massimiliano wrote: > > I think you need to refer to fields in this way: > > {{=customer.customer.first_name}} > {{=customer.customer_type.type_name}} > > On Fri, Jun 17, 2016 at 8:56 AM, Greenpoise &

[web2py] Why is this simple join not rendering?

2016-06-17 Thread Greenpoise
so I have this simple join: query = (db.customer.id > 0) & (db.customer_type.id==db.customer.customer_type) all_customers = db(query).select() return dict(all_customers = all_customers) and my view: {{for customer in all_customers:}}

[web2py] Re: Mercurial Error

2016-06-01 Thread greenpoise
On Wednesday, June 1, 2016 at 4:57:50 PM UTC-7, Dave S wrote: > > > > On Wednesday, June 1, 2016 at 4:12:50 PM UTC-7, Dave S wrote: >> >> >> >> On Wednesday, June 1, 2016 at 3:05:15 PM UTC-7, greenpoise wrote: >>> >>> My version cont

[web2py] Mercurial Error

2016-06-01 Thread greenpoise
My version control is not working. Any ideas? this is the error I get. Could it be a mercurial version error? Traceback > > 1. > 2. > 3. > 4. > 5. > 6. > 7. > 8. > 9. > 10. > > Traceback (most recent call last): > File "/home/ds/Applications/web2pyEmpty/gluon/restricted.py", line 227, in >

[web2py] The built-in web2py wiki error

2016-05-26 Thread greenpoise
I had never done this part of the book but when I tried, it gave me an error: local variable 'gid' referenced before assignmentVersion web2py™ Version 2.14.6-stable+timestamp.2016.05.10.00.21.47 Python Python 2.7.11: /usr/bin/python2.7 (prefix: /usr)Traceback 1. 2. 3. 4. 5. 6. 7. 8. 9. 10.

[web2py] Re: How can I make a calculation in the view?

2016-05-19 Thread greenpoise
I see. Thanks Anthony On Thursday, May 19, 2016 at 3:09:52 AM UTC-7, Anthony wrote: > > Though generally it is good to minimize the logic in views, as they are > more difficult to read, test, and debug. So, prefer moving such > calculations to the controller, or at least to a function that

[web2py] Re: How can I make a calculation in the view?

2016-05-19 Thread greenpoise
Thanks a million. On Wednesday, May 18, 2016 at 10:11:40 PM UTC-7, 黄祥 wrote: > > just do like usual in controller > e.g. > *controllers/default.py* > def report_investor(): > choose_investor = request.args(0) > # query > query_account = (db.account.investor == choose_investor) > > # row >

[web2py] How can I make a calculation in the view?

2016-05-18 Thread greenpoise
I have seen examples on how to calculate on DAL level using lambda. Could someone post an example (or point me to) of calculating values in the view? after an sql retrieval? or sql in the view? Thanks -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) -

Re: [web2py] Re: Auth extra fields

2016-01-07 Thread greenpoise
Thanks! On Wednesday, January 6, 2016 at 9:53:51 AM UTC-8, Anthony wrote: > > On Wednesday, January 6, 2016 at 12:42:56 PM UTC-5, Mathieu Clabaut wrote: >> >> Be careful that when you update extra fields, it is your responsibility >> to update auth.user and session.auth.user accordingly... >> >

[web2py] Auth extra fields

2016-01-05 Thread greenpoise
if auth.is_logged_in(): this_store=auth_user.store else: this_store=None Is there a way to extract the extra fields value in the controller like the code above? Thanks -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) -

[web2py] Re: Auth extra fields

2016-01-05 Thread greenpoise
auth_user is not defined. On Tuesday, January 5, 2016 at 2:26:59 PM UTC-8, Niphlod wrote: > > why not ? > > On Tuesday, January 5, 2016 at 11:24:19 PM UTC+1, greenpoise wrote: >> >> if auth.is_logged_in(): >> this_store=auth_user.store >> else: >&g

[web2py] Re: web2py 2.13.3 is OUT

2015-12-24 Thread greenpoise
I get this error upon restarting web2py after update: Traceback (most recent call last): File "Applications/web2py/web2py.py", line 6, in import gluon.widget File "/home/danel/Applications/web2py/gluon/widget.py", line 26, in import gluon.main as main File

[web2py] Re: Default value of two references only one gets the value

2015-12-22 Thread Greenpoise
Fixed it by normalizing the tables. I had a duplicate with suppliercode. Thanks On Tuesday, December 22, 2015 at 3:08:08 PM UTC-8, Anthony wrote: > > db.define_table('supplier', >> Field('suppliercode',requires=IS_UPPER()), >> format='%(suppliercode)s') >> >> db.define_table('series', >>

[web2py] Web2py 2.13.1 smartgrid issues?

2015-12-22 Thread greenpoise
Is anyone else having issues with smartgrid in version 2.13.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

[web2py] Re: Web2py 2.13.1 issues - SOLVED

2015-12-22 Thread greenpoise
Ok. I found what was going on. I really like the new look and what not. However, I had to change a lot of my field names because they were reserved words. So it was not the smartgrid having issues. On Tuesday, December 22, 2015 at 3:41:16 PM UTC-8, greenpoise wrote: > > > Is an

[web2py] Manage users

2015-12-07 Thread greenpoise
I have looked and looked with no luck. I saw this but it is not working. I am looking how to manage users within my application (not the admin). Could someone help

[web2py] Re: Manage users

2015-12-07 Thread greenpoise
Sorry, Membership and roles On Monday, December 7, 2015 at 3:07:29 PM UTC-8, Dave S wrote: > > On Monday, December 7, 2015 at 2:58:37 PM UTC-8, greenpoise wrote: >> >> >> I have looked and looked with no luck. I saw this >> <http://www.web2pyslices.c

[web2py] Re: Manage users

2015-12-07 Thread greenpoise
I read Ch9 like 10 times. Still dont know where to start. Adding extra fields does not help because I cant reference for example auth_group. On Monday, December 7, 2015 at 3:07:29 PM UTC-8, Dave S wrote: > > On Monday, December 7, 2015 at 2:58:37 PM UTC-8, greenpoise wrote: >>

[web2py] Re: What works, float type, decimal type, double or all/none of the above?

2015-07-28 Thread greenpoise
Sqlite..Thanks!! On Monday, July 27, 2015 at 5:00:55 PM UTC-7, Dave S wrote: On Monday, July 27, 2015 at 3:44:24 PM UTC-7, greenpoise wrote: So I solved this by dropping the table and creating it again. It had to do with the decimal points on the sizes. Oooo, ouch! Which database

[web2py] Re: What works, float type, decimal type, double or all/none of the above?

2015-07-27 Thread greenpoise
On Friday, July 17, 2015 at 11:05:25 AM UTC-7, Dave S wrote: On Thursday, July 16, 2015 at 10:11:16 PM UTC-7, greenpoise wrote: Well, if I comment out the sizes, everything works. I have tried using double as my field type. It doesn't work either. As Alex said, the error you posted is a Foreign

[web2py] Re: What works, float type, decimal type, double or all/none of the above?

2015-07-27 Thread greenpoise
So I solved this by dropping the table and creating it again. It had to do with the decimal points on the sizes. On Monday, July 27, 2015 at 1:59:07 PM UTC-7, greenpoise wrote: Sorry for the delay. I was out of the office. Like I said, it works if I comment out the size1 and size2 fields

[web2py] Re: What works, float type, decimal type, double or all/none of the above?

2015-07-16 Thread greenpoise
Well, if I comment out the sizes, everything works. I have tried using double as my field type. It doesn't work either. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list

[web2py] What works, float type, decimal type, double or all/none of the above?

2015-07-16 Thread greenpoise
As the subject reads. Could anyone explain to me which type works? I did an update to my application and now my calculation is giving me an error. This is what I had when it was working: Field('size1','float'), Field('size2','float'), Field('color','reference color'),

[web2py] Re: What works, float type, decimal type, double or all/none of the above?

2015-07-16 Thread greenpoise
Alex, Just noticed that it is not the calculation. The error lies in the Size 1 Size 2 of my db. These values could be decimal. So let me post this again. db: Field('size1'), Field('size2'), Field('color','reference color'), error: Traceback (most recent call last): File

[web2py] Re: Key Error after removing onupdate=auth.archive

2015-06-03 Thread greenpoise
at 6:28:18 PM UTC-4, greenpoise wrote: My application was working perfectly fine. I removed onupdate=auth.archive from my grid and now I cant view/edit records: Traceback (most recent call last): File Applications/web2py/gluon/restricted.py, line 227, in restricted exec ccode

[web2py] Key Error after removing onupdate=auth.archive

2015-06-03 Thread greenpoise
My application was working perfectly fine. I removed onupdate=auth.archive from my grid and now I cant view/edit records: Traceback (most recent call last): File Applications/web2py/gluon/restricted.py, line 227, in restricted exec ccode in environment File

[web2py] how to duplicate a record on grid?

2015-06-02 Thread greenpoise
I found two links on this topic. I have got the extra button and part of the duplicate function but it does not want to work. The error on submission for the copied record(row), *KeyError: 'dictKey'* *I was following this thread:**Thread

[web2py] Online Manual vs Pdf download - are they both 6th Edition?

2015-05-28 Thread greenpoise
Noticed the PDF one has 5th edition in it while the Online one says 6th Edition Pre Release. Is the content on both the same? -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list

[web2py] Re: How to add CSS class to SQLFORM.grid??

2014-08-06 Thread greenpoise
PM UTC-7, greenpoise wrote: How can I make use of my own td classes for SQLFORM.grid?? Thanks Does this post help? https://groups.google.com/d/msg/web2py/ZIUPdJSg0to/itkssW_zzPYJ (credit to Anthony) /dps -- Resources: - http://web2py.com - http://web2py.com/book (Documentation

[web2py] Re: How to add CSS class to SQLFORM.grid??

2014-08-06 Thread greenpoise
thanks!! I will do this On Wednesday, August 6, 2014 8:57:37 AM UTC-7, Cliff Kachinske wrote: I would go the other way and override the attributes of the existing classes with my own css. Just make sure your css loads last. On Tuesday, August 5, 2014 5:17:42 PM UTC-4, greenpoise

[web2py] How to add CSS class to SQLFORM.grid??

2014-08-05 Thread greenpoise
How can I make use of my own td classes for SQLFORM.grid?? 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

[web2py] Re: help with helper!

2014-05-15 Thread greenpoise
and href entries. That is how web2py knows you want those to wind up on the final HTML version of the element and keeps the names from colliding with Python identifiers (like class). On Wednesday, May 14, 2014 2:59:03 PM UTC-7, greenpoise wrote: I need help with this helper! I have

Re: [web2py] Re: help with helper!

2014-05-15 Thread greenpoise
10:21:48 AM UTC-7, greenpoise wrote: Yes font-awesome is what I am trying to use. Both attempts, yours and yamandu prompt me the same error (name, active, link) = item[:3] ValueError: need more than 2 values to unpack Is there a line number associated with that error message? Is item

[web2py] help with helper!

2014-05-14 Thread greenpoise
I need help with this helper! I have this a href=index.html title=Homei class=fa-home/i span class= menu-item-parentHome/span/a and I made this: [A(I(SPAN(_class=('menu-item-parent','Home')), _class='fa-home',_title= 'Home',), False, None, []),] I am missing the URL('home) cant get it to

Re: [web2py] help with helper!

2014-05-14 Thread greenpoise
I tried this but didnt work. I am using it in the menu section Thanks On Wednesday, May 14, 2014 3:59:19 PM UTC-7, yamandu wrote: Like this A(I(_class=fa-home),SPAN(Home,_class=menu-item-parent),_href=index.html, _title=Home) 2014-05-14 18:59 GMT-03:00 greenpoise danel

[web2py] OPTION helper - custom class for the drop down

2014-05-09 Thread greenpoise
How can I add a custom class for a drop down? {{=SELECT(*[OPTION(r.detail,_value=r.id) for r in row.inventory],**dict( _name='id'))}} -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) -

Re: [web2py] My db wont allow to enter decimals lower than 1.0

2014-02-14 Thread greenpoise
='too small or too large!') Do you really need to specify the value in a dropbox dynamically? If so, requires=IS_IN_SET(SIZES) don't work? Richard On Thu, Feb 13, 2014 at 5:07 PM, greenpoise danel@gmail.comjavascript: wrote: A list of decimal values from 0.1 to 50.0

[web2py] My db wont allow to enter decimals lower than 1.0

2014-02-13 Thread greenpoise
For the first time I had to enter a value that was 0.25, for some reason, it comes back with this error class 'sqlite3.IntegrityError' FOREIGN KEY constraint failed I have the field as a float type. It works with any value except from 0.1 to 0.99. I tried decimal (10,3) still nothing. --

Re: [web2py] My db wont allow to enter decimals lower than 1.0

2014-02-13 Thread greenpoise
could it be SIZES = [v*0.05 for v in range(0,int(50/0.05))] which I use to populate a select box? On Thursday, February 13, 2014 1:06:14 PM UTC-8, Richard wrote: Hmm, the message says Foreign Key constraint... Not decimal issue... Richard On Thu, Feb 13, 2014 at 4:02 PM, greenpoise

Re: [web2py] My db wont allow to enter decimals lower than 1.0

2014-02-13 Thread greenpoise
A list of decimal values from 0.1 to 50.0 On Thursday, February 13, 2014 1:47:53 PM UTC-8, Richard wrote: What is SIZES? Is it a validators? Richard On Thu, Feb 13, 2014 at 4:24 PM, greenpoise danel@gmail.comjavascript: wrote: could it be SIZES = [v*0.05 for v in range(0,int

[web2py] styleform text size change

2013-11-12 Thread greenpoise
I keep reading to do it from base.css but it is not working. My source div /div/tdtdbrinput class=string id=productsearch_qty name=qty type=text value= //td On base.css I have #productsearch_qty {width: 3px;} -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) -

Re: [web2py] styleform text size change

2013-11-12 Thread greenpoise
, greenpoise danel@gmail.comjavascript: wrote: I keep reading to do it from base.css but it is not working. My source div /div/tdtdbrinput class=string id=productsearch_qty name= qty type=text value= //td On base.css I have #productsearch_qty {width: 3px;} -- Resources

Re: [web2py] OnSelect how to?

2013-11-07 Thread greenpoise
variables in DELETE - Fixed memory leak when using the TAG helper Richard On Tue, Nov 5, 2013 at 2:42 PM, greenpoise danel@gmail.comjavascript: wrote: you mean this one? http://www.web2pyslices.com/slice/show/1724/cascading-dropdowns-simplified On Tuesday, November 5, 2013 10:57

Re: [web2py] OnSelect how to?

2013-11-05 Thread greenpoise
at 4:41 PM, greenpoise danel@gmail.comjavascript: wrote: Thanks, will check! On Monday, November 4, 2013 12:10:59 PM UTC-8, Richard wrote: Notice this : http://stackoverflow.com/**questions/17903645/where-is-** the-typeahead-javascript-**module-in-bootstrap-3-rc-1http

Re: [web2py] OnSelect how to?

2013-11-05 Thread greenpoise
if it has been documented, but there is example of the synthax on the group. Richard On Tue, Nov 5, 2013 at 12:49 PM, greenpoise danel@gmail.comjavascript: wrote: is very simple. The autocomplete works fine. The only thing that I want is once the product is searched and selected, to go

[web2py] OnSelect how to?

2013-11-04 Thread greenpoise
I have an Autocomplete widget field that goes through my product table. I need to put the selected product into a list. Rather than using the button after I select the product, ideally I would like to select the product and it automatically goes into the list and the search field stays on top.

Re: [web2py] OnSelect how to?

2013-11-04 Thread greenpoise
...@gmail.comjavascript: wrote: Do you know bootstrap typeahead? You can customized it as you want then you only have to pass a function that return a json... Richard On Mon, Nov 4, 2013 at 1:41 PM, greenpoise danel@gmail.comjavascript: wrote: I have an Autocomplete widget field that goes through

[web2py] Re: Export not working on filtered table?

2013-10-04 Thread greenpoise
This was working on version 2.6.2 and now with the 2.6.4 is no longer working! Agh On Wednesday, August 28, 2013 11:11:35 AM UTC-7, greenpoise wrote: Massimo, I opened a ticket for this. I think you couldnt reproduce the error. I now remember (I had not tried it since I opened

[web2py] Re: web2py 2.6.1 is OUT - IMPORTANT READ

2013-09-14 Thread greenpoise
Yes Hero! The export CSV works perfectly on filtered items. Thanks On Thursday, September 12, 2013 3:27:37 PM UTC-7, Massimo Di Pierro wrote: Web2py 2.6.1 is finally OUT. It needs some more testing. READ BELOW BEFORE UPGRADING Attention all users: For pre 2.6 applications to work

[web2py] Re: Field value based on other field in Dal?

2013-09-06 Thread greenpoise
it worked w quotes on..couldnt tell you which is right though On Friday, September 6, 2013 10:03:40 AM UTC-7, Anthony wrote: Probably should remove the quotes from the 2, no? On Friday, September 6, 2013 12:59:36 PM UTC-4, greenpoise wrote: Ended up using lambda instead. Field

[web2py] Re: Field value based on other field in Dal?

2013-09-06 Thread greenpoise
, September 6, 2013 1:32:32 PM UTC-4, greenpoise wrote: it worked w quotes on..couldnt tell you which is right though On Friday, September 6, 2013 10:03:40 AM UTC-7, Anthony wrote: Probably should remove the quotes from the 2, no? On Friday, September 6, 2013 12:59:36 PM UTC-4, greenpoise

[web2py] Re: Field value based on other field in Dal?

2013-09-06 Thread greenpoise
Ended up using lambda instead. Field('conversiontype','reference conversiontype',compute=lambda r: 1 ifrequest .vars.tileuse == '5' else '2'), Thanks! On Thursday, September 5, 2013 7:25:32 PM UTC-7, greenpoise wrote: Thats exactly what I am looking! Thanks, will try and post Thanks

[web2py] Re: Field value based on other field in Dal?

2013-09-06 Thread greenpoise
Worked! thanks!! On Friday, September 6, 2013 12:07:49 PM UTC-7, Anthony wrote: On Friday, September 6, 2013 2:13:44 PM UTC-4, greenpoise wrote: since is a reference, shouldnt it be an integer? hmm..a bit confused..my data looks fine for now Yes, but you have it as a string (i.e

[web2py] Re: Odd behavior IS_UPPER()

2013-09-05 Thread greenpoise
:21:48 PM UTC+2, greenpoise wrote: I was tweaking my tables to change the INPUT to upper case. All the fields that I changed it to, worked except for one field. It has this: Field('seriesname',requires=IS_UPPER()) and then at the end of the table it has

[web2py] Odd behavior IS_UPPER()

2013-09-05 Thread greenpoise
I was tweaking my tables to change the INPUT to upper case. All the fields that I changed it to, worked except for one field. It has this: Field('seriesname',requires=IS_UPPER()) and then at the end of the table it has this: db.series.seriesname.requires =

[web2py] Field value based on other field in Dal?

2013-09-05 Thread greenpoise
is it possible to have an if statement of some sort in Dal to validate/add a value based on other field? like: db.define_table('product', Field('series', 'reference series'), Field('suppliercode','reference supplier'), Field('description'), Field('tiluse','reference tileuse'),

[web2py] Re: Field value based on other field in Dal?

2013-09-05 Thread greenpoise
is created anyway). Anthony On Thursday, September 5, 2013 7:32:04 PM UTC-4, greenpoise wrote: is it possible to have an if statement of some sort in Dal to validate/add a value based on other field? like: db.define_table('product', Field('series', 'reference series'), Field

[web2py] Autocomplete on factory forms status

2013-09-04 Thread greenpoise
I have tried different examples found in the forum but it does not seem to work. Is this feature available? thanks -- --- 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

[web2py] Re: Autocomplete on factory forms status

2013-09-04 Thread greenpoise
:53:50 AM UTC-7, Massimo Di Pierro wrote: please post an example that does not work and we will check it. On Wednesday, 4 September 2013 13:09:15 UTC-5, greenpoise wrote: I have tried different examples found in the forum but it does not seem to work. Is this feature available? thanks

[web2py] Re: Autocomplete on factory forms status

2013-09-04 Thread greenpoise
an error. On Wednesday, September 4, 2013 12:31:26 PM UTC-7, greenpoise wrote: form=SQLFORM.factory(Field('tile',widget=SQLFORM.widgets.autocomplete(request,db.product.tilename))) if form.process().accepted: response.flash = 'form accepted' session.product

  1   2   3   4   >