Re: [web2py] Sending mail with links to SQLFORM.grid edit page - not authorized

2013-11-06 Thread Jim Steil
No, the user is always linking with a signature in the app. I think the default for user_signature is True and I'm not overriding it. So, are you telling me that if I want to deep link to the edit page on a SQLFORM.grid then I need to have user_signature = False? If I do that, aren't I giving

Re: [web2py] Sending mail with links to SQLFORM.grid edit page - not authorized

2013-11-06 Thread Jim Steil
recommended and if I knew more about the underlying protocols it would probably make sense. But, since I don't understand it fully, could someone elaborate on why this wouldn't be recommended? -Jim On Wed, Nov 6, 2013 at 1:42 PM, Jim Steil ato.st...@gmail.com wrote: No, the user is always linking

Re: [web2py] Sending mail with links to SQLFORM.grid edit page - not authorized

2013-11-06 Thread Jim Steil
I tried sending the signed link via the email, but that seemed to fail as well. Also have to assume that the person getting the email and navigating to the page is not using the same session as the one sending the email. So, how would you build the signature? I will investigate the redirect

Re: [web2py] Sending mail with links to SQLFORM.grid edit page - not authorized

2013-11-06 Thread Jim Steil
Thanks for all the help. You guys are awesome. Jim On Nov 6, 2013 5:37 PM, Niphlod niph...@gmail.com wrote: or @auth.requires_login() def email_link_redirector(): if not request.args(0): raise HTTP(404) redirect(URL('maintenance', 'tickets', args=['edit', 'ticket',

Re: [web2py] Re: grid in component only works in Firefox

2013-10-22 Thread Jim Steil
Yes, Opera is showing the form tag. On Mon, Oct 21, 2013 at 4:31 PM, Niphlod niph...@gmail.com wrote: this means that in Opera the product_addon.load shows the form tag ? On Monday, October 21, 2013 11:26:36 PM UTC+2, Jim S wrote: It works fine. Also, the data input elements are all

Re: [web2py] Re: grid in component only works in Firefox

2013-10-22 Thread Jim Steil
Excellent guess!! That was it. Thanks a bunch for your help! On Tue, Oct 22, 2013 at 7:21 AM, Ricardo Pedroso rmdpedr...@gmail.comwrote: On Mon, Oct 21, 2013 at 9:35 PM, Jim S j...@qlf.com wrote: Found a little more. Look at the two attachments. One is the generated html from Opera

Re: [web2py] Re: grid in component only works in Firefox

2013-10-22 Thread Jim Steil
...the nested form, that is... On Tue, Oct 22, 2013 at 7:58 AM, Jim Steil ato.st...@gmail.com wrote: Excellent guess!! That was it. Thanks a bunch for your help! On Tue, Oct 22, 2013 at 7:21 AM, Ricardo Pedroso rmdpedr...@gmail.comwrote: On Mon, Oct 21, 2013 at 9:35 PM, Jim S j

Re: [web2py] Re: grid in component only works in Firefox

2013-10-21 Thread Jim Steil
It works fine. Also, the data input elements are all displayed appropriately, just doesn't work when I click on submit to try to add something. But, works fine in Firefox. On Mon, Oct 21, 2013 at 4:07 PM, Niphlod niph...@gmail.com wrote: how can opera chunk out part of html ? if you point

Re: [web2py] Re: Error in SQLFORM.grid after updating to Version 2.6.4-stable+timestamp.2013.06.26.11.24.52

2013-09-26 Thread Jim Steil
I just did a hg pull from https://code.google.com/p/web2py and got no changes found. On Thu, Sep 26, 2013 at 1:36 PM, Massimo Di Pierro massimo.dipie...@gmail.com wrote: The problem is not the grid. We are working on a new feature and it will break existing sessions. I just committed a

Re: [web2py] Re: Error in SQLFORM.grid after updating to Version 2.6.4-stable+timestamp.2013.06.26.11.24.52

2013-09-26 Thread Jim Steil
, maxtextlength=45) On Thu, Sep 26, 2013 at 1:55 PM, Jim Steil ato.st...@gmail.com wrote: I just did a hg pull from https://code.google.com/p/web2py and got no changes found. On Thu, Sep 26, 2013 at 1:36 PM, Massimo Di Pierro massimo.dipie...@gmail.com wrote: The problem is not the grid. We

Re: [web2py] Re: Error in SQLFORM.grid after updating to Version 2.6.4-stable+timestamp.2013.06.26.11.24.52

2013-09-26 Thread Jim Steil
Works now. Thanks for the prompt response. -Jim On Thu, Sep 26, 2013 at 2:10 PM, Massimo Di Pierro massimo.dipie...@gmail.com wrote: Please try once more. On Thursday, 26 September 2013 13:55:47 UTC-5, Jim S wrote: I just did a hg pull from

Re: [web2py] Re: Error trying to view Errors for my app

2013-09-26 Thread Jim Steil
I wasn't trying to display the error, just the list of errors. Would that make a difference? I'm assuming that this will be fixed. Is there a way I can clear all my errors without using the console? On Thu, Sep 26, 2013 at 3:43 PM, Niphlod niph...@gmail.com wrote: this is due to a new

Re: [web2py] Re: Cannot get into Admin on any of my apps

2013-08-27 Thread Jim Steil
FIXED Thanks Massimo! -Jim On Tue, Aug 27, 2013 at 7:16 AM, step step.l...@gmail.com wrote: It's fixed, at least for me, I had the same issue that Jim S. reported. On Tuesday, August 27, 2013 1:33:48 PM UTC+2, Massimo Di Pierro wrote: Thanks. Please check the latest trunk. I think it is

Re: [web2py] Re: Cannot get into Admin on any of my apps

2013-08-26 Thread Jim Steil
c:\dev\web2py\applications\admin\infocenter ...when I clicked on the Edit button for the infocenter app. c:\dev\web2py\applications\admin\admin ...when I click on Errors for the Admin app. -Jim On Mon, Aug 26, 2013 at 4:49 PM, Massimo Di Pierro massimo.dipie...@gmail.com wrote: Can you

Re: [web2py] Re: Cannot get into Admin on any of my apps

2013-08-26 Thread Jim Steil
...and Yes, those folders exist. On Mon, Aug 26, 2013 at 4:57 PM, Jim Steil ato.st...@gmail.com wrote: c:\dev\web2py\applications\admin\infocenter ...when I clicked on the Edit button for the infocenter app. c:\dev\web2py\applications\admin\admin ...when I click on Errors for the Admin

Re: [web2py] Re: Using DAL outside of web2py

2013-08-22 Thread Jim Steil
So, what would you consider 'best practice' when you have separate production and development databases. What is the way to ensure that using the DAL outside of web2py with auto_import will work reliably in both environments? -Jim On Thu, Aug 22, 2013 at 1:21 PM, Niphlod niph...@gmail.com

Re: [web2py] Re: Using DAL outside of web2py

2013-08-22 Thread Jim Steil
Hey, just got it working. My problem was that in my DAL init I had migrate=False and migrate_enabled=False. Once I removed them it all began working with fake_migrate_all=True. Thanks for the help! -Jim On Thu, Aug 22, 2013 at 2:37 PM, Niphlod niph...@gmail.com wrote: I consider a best

Re: [web2py] Re: Do you use web2py professionally?

2013-08-13 Thread Jim Steil
Not sure what you're asking here but I did not write an app to replace Excel, but apps to replace specific Excel spreadsheets that were developed to track business-related data that an off-the-shelf product couldn't handle or was overkill for our needs. On Mon, Aug 12, 2013 at 5:41 PM, Tim

Re: [web2py] Re: SQLFORM.grid always show column sorter arrows

2013-08-12 Thread Jim Steil
Submitted. Issue 1626. On Mon, Aug 12, 2013 at 9:57 AM, Niphlod niph...@gmail.com wrote: ok, then I guess it's doable. Would you please open a ticket to get the feature request tracked ? I can do it in the evening. PS: until then another way is just to link the grid with the correct var

Re: [web2py] Re: SQLFORM.grid always show column sorter arrows

2013-08-11 Thread Jim Steil
Yes, just for the active sort. -Jim On Sun, Aug 11, 2013 at 4:04 PM, Niphlod niph...@gmail.com wrote: do you mean that you need in all headers the up/down arrows shown ? On Saturday, August 10, 2013 2:40:04 PM UTC+2, Jim S wrote: I have a requirement from a client to ALWAYS show the

Re: [web2py] Re: Problem with SUM on DAL statement

2013-07-21 Thread Jim Steil
Do you have a test you can run on it? None of mine are working and I just updated in the last hour. On Sun, Jul 21, 2013 at 8:48 AM, Niphlod niph...@gmail.com wrote: this should have been fixed already on the latest trunk On Sunday, July 21, 2013 3:33:51 PM UTC+2, Jim S wrote: Just

Re: [web2py] Re: Problem with SUM on DAL statement

2013-07-21 Thread Jim Steil
', 'integer')) assert(db(db.tt.aa == 2).count()==0) sum = (db.tt.aa + 1).sum() assert(db(db.tt.aa == 2).select(sum).first()[sum]==0) - AssertionError I added tests for travis too. 2013/7/21 Jim Steil ato.st...@gmail.com Do you have a test you can run on it? None of mine are working and I just

Re: [web2py] Re: Problem with SUM on DAL statement

2013-07-21 Thread Jim Steil
/144 2013/7/21 Jim Steil ato.st...@gmail.com Thanks. Really appreciate the prompt reply on a Sunday morning!! Jim On Jul 21, 2013 9:22 AM, Michele Comitini michele.comit...@gmail.com wrote: There is a bug. must be None i.e. the result is not defined. I fixed the bug and I will send

Re: [web2py] Re: better calendar.js?

2013-07-19 Thread Jim Steil
Massimo - That would be great! On Fri, Jul 19, 2013 at 3:40 AM, Massimo Di Pierro massimo.dipie...@gmail.com wrote: How about we put this in web2py,js? jQuery('input.date,input.datetime,input.time').attr('autocomplete','off') Massimo On Thursday, 18 July 2013 17:11:19 UTC-5, Paolo

Re: [web2py] Re: better calendar.js?

2013-07-18 Thread Jim Steil
that may work for 1 browser but I can't require that all users of the app turn off auto-complete. On Thu, Jul 18, 2013 at 3:03 PM, Paolo Caruccio paolo.carucci...@gmail.comwrote: How to Turn Off Form

Re: [web2py] Re: better calendar.js?

2013-07-18 Thread Jim Steil
So it should be an update to the widget, right? -Jim On Thu, Jul 18, 2013 at 4:24 PM, Paolo Caruccio paolo.carucci...@gmail.comwrote: Well, the automplete is a form | input attribute and therefore you could set in HTML code form name=form1 id=form1 method=post autocomplete=off action=...

Re: [web2py] Re: How does SQLFORM.grid know which table to edit?

2013-07-11 Thread Jim Steil
Thanks for the reply Massimo. I know grid can only edit one table and that is what I want. I'm just wondering how it chooses which table it is editing if the left parameter is specified. Also, in my example above, it should be grid = SQLFORM.grid(query, left=left) -Jim On Thu, Jul 11, 2013

Re: [web2py] Re: How does SQLFORM.grid know which table to edit?

2013-07-11 Thread Jim Steil
I'll make up a little test app, submit a ticket and add the app for testing. On Thu, Jul 11, 2013 at 1:04 PM, Massimo Di Pierro massimo.dipie...@gmail.com wrote: Good point! It should be the first table mentioned in the query but, this could be customizable. Please open a ticket about this.

Re: [web2py] Re: New to auth.wiki - format text as address block with markmin

2013-07-08 Thread Jim Steil
Yup, that works and I found my error. I wasn't putting my [[NEWLINE]] in uppercase. On Mon, Jul 8, 2013 at 11:16 AM, Alan Etkin spame...@gmail.com wrote: Assuming you want to force html line breaks in auth.wiki documents using its defaullt render engine (markmin), the syntax for doing so is

Re: [web2py] Re: Change default form error message

2013-07-07 Thread Jim Steil
But then wouldn't I have to alter ALL of my grids/forms to override the message? -Jim On Sun, Jul 7, 2013 at 3:19 PM, Alan Etkin spame...@gmail.com wrote: Dang, why didn't I think of that. Thanks, that is exactly what I needed. This is better because you don't have to deal with the

Re: [web2py] Re: New to auth.wiki - format text as address block with markmin

2013-07-07 Thread Jim Steil
Same result, no newlines were inserted. It all appears as one long line. On Sun, Jul 7, 2013 at 5:48 PM, Alan Etkin spame...@gmail.com wrote: Then, in one of the pages I created using the wiki 'create page' I'm trying to get a carriage return displayed. I've tried all the think listed

Re: [web2py] Re: New to auth.wiki - format text as address block with markmin

2013-07-07 Thread Jim Steil
My web2py is Version 2.5.1-stable+timestamp.2013.06.17.10.41.11. I tried adding a br / and didn't see any changes. On Sun, Jul 7, 2013 at 7:59 PM, Alan Etkin spame...@gmail.com wrote: Same result, no newlines were inserted. It all appears as one long line. Odd, It works fine with the

Re: [web2py] Re: Change default form error message

2013-07-07 Thread Jim Steil
The language file worked fine for me. Is that not a good way to solve the problem? -Jim On Sun, Jul 7, 2013 at 7:50 PM, Anthony abasta...@gmail.com wrote: BTW. I think this is an example of why CRUD should not be deprecated. It could be easily modified to support something like crud =

Re: [web2py] Re: JQuery Issue

2013-06-27 Thread Jim Steil
I'd try putting some alert() messages in to try to trace the flow and check the values of variables. On Thu, Jun 27, 2013 at 9:53 AM, Tom Russell t...@caregointl.com wrote: Thats weird, now it will not hide the the field but has no effect either when you check the checkbox. On Thu, Jun

Re: [web2py] Re: sqlform.grid - Accessing id and values from link checkbox

2013-06-21 Thread Jim Steil
Sorry, misunderstood what the problem was. On Fri, Jun 21, 2013 at 10:50 AM, PremKumar KrishnaKumar premkumar.krishnaku...@gmail.com wrote: Hi Jim, The selectable works perfectly but the reason I am using links is I might require couple of more additional columns containing check-box. So

Re: [web2py] Re: Fields being set to NULL on SQLFORM.grid update

2013-06-17 Thread Jim Steil
Not what I wanted to hear, but that is what I figured was the issue. However, I think it should be noted in the book that when using SQLFORM.grid and custom forms that any field not included in the custom form will be set to NULL on every update of the form. On Mon, Jun 17, 2013 at 12:53 AM,

Re: [web2py] Re: Fields being set to NULL on SQLFORM.grid update

2013-06-16 Thread Jim Steil
I was hoping I wouldn't have to do that but I understand. I think it should be pointed out in the manual that this needs to be done so others don't make the same mistake I did. Thanks Massimo, I really appreciate the reply. Jim On Jun 16, 2013 3:41 AM, Massimo Di Pierro

Re: [web2py] Re: Fields being set to NULL on SQLFORM.grid update

2013-06-16 Thread Jim Steil
I thought I could just use whatever fields I wanted and it would figure out which ones to update. The way it is now, if I add a field to a table and it isn't included in the writable = False statements the It is going to be set to null on any future updates. I would prefer to not have to worry

Re: [web2py] Re: Error in smartgrid after updating to Version 2.5.1-stable+timestamp.2013.06.11.08.00.05

2013-06-13 Thread Jim Steil
Ticket 1527. On Thu, Jun 13, 2013 at 3:26 PM, Massimo Di Pierro massimo.dipie...@gmail.com wrote: Please open a ticket about this. On Wednesday, 12 June 2013 14:56:45 UTC-5, Jim S wrote: My smartgrids are all failing when I have fields from multiple tables specified in the 'fields'

Re: [web2py] Re: SQLFORM create / edit / delete help (I feel like I've hit a wall)

2013-04-17 Thread Jim Steil
You can use custom forms with .grid also. No limitations there. Jim On Apr 17, 2013 8:13 AM, Anthony abasta...@gmail.com wrote: On Tuesday, April 16, 2013 4:07:53 PM UTC-4, Trevor Overman wrote: I looked at SQLFORM.grid, but to me it seemed limited to styling options. I may be completely

Re: [web2py] Re: How do I specify my display field here in IS_IN_DB?

2013-04-15 Thread Jim Steil
Thanks for the help on this Anthony. I ended up using the lambda function and the orderby to get what I needed. Would be great to see the left join supported here. On Fri, Apr 12, 2013 at 9:07 PM, Jim Steil ato.st...@gmail.com wrote: That perfect. I'll get it going next week. Thanks

Re: [web2py] Re: How do I specify my display field here in IS_IN_DB?

2013-04-12 Thread Jim Steil
Tried that already but got the same error. Jim On Apr 12, 2013 11:32 AM, Anthony abasta...@gmail.com wrote: Since you are joining tables, you might need to use the tablename.fieldname format to refer to the field in question. Does '%(product.productName)s' work (assuming productName is in

Re: [web2py] Re: How do I specify my display field here in IS_IN_DB?

2013-04-12 Thread Jim Steil
Shoot, should have thought of that. Will try when I get back to the office. Jim On Apr 12, 2013 12:04 PM, Anthony abasta...@gmail.com wrote: It probably should work, but for some reason, the code converts the Row to a dict before doing the string formatting, and that breaks for Rows

Re: [web2py] Re: How do I specify my display field here in IS_IN_DB?

2013-04-12 Thread Jim Steil
, zero='..') AttributeError: 'Row' object has no attribute 'product' On Fri, Apr 12, 2013 at 12:10 PM, Jim Steil ato.st...@gmail.com wrote: Shoot, should have thought of that. Will try when I get back to the office. Jim On Apr 12, 2013 12:04 PM, Anthony abasta...@gmail.com wrote

Re: [web2py] Re: How do I specify my display field here in IS_IN_DB?

2013-04-12 Thread Jim Steil
, in lambda lambda r: r.product.productName, zero='..') AttributeError: 'Row' object has no attribute 'product' On Fri, Apr 12, 2013 at 12:10 PM, Jim Steil ato@gmail.com wrote: Shoot, should have thought of that. Will try when I get back to the office. Jim On Apr 12, 2013 12:04 PM

Re: [web2py] Re: How do I specify my display field here in IS_IN_DB?

2013-04-12 Thread Jim Steil
, zero='..') AttributeError: 'Row' object has no attribute 'product' On Fri, Apr 12, 2013 at 12:10 PM, Jim Steil ato@gmail.com wrote: Shoot, should have thought of that. Will try when I get back to the office. Jim On Apr 12, 2013 12:04 PM, Anthony abas...@gmail.com wrote: It probably

Re: [web2py] Re: How do I specify my display field here in IS_IN_DB?

2013-04-12 Thread Jim Steil
='..') AttributeError: 'Row' object has no attribute 'product' On Fri, Apr 12, 2013 at 12:10 PM, Jim Steil ato@gmail.comwrote: Shoot, should have thought of that. Will try when I get back to the office. Jim On Apr 12, 2013 12:04 PM, Anthony abas...@gmail.com wrote: It probably should work

Re: [web2py] Re: Routing to different web2py apps in pythonanywhere

2013-04-11 Thread Jim Steil
Here is the code in routes.py that got it working for me. routers = dict( # base router BASE=dict( default_application='welcome', domains={'www.app1.com':'app1', 'www.app2.org':'app2'} ), ) On Thu, Apr 11, 2013 at 8:07 AM, Cenk Yıldız

Re: [web2py] Re: Problem with URL inside loaded component - Bug??

2013-03-15 Thread Jim Steil
That did the trick. I didn't know about that argument. Thanks for the heads up. -Jim On Thu, Mar 14, 2013 at 3:34 PM, LightDot light...@gmail.com wrote: I don't think it's a bug, .load is inherited in this case, isn't it? In other words, it's a feature :) You can set extension=False in

Re: [web2py] Re: SQLFORM.factory form.process().accepted not behaving as expected

2013-03-13 Thread Jim Steil
Thanks Anthony. If I put formname='membership' in the form.process().accepted like this: form.process(formname='membership').accepted: Then does that refer to the _id arg set by SQLFORM.factory(_id='membership')??? -Jim On Wed, Mar 13, 2013 at 10:51 AM, Anthony abasta...@gmail.com wrote:

Re: [web2py] Re: REF: SQLFORM.smartgrid() changing the table labels

2013-03-13 Thread Jim Steil
I'm having trouble seeing the difference. If you put the change to _plural in your controller then it is always there for that controller. If you want it permanent, put it in your model. Maybe a screen shot would help me better understand. On Wed, Mar 13, 2013 at 11:33 AM, Alex Glaros

Re: [web2py] Re: SQLFORM.factory form.process().accepted not behaving as expected

2013-03-13 Thread Jim Steil
Thanks On Wed, Mar 13, 2013 at 11:15 AM, Niphlod niph...@gmail.com wrote: nope. formname overrides the hidden field value _formname On Wednesday, March 13, 2013 5:11:48 PM UTC+1, Jim S wrote: Thanks Anthony. If I put formname='membership' in the form.process().accepted like this:

Re: [web2py] Re: REF: SQLFORM.smartgrid() changing the table labels

2013-03-13 Thread Jim Steil
...and doesn't changing the _plural value of that table change it? It should! On Wed, Mar 13, 2013 at 1:39 PM, Alex Glaros alexgla...@gmail.com wrote: I may be on the wrong topic. Anyway, see attachment. On Wednesday, March 13, 2013 9:57:43 AM UTC-7, Jim S wrote: I'm having trouble

Re: [web2py] Re: REF: SQLFORM.smartgrid() changing the table labels

2013-03-13 Thread Jim Steil
Glad to hear On Wed, Mar 13, 2013 at 3:59 PM, Alex Glaros alexgla...@gmail.com wrote: Yeah, it worked great. Thanks Jim, Alex On Wednesday, March 13, 2013 1:36:31 PM UTC-7, Jim S wrote: ...and doesn't changing the _plural value of that table change it? It should! On Wed, Mar 13,

Re: [web2py] Re: SQLFORM.grid in LOADed component Delete behavior

2013-03-13 Thread Jim Steil
That's what I was hoping to avoid, but probably the only way it is going to work. Thanks for taking a look. -Jim On Wed, Mar 13, 2013 at 6:15 PM, Niphlod niph...@gmail.com wrote: I'd say that if you want a full reload after deleting the record you should disable the default delete and

Re: [web2py] Re: grid/smartgrid searching foreign key tables

2013-03-11 Thread Jim Steil
I agree with Cliff. It takes longer to code the search/filter than it does the controller with .grid and .smartgrid. But, I think it is worth the time so I do it. -Jim On Mon, Mar 11, 2013 at 8:18 PM, Cliff Kachinske cjk...@gmail.com wrote: Just so I'm clear, full text is when you just

Re: [web2py] Re: Smartgrid: How to display value from foreign table in a table when only foreign key is in table

2013-02-23 Thread Jim Steil
Can you paste the table definition that choked on you? -Jim On Sat, Feb 23, 2013 at 1:34 PM, Alex Glaros alexgla...@gmail.com wrote: web2py doesn't seem to accept that format on my windows version. I get type 'exceptions.AttributeError' 'DAL' object has no attribute 'DictionaryType' The

Re: [web2py] Re: Smartgrid: How to display value from foreign table in a table when only foreign key is in table

2013-02-23 Thread Jim Steil
'), Field ('definition', 'string'), Field('languageID','reference HumanLanguage'), Field('dictionaryTypeID',*db.DictionaryType*), Field('wordReferenceModelID','reference WordReferenceModel'), Field('comments','string'), auth.signature) On Sat, Feb 23, 2013 at 12:01 PM, Jim Steil ato.st...@gmail.com

Re: [web2py] Re: Smartgrid: How to display value from foreign table in a table when only foreign key is in table

2013-02-22 Thread Jim Steil
Depends on whether or not you want that behavior globally or not. Remember, your model gets executed on every request. So, if you want that behavior globally I'd put it there. If you just need it for one instance, put it in the controller. -Jim On Fri, Feb 22, 2013 at 12:20 AM, Alex Glaros

Re: [web2py] Re: smartgrid fails to show consistent behavior between parent and child tables

2013-02-22 Thread Jim Steil
Then you could put the code in your model. Would be global then On Feb 22, 2013 9:04 AM, wwwgong wen.g.g...@gmail.com wrote: Jim Thanks, Your suggestion worked. It would be nice if one does not have to duplicate the code, any idea how parent can inherit child's behavior? W On

Re: [web2py] Re: smartgrid fails to show consistent behavior between parent and child tables

2013-02-22 Thread Jim Steil
I've been working with the smartgrid since Massimo created it. The way I learned most about it was to open up sqlhtml.py in my editor and look through the source, primarily at the parameters that you can pass to it. There is a great deal of capability and flexibility build into it. So, I agree,

Re: [web2py] Re: Smartgrid: How to display value from foreign table in a table when only foreign key is in table

2013-02-22 Thread Jim Steil
Sorry, I'm kinda lost in what you're trying to do. Can you show it in code or screen shots? -Jim On Fri, Feb 22, 2013 at 12:08 PM, Alex Glaros alexgla...@gmail.com wrote: There is a grandparent (HumanLanguage), parent (DictionaryType), child (Word), relationship. If I go straight from the

Re: [web2py] Re: Smartgrid: How to display value from foreign table in a table when only foreign key is in table

2013-02-22 Thread Jim Steil
Ouch, I'm going to have to defer to to someone who understands smartgrid better than I do. You've got me stumped on this one. On Fri, Feb 22, 2013 at 2:48 PM, Alex Glaros alexgla...@gmail.com wrote: thanks for offering to take a look. Screen shots here:

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

2013-02-19 Thread Jim Steil
Yes, that is true,you'd have to join by the primary ID field of the other table. But, looking at your table, couldn't you use the ID instead of the date? I guess I'm a bit anal about the way I like tables, I always use the ID fields. On Tue, Feb 19, 2013 at 9:30 PM, Dan Kozlowski

Re: [web2py] Re: anyone using the Issue Tracker appliance?

2013-02-15 Thread Jim Steil
I didn't specify anything, just tried importing it into my environment through the admin interface and it failed. On Fri, Feb 15, 2013 at 5:22 PM, Andrew Replogle andrew.replo...@gmail.comwrote: Jim, Is this in GAE or an environment that doesn't have a file backed store? I believe initially

Re: [web2py] Re: Smartgrid buttons not going away

2013-02-13 Thread Jim Steil
To be more clear: form = SQLFORM.smartgrid(db.Config_Table, searchable=False, deletable=False,editable=False. On Wed, Feb 13, 2013 at 6:16 PM, Jim S j...@qlf.com wrote: You're setting them to the string value 'False'. Take the single quotes out and that should do it. -Jim On

Re: [web2py] Re: From a component controller, can I force reload of entire page?

2013-02-13 Thread Jim Steil
Thanks Anthony. Is there also a way for me to force a reload of the entire page after a delete is processed from the list view of a SQLFORM.grid? On Wed, Feb 13, 2013 at 7:03 PM, Anthony abasta...@gmail.com wrote: if form.process().accepted: redirect(URL(...), client_side=True) With

Re: [web2py] Simple routing question

2013-02-12 Thread Jim Steil
on that. -Jim On Tuesday, February 12, 2013 9:25:27 AM UTC-6, Jim S wrote: So you mean to just look at it through a regular view, not in the routes.py. Got it. Wasn't thinking straight. -Jim On Monday, February 11, 2013 11:13:23 PM UTC-6, Jonathan Lundell wrote: On 11 Feb 2013, at 7:48 PM, Jim

Re: [web2py] Simple routing question

2013-02-12 Thread Jim Steil
redirect to www.yourdomain.com, and then www.yourdomain.com has a CNAME to yourusername.pythonanywhere.com, you should be set! I hope that wasn't too rambling and incoherent... All the best, Giles On 12 February 2013 19:03, Jim Steil ato.st...@gmail.com wrote: Yes, I don't believe

Re: [web2py] Simple routing question

2013-02-12 Thread Jim Steil
. Thanks Again -Jim On Tue, Feb 12, 2013 at 2:55 PM, Jim Steil ato.st...@gmail.com wrote: I 'think' I've just got my DNS setup they way you described. Waiting for it to propogate Will check back in a few hours. -Jim On Tue, Feb 12, 2013 at 1:48 PM, Giles Thomas giles.tho

Re: [web2py] Simple routing question

2013-02-11 Thread Jim Steil
Sorry for being slow at this, route configuration is certainly not a forte of mine. Is there something special I need to do to turn on logging? How would I examine request.env? I'm running all of this from pythonanywhere and don't really know where to find these things. -Jim On Mon, Feb 11,

Re: [web2py] Re: Can I change a boolean field widget to a button?

2013-01-29 Thread Jim Steil
Nope, but will now! Thanks -Jim On Tue, Jan 29, 2013 at 1:15 PM, Lamps902 dheap@gmail.com wrote: Just tried the code I posted above with IE 9, and it did change the checkbox to a button. Did you give it a shot? On Tuesday, January 29, 2013 2:00:45 PM UTC-5, Jim S wrote: The

Re: [web2py] Re: Can I change a boolean field widget to a button?

2013-01-29 Thread Jim Steil
Yes, I was thinking this was javascript code. Sorry I missed that, it's been a long day... On Tue, Jan 29, 2013 at 7:59 PM, Lamps902 dheap@gmail.com wrote: It looks like you might be sort of conflating javascript and python code there. Before you do anything with javascript, modify the

Re: [web2py] Re: Can I change a boolean field widget to a button?

2013-01-29 Thread Jim Steil
Yup, worked just as you stated. Thanks for carrying me along... -Jim On Tue, Jan 29, 2013 at 8:02 PM, Jim Steil ato.st...@gmail.com wrote: Yes, I was thinking this was javascript code. Sorry I missed that, it's been a long day... On Tue, Jan 29, 2013 at 7:59 PM, Lamps902 dheap

Re: [web2py] Re: web2py world conference 2013

2013-01-28 Thread Jim Steil
I would be wanting to attend in person in Chicago. Jim On Jan 28, 2013 11:18 AM, António Ramos ramstei...@gmail.com wrote: I´d like to see this in Portugal. Anyone? 2013/1/28 Bruno Rocha rochacbr...@gmail.com I think it is ok to have different dates on each places. Each country/place

Re: [web2py] Enable my workstation as admin on remote web2py server

2013-01-24 Thread Jim Steil
Nevermind, found this on stackoverflow http://stackoverflow.com/questions/12834550/simplest-way-to-setup-remote-admin-access-to-a-web2py-process -Jim On Thu, Jan 24, 2013 at 4:36 PM, Jim S j...@qlf.com wrote: I have web2py installed on a remote box (QNAP Server). I'm doing some testing with

Re: [web2py] Re: SQLFORM.grid with multiple LEFT OUTER JOINs

2013-01-23 Thread Jim Steil
2.4.1-alpha.2+timestamp.2013.01.23.08:17:15 Just updated this morning. -Jim On Wed, Jan 23, 2013 at 8:55 AM, Massimo Di Pierro massimo.dipie...@gmail.com wrote: Which version? I thought we fixed this in trunk. On Wednesday, 23 January 2013 08:54:38 UTC-6, Jim S wrote: Oh, and the

Re: [web2py] Re: Question about SQLFORM.grid - process a column before show it

2012-12-20 Thread Jim Steil
Have you though about adding a table to define the relation between 'index' and the text: db_actions.define_table('actions', Field(name, length=20, label='Action')) Then modify db_events so field index looks like: Field('index', db.actions, label='Action), Table actions would then have three

Re: [web2py] Re: required_if_other_field_is_true validator

2012-12-11 Thread Jim Steil
Perfect - Thanks guys. On Thu, Dec 6, 2012 at 5:24 PM, Anthony abasta...@gmail.com wrote: Or maybe something like this: db.define_table('thing', Field('a', 'boolean', default=True), Field('b', requires=IS_NOT_EMPTY() if request.vars.a else None)) Anthony On Thursday, December

Re: [web2py] Re: Web2py is Out Pycon 2013.

2012-12-06 Thread Jim Steil
Nevermind, found it here: https://groups.google.com/d/topic/web2py/DwOd-V9DzrM/discussion On Thu, Dec 6, 2012 at 11:22 AM, Jim S j...@qlf.com wrote: Upcoming web2py conference? Where can I learn more about that? -Jim On Thursday, December 6, 2012 11:05:52 AM UTC-6, Massimo Di Pierro

Re: [web2py] Re: SQLFORM.smartgrid and constraint

2012-11-20 Thread Jim Steil
Glad to hear. On Nov 20, 2012 12:34 PM, vivek vi...@digambernath.org wrote: No I am wrong it works! Thank you so much! On Tuesday, November 20, 2012 10:10:03 PM UTC+4, vivek wrote: Nope that doesn't help. On Tuesday, November 20, 2012 9:46:10 PM UTC+4, Jim S wrote: Try changing:

Re: [web2py] Re: wxpython app using web2py username and password

2012-11-15 Thread Jim Steil
I would be interested in learning more. do you have any samples you could share? On Nov 15, 2012 8:52 PM, dlypka dly...@gmail.com wrote: I recently devised some changes to globals.py and main.py to allow a non-cookies client to log into web2py and keep the same session record between requests,

Re: [web2py] Re: Capturing field changes with _after_update and smartgrid

2012-11-09 Thread Jim Steil
I thought of that too, but for some reason it appears to be a fragile solution in my mind. Should I be putting more faith in the stack? Is this something that is commonly done? -Jim On Fri, Nov 9, 2012 at 1:39 PM, Derek sp1d...@gmail.com wrote: Use before_update to store the current data in

Re: [web2py] Re: Capturing field changes with _after_update and smartgrid

2012-11-09 Thread Jim Steil
Thanks Niphlid, I was going to ask about the db.commit issue before but forgot. I'm going to give the _before_update callback a try and see how well that works for me. Thanks for all the responses, I truly appreciate it. -Jim On Fri, Nov 9, 2012 at 3:32 PM, Niphlod niph...@gmail.com wrote:

Re: [web2py] Re: Capturing field changes with _after_update and smartgrid

2012-11-09 Thread Jim Steil
Just reporting back. The _before_update is working perfectly for me. -Jim On Fri, Nov 9, 2012 at 3:45 PM, Jim Steil ato.st...@gmail.com wrote: Thanks Niphlid, I was going to ask about the db.commit issue before but forgot. I'm going to give the _before_update callback a try and see how

Re: [web2py] Re: Database table name is different that dal reference

2012-11-08 Thread Jim Steil
Not the reply I wanted, but as always, I appreciate the prompt reply. Certainly something I can work around. -Jim On Thu, Nov 8, 2012 at 9:51 AM, Massimo Di Pierro massimo.dipie...@gmail.com wrote: This is not supported at this time. On Thursday, 8 November 2012 09:39:24 UTC-6, Jim S

Re: [web2py] Re: Reading a text file after uploading in a form

2012-11-01 Thread Jim Steil
Sorry, the reports module is my own. It is a directory under the modules directory for that app. this is just my own special code. The important thing to note is that you have to pass the directory name. The important part is this: '%s/%s' % (os.path.join(request.folder,'uploads'), fileName)

Re: [web2py] Re: Reading a text file after uploading in a form

2012-11-01 Thread Jim Steil
in f.readlines(): On Thu, Nov 1, 2012 at 9:45 AM, Jim Steil ato.st...@gmail.com wrote: Sorry, the reports module is my own. It is a directory under the modules directory for that app. this is just my own special code. The important thing to note is that you have to pass the directory

Re: [web2py] How to implement multiple filter for grid?

2012-11-01 Thread Jim Steil
Lamps Wish I could be more help with your questions. Here is my take. 1. If you are thinking about having a large list, I would try to avoid that. Maybe your DISTINCT keyword will keep the list small. My thoughts are that a long list (25 entries or more) is not very user friendly and if I

Re: [web2py] Re: MySQL migration issues with DAL outside of web2py

2012-10-30 Thread Jim Steil
appreciate it. -Jim On Tue, Oct 23, 2012 at 4:46 PM, Jim Steil ato@gmail.com wrote: Ok, I've got it now to where there are files in the databases directory, but still getting empty list for print db.tables -Jim On Tue, Oct 23, 2012 at 4:21 PM, Niphlod nip...@gmail.com wrote: auto_import

Re: [web2py] Re: Image Tutorial and linked_tables

2012-10-26 Thread Jim Steil
Ok, I made a sample app from scratch. I added the db code to the default db.py and added the model to to default.py. Here is what I added to db.py: db.define_table('image', Field('title', unique=True), Field('file', 'upload'), format = '%(title)s') db.define_table('comment',

Re: [web2py] Re: Problem accessing images

2012-10-24 Thread Jim Steil
No, I'm not sure. How could I tell? -Jim On Wed, Oct 24, 2012 at 9:45 AM, Niphlod niph...@gmail.com wrote: your exception points to http://effbot.org/zone/pil-imaging-not-installed.htm are you sure that apache and shell version of python are the same and can reach the same modules ? On

Re: [web2py] Re: Problem accessing images

2012-10-24 Thread Jim Steil
Both are showing the same version. 2.7.2 (default, Jun 12 2011, 15:08:59) [MSC v.1500 32 bit (Intel)] -Jim On Wed, Oct 24, 2012 at 10:30 AM, Niphlod niph...@gmail.com wrote: import sys print sys.version ? On Wednesday, October 24, 2012 4:47:06 PM UTC+2, Jim S wrote: No, I'm not sure.

Re: [web2py] Re: Image Tutorial and linked_tables

2012-10-24 Thread Jim Steil
What does your model look like in regard to the two tables. -Jim On Wed, Oct 24, 2012 at 1:38 PM, David Simmons shortlypor...@gmail.comwrote: On Wednesday, October 24, 2012 3:37:17 PM UTC+1, Jim S wrote: Are you logged in? On Tuesday, October 23, 2012 12:32:32 PM UTC-5, David Simmons

Re: [web2py] Re: Problem accessing images

2012-10-24 Thread Jim Steil
Wow, do I ever owe you. Hopefully our paths will cross someday and I can buy you a beer! Thanks much, really appreciated. -Jim On Wed, Oct 24, 2012 at 2:06 PM, Niphlod niph...@gmail.com wrote: ok, got a new answer for you. apparently, it's a pretty common error on win.

Re: [web2py] Re: Image Tutorial and linked_tables

2012-10-24 Thread Jim Steil
How about you try this: @auth.requires_membership('manager') def manage(): grid = SQLFORM.smartgrid(db.image) return locals() Just remove the linked_tables altogether. You shouldn't have to provide it. I typically leave it blank and only provide it when I'm trying to prevent others from

Re: [web2py] Re: MySQL migration issues with DAL outside of web2py

2012-10-23 Thread Jim Steil
It is empty. On Tue, Oct 23, 2012 at 4:01 PM, Niphlod niph...@gmail.com wrote: is your databases folder filled with the .table files relative to the tables ? On Tuesday, October 23, 2012 10:57:04 PM UTC+2, Jim S wrote: Hi - I use MySQL for my database. In my production environment I'm

Re: [web2py] Re: MySQL migration issues with DAL outside of web2py

2012-10-23 Thread Jim Steil
Ok, I've got it now to where there are files in the databases directory, but still getting empty list for print db.tables -Jim On Tue, Oct 23, 2012 at 4:21 PM, Niphlod niph...@gmail.com wrote: auto_import scans the table files for tables. That's the whole point of not redefining models

Re: [web2py] Re: MySQL migration issues with DAL outside of web2py

2012-10-23 Thread Jim Steil
:46 PM, Jim Steil ato.st...@gmail.com wrote: Ok, I've got it now to where there are files in the databases directory, but still getting empty list for print db.tables -Jim On Tue, Oct 23, 2012 at 4:21 PM, Niphlod niph...@gmail.com wrote: auto_import scans the table files for tables. That's

Re: [web2py] Re: Smartgrid Add button missing

2012-09-27 Thread Jim Steil
Thanks Massimo, appreciate the promptness. On Sep 27, 2012 2:23 PM, Massimo Di Pierro massimo.dipie...@gmail.com wrote: I do not have this problem with the trunk version but I looked at the code and found a potential problem with the [add] button in case of custom search_widgets in grid. I

<    1   2   3   4   5   6   >