[web2py] Re: record representation format that refer to another table and that table is refer to another table

just curious, is it possible to add the format function in the table room? *e.g. 1. no error but the result is not expected* db.define_table('room', Field('room_no'), Field('category', 'list:string'), Field('status', 'list:string'), Field('branch', 'reference branch'), format=l

[web2py] Re: record representation format that refer to another table and that table is refer to another table

very nice, it's work well, thank you so much for your hints, anthony. just want to share the code that you've guide. def format_room(record): return '%s-%s' % (record.branch.address, record.room_no) def format_booking(record): return '%s-%s %s-%s-%s' % (record.scheduled_start, record.gue

[web2py] How can I store upload original filename using smartgrid?

I'm having trouble working this one out. I've tried using the example in the book with no success. Model: db.define_table('file', Field('client', 'reference client'), Field('file', type='upload', autodelete=True), Field('filename', 'string'), format='%(file)s') Controller: def clie

[web2py] Re: simple loop question

response.write() is a method, not an attribute (even if it were an attribute, you would be overwriting it repeatedly, not appending to it). Anthony On Friday, March 22, 2013 6:51:01 PM UTC-4, Alex Glaros wrote: > > I'm trying to write a simple loop in default.py. What's wrong with this > below

Re: [web2py] how keepvalues if the page reload by the form don't even get submit?

I thougth about something like that, keep adding row and submit row with ajax... Richard On Fri, Mar 22, 2013 at 3:32 PM, Derek wrote: > Why don't you just have a webpage, have the display of current values on > top, a single form below for adding items, and submit as you go? > > > On Thursday

[web2py] Re: "4 minutes ago"

Got it - thanks. On Friday, March 22, 2013 8:27:32 PM UTC-5, Ricardo Cárdenas wrote: > > My google-fu has not helped me come up with an answer... > > Django has a set of template filters they call "humanize" which will add a > nice touch to data. (Java also has a lib called PrettyTime.) For examp

[web2py] Re: "4 minutes ago"

Sure, described here: http://web2py.com/books/default/chapter/29/14#Pretty-dates Regards, Ales On Saturday, March 23, 2013 2:27:32 AM UTC+1, Ricardo Cárdenas wrote: > > My google-fu has not helped me come up with an answer... > > Django has a set of template filters they call "humanize" which wi

[web2py] "4 minutes ago"

My google-fu has not helped me come up with an answer... Django has a set of template filters they call "humanize" which will add a nice touch to data. (Java also has a lib called PrettyTime.) For example it will convert "Fri Mar 22, 20:23" into "4 minutes ago", or "Fri Mar 21" into "yesterday"

[web2py] simple loop question

I'm trying to write a simple loop in default.py. What's wrong with this below? Thanks, Alex Glaros def new2(): y=5 while y > 0: response.write='howdy' y=y-1 pass -- --- You received this message because you are subscribed to the Google Groups "web2py-users" g

Re: [web2py] Re: Help on a web2py query

db.define_table('novela', Field('nome', requires=IS_NOT_EMPTY()), Field('emissora', 'reference emissora', requires = IS_IN_DB(db, db.emissora.id,'%(nome)s')), Field('encerrada', 'boolean', default=False), Field('slug', requires=IS_SLUG()), Field('logo', 'upload', uploadseparate=

[web2py] Re: Help on a web2py query

written as it is, in a view :P we need models, test data and the resultset you want returned, plase ^_^ On Friday, March 22, 2013 11:00:12 PM UTC+1, Tito Garrido wrote: > > Folks, > > How could I implement: > > SELECT * FROM (SELECT * FROM capitulo WHERE data >= CURDATE() ORDER BY > data) WH

[web2py] Help on a web2py query

Folks, How could I implement: SELECT * FROM (SELECT * FROM capitulo WHERE data >= CURDATE() ORDER BY data) WHERE encerrada = false GROUP BY c.cod_anothertable Regards, Tito -- Linux User #387870 . _/_õ|__| ..º[ .-.___.-._| . . . . .__( o)__( o).:___ -- --- You receive

[web2py] Re: How to exclude some fields from a form for a database record?

A good one. And for you initial requirement which was taking a particular field out of the form (not choosing the whole set of fields that the registration form should show), this is more compact, specially if you are populating the scaffolding auth_user table with custom fields: auth.settings.

[web2py] Re: send json string to a json service

Thanks . it is working now. Den fredagen den 22:e mars 2013 kl. 13:00:04 UTC+1 skrev frasse: > > > Hi > > I try to send a json string to a json service but I am geting invalid > request all the time. The echo service is works with normal string. > > do you have any idea > > Thanks > /F > > > @

[web2py] Re: Retrieve existing cache values

adding session.forget() just means that you don't need to use session variables in that controller. it has nothing to do with cache Anyway, time_expire=0 means "store this item in cache using this key" On Friday, March 22, 2013 7:42:58 PM UTC+1, Derek wrote: > > So help me out here... > > I

Re: [web2py] how keepvalues if the page reload by the form don't even get submit?

Why don't you just have a webpage, have the display of current values on top, a single form below for adding items, and submit as you go? On Thursday, March 21, 2013 9:14:05 AM UTC-7, Richard wrote: > > Hello, > > I have a bizzard case where I need to set the number of input (more number > of ro

Re: [web2py] Problem with legacy db and primarykey

I don't know legacy primary key web2py feature, but it is strange if your premarykey fields are writable=false how could it be possible to fill those records since they will not be accessible in your form? At the end of the section about legacy table in the book : http://web2py.com/books/default/c

[web2py] Re: Retrieve existing cache values

So help me out here... I have this code: def saveAddress(): #session.forget(response) houses = None useCached = True if request.post_vars.address: useCached = False newhouse = db.house.insert(address=request.post_vars.address,person =request

[web2py] Problem with legacy db and primarykey

I have a MSSQL database with a 4 column primary key: dbcomercial.define_table('libros', Field('bloque',writable=False), Field('grupo',writable=False), Field('sector',writable=False), Field('libro',w

[web2py] Re: How to exclude some fields from a form for a database record?

I found a cleaner solution after some digging. In db.py, after creating the auth object, include the line: auth.settings.register_fields = ['id', 'first_name', 'last_name', 'email', 'password'] or if when you created the auth object you passed in username=True, include the line: auth.settings

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

> It returns all the rows which are visible in view. My requirement is that I want to make edit/delete button visible only for the user's > whose userid is same as some predefined value "SOMEUSER", for other userid's edit/delete button should be disabled/not visible. > Can some one please tell m

[web2py] Re: How to exclude some fields from a form for a database record?

> Do I just need to write a custom form and a custom handler for the post, or is there an easy way to do this? You could set the the readable and writable attributes to False only if the scaffolding registration action is called: if request.function == "user" and "register" in request.args:

[web2py] Re: send json string to a json service

you're trying to send a (likely) unparseable string as arg instead of a var. i.e. http://whatever/app/services/call/json/echo/possibly_bogus_characters_not_allowed_in_a_uri first of all make sure that your services.py holds the def call(): session.forget() return service() function a

Re: [web2py] need help with typeahead widget

With the SELECT, better initialisation and no more roundtrip to get the value representation : def autocomplete_typeahead_widget(field, value, referenced_table, represent_field, id_field, controller, **kwargs): table_name = field._tablename field_name = field.name field_requires = fiel

[web2py] Re: Retrieve existing cache values

Niphlod and Anthony, Thanks so much for your comments which have assisted me both to understand and get it working. It seems that I missed the following paragraph in the book: time_expire = None Forces retrieval of the cached value, regardless of the time elapsed since it was saved (if tim

[web2py] Re: WebFaction

Eu havia conseguido fazer o admin funcionar, e quando acessei a página da aplicação deu um erro: Traceback (most recent call last): File "/home/igrejarama/webapps/rama/web2py/gluon/restricted.py", line 212, in restricted exec ccode in environment File "/home/igrejarama/webapps/rama/web2p

[web2py] Re: Retrieve existing cache values

Maybe this would work: cache.ram('MyValue', lambda: getvalue() or cache.ram('MyValue', lambda: None,time_expire =None), time_expire=60*60*24) Calling cache.ram() with time_expire=None always retrieves the currently stored value, so you can assign that if getvalue() returns No

[web2py] Re: Retrieve existing cache values

this is one of the design patterns of the cache in web2py that makes a little more cumbersome than others cache interface to understand ... assuming you're using cache.ram, when you do cache.ram(key, value, 60) for the first time what you're really doing is "store value, tag it with key and 60

[web2py] Retrieve existing cache values

1. How can I view a currently cached value, without any possibility of changing it? 2. Say I have this code: def getvalue(): try: return function_that_may_not_complete() except: return None cache.ram('MyValue', lambda: getvalue(), time_expire=60*60*24) If my

[web2py] Re: record representation format that refer to another table and that table is refer to another table

Sorry, wasn't thinking -- the validator is selecting a record from the "room" table, not the "booking" table, so you'll need a slightly different function for that: IS_IN_DB(..., label=lambda r: '%s %s' % (r.branch.address, r.room_no)) or if want to use a single function (not tested): def form

[web2py] send json string to a json service

Hi I try to send a json string to a json service but I am geting invalid request all the time. The echo service is works with normal string. do you have any idea Thanks /F @service.json def echo(data): """ echo test """ return data My client things = "[hi,ho]" url = "http

[web2py] How to exclude some fields from a form for a database record?

I recently found out how to add an additional field to the auth_user table, but then I found that the registration page for a new user has a spot in the form to input a value for the extra field. In many cases, this is desired, but I want this particular field to not appear in the registration

[web2py] Re: Doing validation using sqlform grid onupdate or ondelete callbacks

Thanks, awesome answer ! I think I'm gonna go with the table callback method, I kind of feel safer when doing security checks closer to the DB (maybe I'm wrong...) - For the second solution (Authorization), as I am using a sqlform.grid, I need to provide a query and not rows. So I tried

[web2py] Re: Doing validation using sqlform grid onupdate or ondelete callbacks

Thanks, This solution is working fine for the edit part. You gave me a better understanding of the form validation mechanism, thanks. However I think I'm gonna go with luismurciano's approach which seems closer to what I am looking for... Thanks again for your help! Le jeudi 21 mars 2013 21:0

[web2py] Re: Pythonanywhere down today?

On Friday, March 22, 2013 4:33:48 AM UTC, Cliff Kachinske wrote: > The Python anywhere web site was down earlier today. There was a brief outage at 13:40 UTC on 21 March while we upgraded the system -- is that the downtime you meant? We're not aware of any other outages, but if you saw prob

[web2py] TextField validation

Hi EveryOne, i want to ask about the textvalidation in web2py, i have a form with few mandatory fields when user submit the form without fillling these fields, an error or alert generated right below every field but when user start typing it still remains untill you submit the form, I want to

Re: [web2py] Re: Is there some code reader like source insight for python?

Hi, On 22/03/13 09:29, Niphlod wrote: ehm ? what ? I was intrigued, so had a Google... The OP seems to want something like this: - http://www.sourceinsight.com/ ...which seems to be inspired by this: - http://cscope.sourceforge.net/ ...which in turn led me to this: -

[web2py] Re: Access data in PUT request for @request.restful()

Thanks Massimo, I realize now that those variables are also in **vars (request.restful interface ) I wonder how conflicts between query parameters and body parameters are resolved. BR, Daniel On Friday, March 22, 2013 6:02:32

[web2py] Re: Is there some code reader like source insight for python?

ehm ? what ? On Friday, March 22, 2013 9:06:51 AM UTC+1, RunSky ruan wrote: > > I want to read the douce code of web2py ,but three are no good code reader. -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and

[web2py] Re: Backup & Restore problems

Sure. As long as what can and cannot be expected from the functions is clear, I'm happy with your way! Le jeudi 21 mars 2013 16:44:17 UTC+1, Niphlod a écrit : > > my point exactly it's a matter on how it's perceived as a > one-solution-for-all-exporting-problem vs a rapid way to load fixtur

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

Hello All, I am a newbie to web2py and developing my test app. I want to present all the entries in a db using SQLFORM.grid with the option to edit/delete rows based on user name. e.g. My models are like: Person table with entries name, userid, address, phone number. Controller looks like :

[web2py] Is there some code reader like source insight for python?

I want to read the douce code of web2py ,but three are no good code reader. -- --- 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