[web2py] Re: How to get selective update rows from SQLFROM.grid

Hi everyone, Can some one please help me on this issue. I need a working example where few table entries are editable (only for the user who has entered the information). Thanks Sarbjit -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group.

Re: [web2py] Re: FormWidget and Validators

> > From what I understand you are now telling me and looking at the code, the > widget function should not be implemented by me if I were to make a new > widget as it is solely used by web2py internals in such cases as SQLFORM. > The only time I can fathom implementing it is in extending SQLFO

Re: [web2py] Re: FormWidget and Validators

Thank you very much, this definitely is helping me peel the onion and get at the core; I should have definitely looked further past accepts. I noticed that the function widget() isn't required for widgets as is the case for AutocompleteWidget

[web2py] Re: FormWidget and Validators

On Wednesday, July 10, 2013 7:28:49 PM UTC-4, Mark Finkelstein wrote: > I noticed that widget objects extending FormWidget are required to > implement widget(), but couldn't find a place where that function is used. > I was wondering what it would be for as it does not seem necessary for > impl

[web2py] Re: SQLFORM.grid Feature Request

That seems like a somewhat idiosyncratic feature (particularly if you want to concatenate without any spacing or formatting). It's even more complicated that you want the concatenated fields to be exportable. Note, you can create custom exporters via the "exportclasses" argument. For an example

[web2py] FormWidget and Validators

I noticed that widget objects extending FormWidget are required to implement widget(), but couldn't find a place where that function is used. I was wondering what it would be for as it does not seem necessary for implementing widgets. I was also wondering where validators are processed. I coul

[web2py] Re: auth.settings.logout

I think this was may be a relatively recent addition and is not in the book. And yes, it's a great idea to get more familiar with the source code. Here are all the Auth settingsand messages

Re: [web2py] Error when Inserting data into table.

Get rid of migrate=False in define_table(). On Wed, Jul 10, 2013 at 9:01 AM, Prasad Muley wrote: > Hello All, > I am newbie to web2py framework. I have created one database > connection string to 'Mysql' as > > prankester@Altocumulus: ~ master ⚡ > $ bash cmdweb2py.sh > [17:21:35] > w

[web2py] Re: auth.settings.logout

thanx anthony, that was what i needed. you know i go into the api and i can find some things, but many i can not. like the list of settings of Auth. i just could dig in. maybe i should look more deeply straight through the source code. lucas -- --- You received this message because you

[web2py] SQLFORM.grid Feature Request

Does this request make sense?? Add the functionality to concatenate fields in the grid, like: fields=[db.table.field+db.table.field2,db.table2.field+db.table. field,db.table.field3,...] SQLFORM.grid(query, fields=fields,... ) I got the concatenate working via represent BUT the values do not ex

Re: [web2py] Is it possible to concatenate fileds in a grid??

read it. Dont have a clue yet.. If I use represent, the values wont show up in a csv export...sort of looking for alternatives now. Thanks On Wednesday, July 10, 2013 1:30:41 PM UTC-7, Richard wrote: > > Here you can get more clue about what I mean : > > https://groups.google.com/forum/#!topic

[web2py] Quoting in export_to_csv_file() / import_from_csv_file()

After using import_from_csv_file(), additional quotes are showing up in the db. Should I be using some different quoting in export_to_csv_file() or is this an inherent problem with specifying filter_out in in the model, or am I completely off the mark? Exporting db = 2.4.6 Importing db = 2.5.1

Re: [web2py] Is it possible to concatenate fileds in a grid??

Here you can get more clue about what I mean : https://groups.google.com/forum/#!topic/web2py/wUBbAzFHbxs On Wed, Jul 10, 2013 at 4:27 PM, Richard Vézina wrote: > If you pass to grid a select I think yes... > > Richard > > > On Wed, Jul 10, 2013 at 4:21 PM, greenpoise wrote: > >> Is it possibl

Re: [web2py] Is it possible to concatenate fileds in a grid??

If you pass to grid a select I think yes... Richard On Wed, Jul 10, 2013 at 4:21 PM, greenpoise wrote: > Is it possible to concatenate fileds in a grid?? > > -- > > --- > You received this message because you are subscribed to the Google Groups > "web2py-users" group. > To unsubscribe from thi

[web2py] Is it possible to concatenate fileds in a grid??

Is it possible to concatenate fileds in a grid?? -- --- 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, vis

[web2py] Re: list:reference + multiple=True, how to format in edit selection listbox?

Left out the 'name' field in the 'script' file when I boiled down my example. Doesn't affect the issue at hand, but just to be clear: db.define_table('script', Field('name'), Field('configs', 'list:reference config'), format='%(name)s') - Michael On Wednesday, July

[web2py] list:reference + multiple=True, how to format in edit selection listbox?

A simplified view of my db schema, with a 'config' table and a 'script' table that defines a 'configs' field that references a list of 'config' records (multiple=True). I want to be able to use multiple-selection listbox to edit the list of references on a 'script' record, and have the list bo

[web2py] Re: getting duplicate results using with_alias

Thanks Niphlod, I will give those suggestions a try when I am back in work tomorrow and let you know how it went. My use of gluon is with PyQt so I don't think I could package up an app at least not a minimal one without also providing all the PyQt source for licensing reasons. But I could prob

[web2py] Re: Component Login required via web2py the loginform doesnt render right

Hi, I've got it. I need to create a default/user.load with the same content like default/user. A little bit redundant but OK. My next Problem is Howto mark this thread as successful completed. Am Dienstag, 9. Juli 2013 21:39:43 UTC+2 schrieb Dmitri Husti: > > Hi, > I ve got a Component, with acce

Re: [web2py] SQLFORM.grid : formstyle, readable and writable control

Hi There, I am looking for a web2py developer for a medium sized job. Please could you help me?? Anyone. My email is a...@simsend.com Thank you! Andy On Wednesday, 9 November 2011 22:55:25 UTC+2, Richard wrote: > > Hello, > > I would like to know I can control generated form with SQLFORM.grid..

[web2py] Failed to Insert into Mysql Database

Hello all, I have created one table called 'Programmer'. Table creation is done successfully but whenever I tried to insert data it shows me errors 'test.Programmer' doesn't exist. I have done in following way. prankester@Altocumulus: ~ master ⚡ $ bash cmdweb2py.sh

[web2py] postgis with web2py

Can we write postgis (postgresql) queries i.e spatial queries in web2py . if yes please explain with an example , -- --- 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] Error when Inserting data into table.

Hello All, I am newbie to web2py framework. I have created one database connection string to 'Mysql' as prankester@Altocumulus: ~ master ⚡ $ bash cmdweb2py.sh [17:21:35] web2py Web Framework Created by Massimo Di Pierro, Copyright 200

Re: [web2py] Re: from sqlite to mysql with error

I started a new mysql database to make sure the no table exists. Still the same error ( I´m using mysql on amazon RDS ) 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15. 16. 17. 18. 19. 20. 21. 22. 23. Traceback (most recent call last): File "/home/ubuntu/web2py/gluon/restricted.py", line 2

Re: [web2py] Is LOAD broken in Web2Py github repo?

LOAD works again. Don't ask me why. Caching in browser/PyCharm/Dropbox? GitHub? Brainfart? I feel bad wasting your time, guys. Sorry. Marcel On 10 jul. 2013, at 14:06, Anthony wrote: > And you're sure you've got the new version of web2py.js in the app (i.e., you > didn't create the new app

[web2py] Re: app-level module no longer found before sys.path modules

I have submitted a ticket: https://code.google.com/p/web2py/issues/detail?id=1580 -- --- 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...@googl

[web2py] Re: app-level module no longer found before sys.path modules

You might try putting in a ticket as well, just to make sure it's visible. https://code.google.com/p/web2py/issues/entry -- --- 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

[web2py] Re: getting duplicate results using with_alias

check the _select() to see what's going on. if you think the generated SQL is wrong, pack a MINIMAL app with test database records to show what you want to achieve with what you are starting from. Il giorno mercoledì 10 luglio 2013 15:22:00 UTC+2, Simon Carr ha scritto: > > The following code

Re: [web2py] Re: from sqlite to mysql with error

@ramos: only if you use check_reserved (it's enabled by default in the scaffolding app) on the "can't create table" DAL is trying to create a table that is already there. If you're sure its already there set migrate to False, otherwise drop it from the database and let DAL recreate it. >

[web2py] Re: 'LazySet' object has no attribute 'table'

code changes because I am trying different scenarios as I go and as I check the group for possible solutions :) I will try this again from work. Thanks Anthony. On Wednesday, July 10, 2013 6:32:55 AM UTC-7, Anthony wrote: > > Seems like the code and the problem are changing with every post her

[web2py] Re: 'LazySet' object has no attribute 'table'

Seems like the code and the problem are changing with every post here. Note, if your represent function includes a field that itself has a represent attribute, the represent attribute of the included field does not get applied -- you have to be explicit about it. So, instead of your code, you s

[web2py] Re: 'LazySet' object has no attribute 'table'

because suppliercode and tilename are the two values I want to concatenate. I even tried adding a represent to the series table (since the series table is directly related to the supplier table) and called the represent field from the product table, in that case it brings the suppliercode.id ins

[web2py] getting duplicate results using with_alias

I have 5 records in my database. The following code gives me duplicate records. Currently every record is duplicated 5 times. Anu idwhat is going wrong. RSRisks = db( (db.risks.user == userid)& (db.risks.status == status) ).select(

[web2py] Re: 'LazySet' object has no attribute 'table'

Not sure I understand -- the error was with the "supplier" attribute -- what does it have to do with tilename? It would help if you could post the exact model code and explain exactly what is going wrong where. If you get errors when values are None, then just include a condition that checks for

[web2py] Re: 'LazySet' object has no attribute 'table'

if I add it, DB Administration works but I its value is NONE(tilename). Is as if I can do this representation on a top-down approach but not the other way around. On Wednesday, July 10, 2013 6:04:08 AM UTC-7, Anthony wrote: > > Well, I don't see a "supplier" field in the db.product model. > >

[web2py] Re: 'LazySet' object has no attribute 'table'

Well, I don't see a "supplier" field in the db.product model. On Wednesday, July 10, 2013 8:52:04 AM UTC-4, greenpoise wrote: > > sorry. This is the error I get: > > File "/home/xyz/Applications/web2py/gluon/sqlhtml.py", line 3122, in __init__ > r = represent(field, r, record) > File "/home/

[web2py] Re: 'LazySet' object has no attribute 'table'

sorry. This is the error I get: File "/home/xyz/Applications/web2py/gluon/sqlhtml.py", line 3122, in __init__ r = represent(field, r, record) File "/home/xyz/Applications/web2py/gluon/sqlhtml.py", line 66, in represent return f(value, record) File "/home/xyz/Applications/web2py/applica

[web2py] Re: 'LazySet' object has no attribute 'table'

Hard to help without knowing what the error is. On Wednesday, July 10, 2013 1:35:01 AM UTC-4, greenpoise wrote: > > AGh..tilename was in it, I just didnt include it in this thread: > > > db.define_table('supplier', >Field('suppliercode'), >Field('suppliername'), >format='%(suppliercode

[web2py] Re: auth.settings.logout

Logout doesn't involve a form, so there is no onaccept, but there is auth.settings.logout_onlogout. Anthony On Wednesday, July 10, 2013 5:40:38 AM UTC-4, lucas wrote: > > hello, > > what is the logout analog to > > auth.settings.login_onaccept = some_fxn > > or > > auth.settings.register_onaccep

Re: [web2py] Re: Is LOAD broken in Web2Py github repo?

And you're sure you've got the new version of web2py.js in the app (i.e., you didn't create the new app based on an old version of welcome.w2p that might still be on your system)? To be sure, make sure the contents look like this: https://code.google.com/p/web2py/source/browse/applications/welc

Re: [web2py] Re: Is LOAD broken in Web2Py github repo?

there's no attachment to the post . "pack an app" means "click on the pack button on the admin app to create an archive" so we can test EXACTLY your app. Il giorno mercoledì 10 luglio 2013 12:05:20 UTC+2, mjm ha scritto: > > I already did in my original post: it's the Welcome app plus a

[web2py] MemoryError using sqlite

Hi, I am using an sqlite db to store a blob locally. The blob is a pickled file of a list I have in memory. Reading the entire list into memory causes no issues, nor does saving the pickled file into the db. However, when I try to pull the blob from the database, I get a MemoryError exception,

Re: [web2py] Re: Is LOAD broken in Web2Py github repo?

I already did in my original post: it's the Welcome app plus a minimal controller+view. Marcel J. Maré On 10 jul. 2013, at 08:57, Niphlod wrote: > please pack a minimal app so we can check what's going on > > Il giorno mercoledì 10 luglio 2013 07:38:49 UTC+2, mjm ha scritto: >> >> Just to m

[web2py] auth.settings.logout

hello, what is the logout analog to auth.settings.login_onaccept = some_fxn or auth.settings.register_onaccept = some_fxn ? -- --- 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

[web2py] Re: response.menu.insert

you dont need MENU helper here.. normally, it will be used in layout html.. response.menu.insert(0, (T('Admin'), False, '')) On Wednesday, 10 July 2013 09:55:52 UTC+2, lucas wrote: > > how can i insert into response.menu? like: > > response.menu.insert(0,MENU([(T('Admin'), False, '', [])])) > >

Re: [web2py] response.menu.insert

ok, duh, i should have went with the more straight-forward slicing method. thanx. lucas -- --- 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.

Re: [web2py] response.menu.insert

it's just a list like any other. So use append and so forth. http://docs.python.org/2/tutorial/introduction.html#lists Should help. Notice in the example app he also used + to append items. BR, Jason On Wed, Jul 10, 2013 at 10:55 AM, lucas wrote: > how can i insert into response.menu? like: >

[web2py] response.menu.insert

how can i insert into response.menu? like: response.menu.insert(0,MENU([(T('Admin'), False, '', [])])) i can't seem to dynamically insert or append into menu and i am not sure why. i get the exception throwback: Traceback (most recent call last): File "/opt/web-apps/web2py/gluon/restricted.