[web2py] Custom buttons in grid are not displayed on Detail page

2023-10-10 Thread Seth J
I encountered a little issue with SmartGrid not displaying custom links in Detail view. Not sure if I'm missing something or it's a limitation of some sort. Here's what's going on. I have a main grid that looks like this: [image: main_grid.png] There are different custom 'ACTIONS' buttons

Re: [web2py] Re: web2py online debugger under python3

2020-07-16 Thread Seth J
So, what would you recommend for "remote debugging" situation? I have web2py running on internal firewalled Windows 2016 Server and have been struggling to adopt anything for debugging purposes. On Tuesday, May 5, 2020 at 9:11:00 PM UTC-4 roge...@gmail.com wrote: > Hi Clemens > > I think a

[web2py] Re: Upgraded to 2.19 and SQL Server date insert throws an error

2020-06-03 Thread Seth J
> On Wednesday, June 3, 2020 at 2:04:02 PM UTC-7, Seth J wrote: >> >> I am not sure how to view the query sent to MSSQL. >> > > Does this help/? > https://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#_lastsql

[web2py] Re: Upgraded to 2.19 and SQL Server date insert throws an error

2020-06-03 Thread Seth J
241) (SQLExecDirectW)') Context On Wednesday, June 3, 2020 at 9:14:15 AM UTC-4, Jim S wrote: > > Can you pinpoint the line in your code that is causing the error? > > Can you see the SQL statement that is being sent to the server? > > -Jim > > On Tuesday, June 2, 2020 a

[web2py] Re: Upgraded to 2.19 and SQL Server date insert throws an error

2020-06-02 Thread Seth J
estamp.2020.05.03.05.18.50 > <http://www.web2py.com/init/default/download>? > > > On Monday, June 1, 2020 at 8:12:08 PM UTC+2, Seth J wrote: >> >> I am running IIS connecting to SQL Server. Upgrade seems to have >> introduced an error to an otherwise functionin

[web2py] Re: Virtual Fields do not show in "details" view and are not searchable

2019-04-18 Thread Seth J
Hi, I'm trying to achieve a very similar thing, but with "smartgrid" and not having any luck with response to 'viewargs' on Details page. It always displays the entire list of fields without virtuals no matter how I limit the fields. Is there anything I am missing? On Friday, June 6, 2014 at

[web2py] Re: Insecure string Pickle with web2py 2.15.2

2017-08-07 Thread Seth J
16-39-27.fc960f63-bfb3-4fd6-9986-becad04c0c46#> (no such column: auth_user.username) On Monday, August 7, 2017 at 4:31:22 PM UTC-4, Dave S wrote: > > > > On Monday, August 7, 2017 at 1:08:47 PM UTC-7, Seth J wrote: >> >> So, the data in those tables is permanently gone?!

[web2py] Re: Insecure string Pickle with web2py 2.15.2

2017-08-07 Thread Seth J
So, the data in those tables is permanently gone?! On Friday, August 4, 2017 at 12:15:29 PM UTC-4, Leonel Câmara wrote: > > This is weird I would just move all table files to a backup migration and > do a fake migration to recreate them and see if it solves the problem. > -- Resources: -

[web2py] Re: Grid edit behavior when no changes are made

2017-08-04 Thread Seth J
So, archives on this page: https://github.com/niphlod/web2py/releases don't contain it?!?! On Friday, August 4, 2017 at 4:34:16 PM UTC-4, Dave S wrote: > > > > On Friday, August 4, 2017 at 1:17:08 PM UTC-7, Seth J wrote: >> >> Another quick question. How do I revert

[web2py] Re: Grid edit behavior when no changes are made

2017-08-04 Thread Seth J
Another quick question. How do I revert back to 2.14.6 or 2.14.5 then? I downloaded the appropriate version archive and replaced all of the files in the installation and it still gives me the same error message: Version web2py™ Version 2.14.5-stable+timestamp.2016.04.13.22.22.13 Python

[web2py] Re: Grid edit behavior when no changes are made

2017-08-03 Thread Seth J
Thanks, Leonel! Looking forward to it ... On Thursday, August 3, 2017 at 1:24:08 PM UTC-4, Leonel Câmara wrote: > > Seth that 2.15.2 bug has been fixed in trunk. Please wait for 2.15.3 > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) -

[web2py] Re: Grid edit behavior when no changes are made

2017-08-03 Thread Seth J
eError: 'Table' object has no attribute 'clone' On Thursday, August 3, 2017 at 12:46:13 PM UTC-4, Seth J wrote: > > We're using 2.14.5 version of web2py so far. Let me update one of our > dev servers and see if that solves the issue. Thanks, Anthony!!! > > On Thursday, August

[web2py] Re: Grid edit behavior when no changes are made

2017-08-03 Thread Seth J
b) >> explicitly add the modified_on and modified_by fields to the form vars so >> the archive record creation will be triggered. >> >> Anthony >> >> On Wednesday, August 2, 2017 at 12:45:48 PM UTC-4, Seth J wrote: >>> >>> Quick question, guys

[web2py] Grid edit behavior when no changes are made

2017-08-02 Thread Seth J
Quick question, guys. I've noticed that when record is edited in a grid and no changes are made to it when hitting 'Submit' no entry is made into a corresponding archive table. However, fields "modified on" and "modified by" are adjusted according to a user who submitted a change. Is there

[web2py] Re: sqlform.grid maxtextlengths shoots blanks

2017-07-25 Thread Seth J
I have a similar problem with maxtextlengths and I do have the "represent" attribute set like so: Field('f_last_change', type='text', label=T('Latest Changes'), default = '', represent=lambda text, row: HTML(XML(''

[web2py] Re: Smartgrid, grid export control works on Linux, but not on Windows Server

2017-06-09 Thread Seth J
Yes, two versions are different. It seems to be the culprit here. Linux has a 2.13.3 version (I think I mentioned it above somewhere). IIS has the latest 2.14.5 on it. Thanks! On Friday, June 9, 2017 at 7:01:14 PM UTC-4, Anthony wrote: > > On Friday, June 9, 2017 at 4:03:09 PM UTC-4

[web2py] Re: Smartgrid, grid export control works on Linux, but not on Windows Server

2017-06-09 Thread Seth J
e other > apps. > > On Friday, June 9, 2017 at 2:47:20 PM UTC-4, Seth J wrote: >> >> My bad!!! I thought you were referencing my code there! Thanks a lot!!! >> That solved the problem!!!  >> >> On Friday, June 9, 2017 at 2:43:45 PM UTC-4, Jim S wrot

[web2py] Re: Smartgrid, grid export control works on Linux, but not on Windows Server

2017-06-09 Thread Seth J
n both servers > as well as in new apps on the Windows server, and the only thing that > wasn't working was the packed app moved from Linux to Windows. But looks > like your code itself is wrong, so must not have been the same in the other > apps. > > On Friday, June 9, 2017 at

[web2py] Re: Smartgrid, grid export control works on Linux, but not on Windows Server

2017-06-09 Thread Seth J
gt; On Friday, June 9, 2017 at 1:40:52 PM UTC-5, Seth J wrote: >> >> Can you be more specific? I thought "title=dict(..." is reference >> enough?!?! 樂 >> >> On Friday, June 9, 2017 at 2:37:20 PM UTC-4, Jim S wrote: >>> >>> You need to tell it

[web2py] Re: Smartgrid, grid export control works on Linux, but not on Windows Server

2017-06-09 Thread Seth J
tsv_with_hidden_cols=False, > json=False)), orderby=orderby, >divider="»", formname='title_grid') > > > -Jim > > On Friday, June 9, 2017 at 10:33:01 AM UTC-5, Seth J wrote: >> >> Sorry, didn

[web2py] Re: Smartgrid, grid export control works on Linux, but not on Windows Server

2017-06-08 Thread Seth J
; hard to diagnose without interacting directly with the system. >> >> Anthony >> >> On Thursday, June 8, 2017 at 12:27:31 AM UTC-4, Seth J wrote: >>> >>> That's the thing! There's no difference in my code, apart from >>> connecting to different databas

[web2py] Re: Smartgrid, grid export control works on Linux, but not on Windows Server

2017-06-07 Thread Seth J
Neah, I never compile my apps for that very reason. -- 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

[web2py] Re: Smartgrid, grid export control works on Linux, but not on Windows Server

2017-06-07 Thread Seth J
That's the thing! There's no difference in my code, apart from connecting to different database. Controller and view are exactly the same. Same behavior is exhibited by all other controllers/views (about 10 in total). I am not saying that there's an error in framework. Apps created on Win Server

[web2py] Smartgrid, grid export control works on Linux, but not on Windows Server

2017-06-07 Thread Seth J
I am experiencing a peculiar issue with smartgrid and grid. I have web2py installed on Apache/2.2.15 (Red Hat) and everything works as it supposed to with respect to disabling export options: title_grid = SQLFORM.smartgrid(db.title, linked_tables = ['title_archive'], links=title_links,

[web2py] Re: How can I set the column width of a SQLFORM.grid table?

2016-05-03 Thread Seth J
maxtextlength=500 would make all columns show at most 500 characters. On Monday, May 2, 2016 at 3:57:37 PM UTC-4, Bernardo Leon wrote: > > Hello, I have this table in my model: > > db.define_table('data', > Field('description', 'string'), >

[web2py] Re: web2py 2.13.3 is OUT

2015-12-24 Thread Seth J
Definitely something has gone awry there. I replaced "ldap_auth.py" and "ldap_auth.pyc" from the 2.12.3 version and it works again. On Thursday, December 24, 2015 at 12:11:27 PM UTC-5, Seth J wrote: > > Hi Massimo, > > I just upgraded from 2.9.5 and it seem

[web2py] Re: web2py 2.13.3 is OUT

2015-12-24 Thread Seth J
Hi Massimo, I just upgraded and it seemed to kill my LDAP authorization: invalid syntax (ldap_auth.py, line 435) Versionweb2py™Version 2.13.3-stable+timestamp.2015.12.24.15.09.20PythonPython 2.6.6: /usr/bin/python (prefix: /usr)Traceback 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. Traceback (most

[web2py] Re: smartgrid linked tables Query Not Supported: no such column undocumented feature

2014-05-15 Thread Seth J
You have to pass ordering instructions for each table separately like so: orderby={'tile': ~db.tile.name, 'tile_archive':~db.tile_archive.modified_on} -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) -

[web2py] Virtual Field not present in a record view of smartgrid

2014-05-15 Thread Seth J
I don't know if it's intentional or an omission. I have defined a Virtual Field in one of the table definitions like so: db.define_table('t_sig_count', Field('f_jacket_no', type='string', label=T('Jacket')), Field('f_quantity',

[web2py] Re: Virtual Field not present in a record view of smartgrid

2014-05-15 Thread Seth J
Also, I have discovered with this set up that all Export functions/buttons except JSON and XML will crash not finding the column. Is that a glitch?!?! https://lh4.googleusercontent.com/-OT2ySMqgrpc/U3UUR_XfRTI/Bfg/6ruaP-do1Xs/s1600/Export_error.png -- Resources: - http://web2py.com -

[web2py] Fieldset styling in custom search widget of SQLFORM.smartgrid

2014-05-07 Thread Seth J
So, I progressed to being able to successfully create a custom search widget for SQLFORM.smartgrid . Along the way I discovered that you can only put one form there (may be I'm wrong, then I would appreciate hints). As an alternate solution I implemented all fields in a single form, but

Re: [web2py] Smartgrid and archive buttons

2014-05-02 Thread Seth J
Found a solution to my last question here: db.your_table_archive._plural = 'Your Label' renames record archive links for smartgrid. Topic is considered closed by me. On Monday, April 7, 2014 6:18:29 PM UTC-4, Seth J wrote: Thanks for leading me in the right direction regarding separating

[web2py] Re: Error when implementing search_widget for SQLFORM.smartgrid

2014-05-02 Thread Seth J
Found a solution to this problem. It appears that contactSearch needs two parameters and should be defined as follows (older examples had it wrong): def contactSearch(self, url): ... return form Topic is considered to be closed by me. On Friday, April 11, 2014 1:49:12 PM UTC-4, Seth J

[web2py] Error when implementing search_widget for SQLFORM.smartgrid

2014-04-13 Thread Seth J
Hello again, I apologize for potentially naive question as I am new to web2py. I am trying to implement a custom search_widget on SQLFORM.smartgrid and ran into an error. My table is defined in db.py as such: ## We prepend f_ to fieldnames for disambiguity

Re: [web2py] Smartgrid and archive buttons

2014-04-09 Thread Seth J
Thanks for leading me in the right direction regarding separating permissions!!! After I explicitly defined a table, I was able to set separate 'editable' and 'deletable' parameters: editable= dict(work_log=is_owner, work_log_archive=False), deletable= dict( work_log=is_owner,

Re: [web2py] Smartgrid and archive buttons

2014-04-07 Thread Seth J
The problem is that there are no field explicitly defined for that link. It appears automatically when I enable record_versioning. On Monday, April 7, 2014 2:49:00 AM UTC-4, Johann Spies wrote: On 4 April 2014 00:01, Seth J iva...@vsevolod.com javascript: wrote: Hi guys, As you can

[web2py] Smartgrid and archive buttons

2014-04-03 Thread Seth J
Hi guys, New to web2py and have a potentially simple question about smartgrid. In db.py I have an archive enabled after definition of my 'work_log' table: ## after defining tables, uncomment below to enable auditing auth.enable_record_versioning(db) in default.py controller I have the