[web2py] New Version or Update

2014-08-07 Thread Dan Kozlowski
It seems like it has been a long while for a new update or release. Does anyone know when we should expect one ? -- 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] Grid 2 list boxes first list box to restrict values in second

2014-03-20 Thread Dan Kozlowski
Is there any way within a grid with 2 list boxes that the selected value in the first list box can sub select the the second the values in the listbox ? A example would be selecting a state and only selecting cities in that state. Example : State : IL Cites : Chicago Calumet

Re: [web2py] Re: SmartGrid Add make a Fld Readonly

2014-03-18 Thread Dan Kozlowski
I found the problem after hours of testing different things. It was my mistake. I was using *writeable* when it should have been *writable*. Works perfect now. Thanks for your help On 03/17/2014 06:39 PM, 黄祥 wrote: had you already try to simplify or minimalist your app first? e.g. def

Re: [web2py] Re: SmartGrid Add make a Fld Readonly

2014-03-17 Thread Dan Kozlowski
This does not seem to work. Maybe I am asking wrong. I have 2 date fields that get updated from a batch process so I need to restrict them from input on the create and edit form. Thanks On 03/14/2014 10:11 PM, 黄祥 wrote: i think you can achieve it using conditional for that. e.g.

Re: [web2py] Re: SmartGrid Add make a Fld Readonly

2014-03-17 Thread Dan Kozlowski
I see what you are doing but still does not work. My code is below. Could I have my code in the wrong location ? def clients(): write_in_form = 'new' in request.args or 'edit' in request.args if write_in_form: db.clients.add_date.writeable=False

Re: [web2py] Re: SmartGrid Add make a Fld Readonly

2014-03-17 Thread Dan Kozlowski
I am getting the same result with a minimalist controller. The field still takes a date and updates. Do you think that is a bug or something that can not be done ? On 03/17/2014 06:39 PM, 黄祥 wrote: had you already try to simplify or minimalist your app first? e.g. def clients():

[web2py] SmartGrid Add make a Fld Readonly

2014-03-14 Thread Dan Kozlowski
Can someone tell me how within a smartgrids I can make a Fld readonly on the add and update ? I have tried the following in the controller and it does not work. db.clients.writeable=False -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) -

Re: [web2py] Re: Problem doing a sortby in Smartgird

2014-03-10 Thread Dan Kozlowski
Stifan, Thanks for your help this solved the problem after 1 year. On Fri, Mar 7, 2014 at 6:53 PM, 黄祥 steve.van.chris...@gmail.com wrote: you must set it on the dict for each table. e.g. *models/db.py* db.define_table('category', Field('name'), format = '%(name)s')

[web2py] Problem doing a sortby in Smartgird

2014-03-07 Thread Dan Kozlowski
I have had this problem since last year and it never got resolved. I have a smartgird that I need to oder by date in dec order. The grid works fine until I select a child link. It the tells me query not supported. I hope some can help. -- Resources: - http://web2py.com -

[web2py] Re: smartgrid orderby descending

2014-03-07 Thread Dan Kozlowski
Jake, Did you ever get this to work ? Reason being I think I have the same problem. On Sunday, April 21, 2013 9:47:59 AM UTC-5, Jake Lowen wrote: In a normal grid the orderby descending works just fine: grid = SQLFORM.grid(db.meetings, orderby=~db.meetings.meeting_date, )

Re: [web2py] Re: Problem doing a sortby in Smartgird

2014-03-07 Thread Dan Kozlowski
stifan, I am still have trouble after following your example. All I want to do is db.dalily_counts.add_date ~ and db.history.add_date ~ . Any chance you can look at my code below and help ? I appreciate it. def dailycounts(): grid=SQLFORM.smartgrid(db.daily_counts, orderby=None,

[web2py] Re: Query Not Supported: (1054, Unknown column 'daily_counts.add_date' in 'order clause') No records f

2013-04-16 Thread Dan Kozlowski
Shawn, I am sorry just getingt back to this. Is this a bug or it sounded like you had a work around. I get an error saying the column I'm ordering by in the master doesn't exist. -- --- You received this message because you are subscribed to the Google Groups web2py-users group. To

[web2py] SmartGrid Add Mode to Call a Function

2013-04-03 Thread Dan Kozlowski
I have a smartgird that is being used for adds, updates, and deletes and wondering how I can call a function to update a counter in the DB to keep track of how many add, updates and deletes were done in a day. -- --- You received this message because you are subscribed to the Google Groups

[web2py] Re: Problem with smartgrid no GUI Bread Crums or missing buttons for links

2013-03-12 Thread Dan Kozlowski
Attached HTML file -- --- 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

[web2py] Re: Problem with smartgrid no GUI Bread Crums or missing buttons for links

2013-03-11 Thread Dan Kozlowski
On Monday, March 4, 2013 9:06:17 PM UTC-6, Dan Kozlowski wrote: Does anyone have this same problem with a smart grid ? Running on Linux. Thanks 1.) the word grid is show to the right of the grid 2.) No boxes for Bread Crums 3.) No buttons for external links just text to the link

[web2py] Re: Problem with smartgrid no GUI Bread Crums or missing buttons for links

2013-03-11 Thread Dan Kozlowski
Same problem with Windows IE8, Linux Chrome and Linux Firefox. Below is what I have in my CSS web2py_paginator { padding: 5px; color: #333; text-align:right; background-color: #f2f2f2; padding: 5px; border-bottom: 1px solid #DDD; -- --- You received this message because you

[web2py] Re: Problem with smartgrid no GUI Bread Crums or missing buttons for links

2013-03-10 Thread Dan Kozlowski
My CCS is there and seems to be fine. Any other thoughts ? On Monday, March 4, 2013 9:06:17 PM UTC-6, Dan Kozlowski wrote: Does anyone have this same problem with a smart grid ? Running on Linux. Thanks 1.) the word grid is show to the right of the grid 2.) No boxes for Bread Crums 3

[web2py] Re: Problem with smartgrid no GUI Bread Crums or missing buttons for links

2013-03-09 Thread Dan Kozlowski
Still can't get this work. I just built a new test app and have the same problem. Does anyone which CSS the buttons would be in ? On Monday, March 4, 2013 9:06:17 PM UTC-6, Dan Kozlowski wrote: Does anyone have this same problem with a smart grid ? Running on Linux. Thanks 1.) the word

[web2py] Re: Problem with smartgrid no GUI Bread Crums or missing buttons for links

2013-03-05 Thread Dan Kozlowski
http://10.68.54.14:8000/examples/global/vars/response._vars)}} On Monday, March 4, 2013 9:06:17 PM UTC-6, Dan Kozlowski wrote: Does anyone have this same problem with a smart grid ? Running on Linux. Thanks 1.) the word grid is show to the right of the grid 2.) No boxes for Bread

[web2py] Re: Problem with smartgrid no GUI Bread Crums or missing buttons for links

2013-03-05 Thread Dan Kozlowski
Jim, I just did the following and nothing changed. Still no breadcrums or buttons.{ {extend 'layout.html'}} h1Daily Count View/h1 {{=grid}} -- --- You received this message because you are subscribed to the Google Groups web2py-users group. To unsubscribe from this group and stop

[web2py] Re: Problem with smartgrid no GUI Bread Crums or missing buttons for links

2013-03-05 Thread Dan Kozlowski
Jim, I just noticed the word grid is gone, so it must be unstyled HTML. Is there a way to make it styled ? On Tuesday, March 5, 2013 9:38:50 PM UTC-6, Jim Gregory wrote: In your original response you quoted, you had grid: followed by the HTML assigned to that key. Are you still getting the

[web2py] Problem with smartgrid no GUI Bread Crums or missing buttons for links

2013-03-04 Thread Dan Kozlowski
Does anyone have this same problem with a smart grid ? Running on Linux. Thanks 1.) the word grid is show to the right of the grid 2.) No boxes for Bread Crums 3.) No buttons for external links just text to the link Daily Count View grid: - Daily

[web2py] Re: Query Not Supported: (1054, Unknown column 'daily_counts.add_date' in 'order clause') No records f

2013-02-25 Thread Dan Kozlowski
I am running 2.3.2 on Linux with MySQL -- --- 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

[web2py] Re: Query Not Supported: (1054, Unknown column 'daily_counts.add_date' in 'order clause') No records f

2013-02-25 Thread Dan Kozlowski
I will try the latest build later today. I was also thinking to drop the schema and have DAL build it again. What is the best way to drop a schema and have Web2py build it new ? -- --- You received this message because you are subscribed to the Google Groups web2py-users group. To

[web2py] Re: Query Not Supported: (1054, Unknown column 'daily_counts.add_date' in 'order clause') No records f

2013-02-25 Thread Dan Kozlowski
*Massimo, When I removed the orderby clause it solved problem with the error message. but I still need to sort the grid in desc order. * def dailycounts(): grid=SQLFORM.smartgrid(db.daily_counts, user_signature=False,create=False,editable=False,deletable=False,*

[web2py] Query Not Supported: (1054, Unknown column 'daily_counts.add_date' in 'order clause') No records f

2013-02-24 Thread Dan Kozlowski
I am getting the following message when I join the 2 files. Query Not Supported: (1054, Unknown column *'daily_counts.add_date*' in 'order clause') No records found db.define_table('daily_counts', Field('encrypt_count','integer'), Field('decrypt_count','integer'),

[web2py] Re: Query Not Supported: (1054, Unknown column 'daily_counts.add_date' in 'order clause') No records f

2013-02-24 Thread Dan Kozlowski
On Sunday, February 24, 2013 4:52:31 PM UTC-6, Dan Kozlowski wrote: I am getting the following message when I join the 2 files. Query Not Supported: (1054, Unknown column *'daily_counts.add_date*' in 'order clause') No records found db.define_table('daily_counts', Field

[web2py] Re: Query Not Supported: (1054, Unknown column 'daily_counts.add_date' in 'order clause') No records f

2013-02-24 Thread Dan Kozlowski
The error occurs on the smargrid when I select the button to go to the smartgrid for histories2. -- --- 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] Re: SmartGrid and New button 1 to many

2013-02-19 Thread Dan Kozlowski
field in both tables. Thanks Again On Friday, February 15, 2013 10:29:46 PM UTC-6, Dan Kozlowski wrote: Does anyone know if I smartgrid to can create another button next to View, Edit, Delete that will allow it to open a new search screen ? I have a customer ( 1 to many notes

[web2py] Re: SmartGrid and New button 1 to many

2013-02-16 Thread Dan Kozlowski
'), Field('add_date',db.daily_counts), Field('add_time','time'), Field('add_db_user','string'), Field('add_app_user','string')) On Friday, February 15, 2013 10:29:46 PM UTC-6, Dan Kozlowski wrote: Does anyone know if I smartgrid to can create another button next to View, Edit

[web2py] SmartGrid and New button 1 to many

2013-02-15 Thread Dan Kozlowski
Does anyone know if I smartgrid to can create another button next to View, Edit, Delete that will allow it to open a new search screen ? I have a customer ( 1 to many notes) and would like a Notes button that takes you to another search screen to allow you to view 1 to many Notes a

[web2py] Re: How can do muliple check boxes if a group and only allow the user the select 1.

2013-02-11 Thread Dan Kozlowski
On Sunday, February 10, 2013 5:07:16 PM UTC-6, Dan Kozlowski wrote: How can do muliple check boxes if a group and only allow the user the select 1. I used the smart grid to create the add and update. Dog or Cat and only 1 can be selected. -- --- You received this message because

[web2py] How can do muliple check boxes if a group and only allow the user the select 1.

2013-02-10 Thread Dan Kozlowski
How can do muliple check boxes if a group and only allow the user the select 1. I used the smart grid to create the add and update. Dog or Cat and only 1 can be selected. -- --- You received this message because you are subscribed to the Google Groups web2py-users group. To unsubscribe