[web2py] Re: adding jQuery effects to A helper

When you specify the "cid" argument to the A() helper, it automatically creates its own "onclick" attribute (which calls the web2py_component Javascript function to load the requested component via Ajax), thus overwriting your "onclick" attribute. Instead, you can manually write the web2py_comp

[web2py] adding jQuery effects to A helper

Hello, I am trying to add a jQuery effect to my A helper below. I am not stuck on using the A helper but it works well so that is what I am doing. Below passes a parameter to a function and the results are loaded into the div when the function finishes. I want to indicate to the user that th

[web2py] Re: Markmin and multiple HTML5 media sources

OK. I think I am done with my changes. On Tuesday, 9 April 2013 16:37:03 UTC-5, Alan Etkin wrote: > > I will take a patch but wait 1h. I am about to add two changes to allow >> ,;# in autolinks (amazon images contain ,) and allow links in images. >> > > Thanks Massimo, I don't have a patch yet, I

[web2py] Re: row = db( db['tablename'][fieldname]==value).select().first() is saying there is fieldname for objec

db(db[tablename][fieldname]==value).select() On Tuesday, 9 April 2013 13:32:02 UTC-5, Anil Nalamalapu wrote: > > How to fetch a row from the db if we are given a tablename and a fieldname > as strings? > > tablenames_list= ['a','b'] > value = x; > > fetch rows from each table in the list, so

[web2py] Re: language selector in layout.html

You can use the admin page as a example of how to create a language select. I copied the following code with some modifications: web2py/applications/admin/views/layout.html {{=T('Languages')}} {{if hasattr(T,'get_possible_languages_info'):}} {{for langinfo in sorted([(code,info[1])

Re: [web2py] Re: Custom forms controller and view separation of concerns

Anthony, thanks for your help! On 9 April 2013 17:57, Anthony wrote: > All HTML helpers act like dictionaries with respect to their attributes > (and attributes beginning with "_" become HTML element attributes), so for > a string field: > > f.custom.widget.fieldname['_size']=10 > > will yield

[web2py] row = db( db['tablename'][fieldname]==value).select().first() is saying there is fieldname for objec

How to fetch a row from the db if we are given a tablename and a fieldname as strings? tablenames_list= ['a','b'] value = x; fetch rows from each table in the list, so that the row has value 'x' for some field of the table? -- --- You received this message because you are subscribed t

[web2py] scheduler on webfaction

Hi. I have web2py installed on webfaction as my production server. I followed the web2py documentation on it's scheduler function and built an app where everything works as anticipated. (very cool!) In order to run the scheduler though I need to SSH into the server and run this command: "python

[web2py] Re: calling custom_store and custom_retrieve using parameters

Thanks Anthony. As it turned out I also needed to add db.file.type to my path so this worked a treat. I'll have a play with the retrieve function. Cheers On Tuesday, April 9, 2013 11:47:59 PM UTC+12, Anthony wrote: > > Another option -- when submitting a form, the value for db.file.client >

Re: [web2py] Re: Server-Sent Events

On Tuesday, April 9, 2013 2:50:41 PM UTC-7, Paolo Caruccio wrote: > > just a crazy question: what about if you wrap the eventsource in a web > worker? > > Not sure I'm following you on this one... How would that help? The browser is already a non-blocking event-machine... Web-workers are not aim

Re: [web2py] Re: Server-Sent Events

Well, again, Redis IS required for inter-controller communication... (the notorious "green arrows" in my picture...) Which is, to me, a trivial requirement for most production use-cases... So, to sum-up : - For inter-controller communications, you need an external message-broker (Redis/RabbitMQ).

Re: [web2py] Re: Server-Sent Events

On Tuesday, April 9, 2013 10:56:51 PM UTC+2, Arnon Marcus wrote: > > The first yield WILL block the thread, but as you say, only the thread of > that connection. So the inter-thread communication would then be solved via > another "shared" process - Redis - which will act as a message broker,

Re: [web2py] Re: Server-Sent Events

just a crazy question: what about if you wrap the eventsource in a web worker? Il giorno martedì 9 aprile 2013 22:56:51 UTC+2, Arnon Marcus ha scritto: > > The first yield WILL block the thread, but as you say, only the thread of > that connection. So the inter-thread communication would then be

[web2py] Re: Accessible_query with NoSQL adapters

On Tuesday, April 9, 2013 11:30:20 PM UTC+2, Alan Etkin wrote: > > > well, you should have for every record on mongo a copy of groups, > membership and > > auth_user if you want to do that "in one shot". > > Seems like it involves a lot of extra data stored and also possible sync > problems, i

[web2py] Re: smartgrid - limit which fields are editable after creation of record

yes, sure, i've tested it from scratch. the issue created : Issue 1440 thanks -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails

[web2py] Re: Markmin and multiple HTML5 media sources

> > I will take a patch but wait 1h. I am about to add two changes to allow > ,;# in autolinks (amazon images contain ,) and allow links in images. > Thanks Massimo, I don't have a patch yet, If I can make one I'll submit it with a new issue in the project page for revision. -- --- You rece

[web2py] Re: Accessible_query with NoSQL adapters

> well, you should have for every record on mongo a copy of groups, membership and > auth_user if you want to do that "in one shot". Seems like it involves a lot of extra data stored and also possible sync problems, i.e. reading old rbac information > The other way is having a transaction scan

[web2py] performance issue time to first byte

Hi I'm trying to improve my pageloadtimes. And so far I'm doing pretty good. I decreased the number of quests by merging some css files and some javascript. I added expire headers to pretty much every file I serve. But the most time it takes to load a page is the time to first byte. I checked my

[web2py] Re: Markmin and multiple HTML5 media sources

I will take a patch but wait 1h. I am about to add two changes to allow ,;# in autolinks (amazon images contain ,) and allow links in images. On Tuesday, 9 April 2013 13:14:21 UTC-5, Alan Etkin wrote: > > Is there any markmin notation for adding html5 audio/video with multiple > sources? > > For

Re: [web2py] Re: Server-Sent Events

The first yield WILL block the thread, but as you say, only the thread of that connection. So the inter-thread communication would then be solved via another "shared" process - Redis - which will act as a message broker, listening to submissions and submit publications for subscribers. I guess I ca

Re: [web2py] Re: REF: Displaying a Virtual Field in SQLFORM.grid throws an exception....

No problem, thanks for the answer! Richard On Sat, Apr 6, 2013 at 12:33 PM, Massimo Di Pierro < massimo.dipie...@gmail.com> wrote: > I will be fixed asap. I cannot give you a deadline. > > > On Friday, 5 April 2013 19:42:04 UTC-5, Richard wrote: > >> I fall on this exact problem, I don't see an

[web2py] Re: Accessible_query with NoSQL adapters

well, you should have for every record on mongo a copy of groups, membership and auth_user if you want to do that "in one shot". The other way is having a transaction scanning groups, membership and auth_user and cross-reference it with the "FK" of your table On Tuesday, April 9, 2013 8:24:5

[web2py] Re: Add Expire headers ga.js

if it's external you can't control it's cache headers : they are set on the server who is providing ga.js in the first place ^_^ On Tuesday, April 9, 2013 8:36:39 PM UTC+2, BlueShadow wrote: > > Hi, > I was wondering if you can set Expire headers to external files like the > google analytics jav

[web2py] Add Expire headers ga.js

Hi, I was wondering if you can set Expire headers to external files like the google analytics javascript file (ga.js) -- --- 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] Accessible_query with NoSQL adapters

Would it be possible to implement a conditional mechanism without using joins for supporting Auth.accessible_query with NoSQL adapters? It's a very useful tool but it is not available in GAE, MongoDB, etc. This would save the need for implementing custom methods for filtering queries using rbac

[web2py] Markmin and multiple HTML5 media sources

Is there any markmin notation for adding html5 audio/video with multiple sources? For example, one can do [[blah http://mylink.com/app/static/somefile.media video]] But, is this supported? [[blah http://somefile.ext http://trythisasfallback.ext http://orthis.ext video]] And what about adding

Re: [web2py] OGG ContentType (was: Re: Difference in headers upload/download vs static file, also in auth.wiki)

I replied to the other thread too :) On Tue, Apr 9, 2013 at 6:47 PM, Alan Etkin wrote: > Maybe this: >> >> audio/ogg .oga >> video/ogg .ogv >> application/ogg .ogg >> >> Reference: https://developer.**mozilla.org/en-US/docs/** >> Configuring_servers_for_Ogg_**media

Re: [web2py] OGG ContentType (was: Re: Difference in headers upload/download vs static file, also in auth.wiki)

> > Maybe this: > > audio/ogg .oga > video/ogg .ogv > application/ogg .ogg > > Reference: > https://developer.mozilla.org/en-US/docs/Configuring_servers_for_Ogg_media > > Ricardo > I belive so. This thread has a duplicate: https://groups.google.com/d/msg/web2py-developers/M1w1gqxUDpk/dRcvQyGL6p

Re: [web2py] Re: getting data from query with SQLFORM.grid

I think it will be a nice feature, would save have to querying the database twice when was required Christian. 2013/4/9 Massimo Di Pierro > h... looks like the rows are not stored. I can easily change and allow > you to do: > > > grid = SQLFORM.grid(...) > grid.rows = > > it would con

Re: [web2py] OGG ContentType (was: Re: Difference in headers upload/download vs static file, also in auth.wiki)

On Tue, Apr 9, 2013 at 4:36 PM, Alan Etkin wrote: > > changed. > > I'm not sure about the change in the content-type, but I'll open a new > thread because it is not related with the first issue posted by Nico. > > Maybe this: audio/ogg .oga video/ogg .ogv application/ogg .ogg Reference: https:/

[web2py] Re: getting data from query with SQLFORM.grid

h... looks like the rows are not stored. I can easily change and allow you to do: grid = SQLFORM.grid(...) grid.rows = it would contain the records you see on the page only. Would this be ok? Pros/Cons? On Tuesday, 9 April 2013 10:12:57 UTC-5, Christian Espinoza wrote: > > Hi Massim

[web2py] Re: PAM + Kerberos + LDAP Problem

thanks for letting us know. On Tuesday, 9 April 2013 10:00:51 UTC-5, Apoorve Mohan wrote: > > It was not a problem of web2py. Actually those users ID's were < 1000 so > pam was just ignoring them. > > On Monday, April 8, 2013 9:35:27 PM UTC+5:30, Massimo Di Pierro wrote: >> >> I have no idea but

[web2py] Re: How to merge two tables

Either way you will be using ~10,000 x 4tables x 40 cols x 20bytes/col = 30MB. If you have 1GB you have nothing to worry about. On Tuesday, 9 April 2013 09:35:40 UTC-5, David S wrote: > > This works as well! Thank you. > > I ended up adding a .export_to_csv_file() to the end of Cliff's code and

[web2py] Re: Difference in headers upload/download vs static file, also in auth.wiki

> changed. I'm not sure about the change in the content-type, but I'll open a new thread because it is not related with the first issue posted by Nico. -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and st

[web2py] Re: getting data from query with SQLFORM.grid

Hi Massimo, I'm rendering a grid in a view and I'm need add a graph to it, maybe using flot js lib the graph will need the same grid data, and I'm wondering how get the row data without running a query only for the graphs and taking advantage from the raw data used by SQLFORM.grid()... Christian

[web2py] Re: PAM + Kerberos + LDAP Problem

It was not a problem of web2py. Actually those users ID's were < 1000 so pam was just ignoring them. On Monday, April 8, 2013 9:35:27 PM UTC+5:30, Massimo Di Pierro wrote: > > I have no idea but I would sugget adding some debug statements in > ldap_auth.py and see why it fails for some users. Th

[web2py] Re: How to merge two tables

This works as well! Thank you. I ended up adding a .export_to_csv_file() to the end of Cliff's code and re-importing the data to table3. The final version of this application might see tens of thousands of lines, each with ~40 columns in each table. Which way do you think would work better? Da

Re: [web2py] Re: .sum() and .count() in grid?

well, I don't have a postgres installation at hand, but the gist of it should be clear if you can't come up with a solution I'll test it at home. On Tuesday, April 9, 2013 3:26:03 PM UTC+2, Johann Spies wrote: > > That causes an error: > > ERROR: syntax error at or near "ORDER" > LINE 2:

[web2py] Re: Difference in headers upload/download vs static file, also in auth.wiki

I changed. On Tuesday, 9 April 2013 08:49:33 UTC-5, Alan Etkin wrote: > > > I have a similar problem with web2py trunk Version > 2.4.6-stable+timestamp.2013.04.07.19.55.04 and Firefox 19.0.2 (on Ubuntu) > > Oops, it seems that Firefox does not support .mp3 files in . The > browser throws a debug

[web2py] Re: Query for an entity in GAE using id

Jose, in theory that should work. what does your decrementNumRooms method look like? How do you know that it is not the right entity key? For what it is worth, i don't use the gae Key object in my code, i just pass the web2py id to run_in_transaction and query based on that. I know that it

[web2py] Re: getting data from query with SQLFORM.grid

I do not understand the question. :-( On Tuesday, 9 April 2013 08:38:48 UTC-5, Christian Espinoza wrote: > > Hi guys, I'm answering how can I take advantage from SQLFORM.grid in order > to get aditionally the data from the query > something like: > > SQLFORM.grid(): > . > . > return (htmlco

[web2py] Re: How to merge two tables

If they fit in ram and have the same column names: rows = db(db.table1).select() rows = rows + db(db.table2).select() rows = rows + db(db.table3).select() rows = rows.sort(lambda row: row.col8) # optional On Monday, 8 April 2013 15:29:35 UTC-5, David S wrote: > > I have three tables, db.table1 db

[web2py] Re: CSV import design advice

On Tuesday, 9 April 2013 07:28:14 UTC-5, Alan Etkin wrote: > > I am looking for some advice on getting the information into the model. >> > > Do you mean you want to set the model definitions dinamically with from > csv data? > This is done. But you need an external tool: https://code.google.c

[web2py] Re: OAuth login and creating new user info

I agree. It should. We have oauth2 but perhaps we should make it easier. Any volunteer to help? Anybody has done it alreday? On Tuesday, 9 April 2013 07:21:40 UTC-5, Sean Murphy wrote: > > Hi, > > I'd like to use w2p to support facebook login. When a new user > signs up to the system, obviously,

[web2py] Re: smartgrid - limit which fields are editable after creation of record

It should work. Are you sure it does not? If so please open a ticket and link this thread. On Tuesday, 9 April 2013 02:56:35 UTC-5, 黄祥 wrote: > > why this can't work for readable? i've tried > with db.thetable.thefield.readable = (request.args(-2) == 'new') but the > result is not expected. >

[web2py] Re: How to implement PostgreSQL "ts_rank" function for full text search?

This is an interest example. Let me think if we can add an API like we did for PostGIS On Monday, 8 April 2013 17:59:31 UTC-5, Lisandro wrote: > > I've succesfully implemented postgresql fulltext search (or at least a > basic implementation). > In the model I have: > > from gluon.dal import SQLC

[web2py] Re: webiste language based on domain name?

yes. userentered = request.env.http_host if userentered=='www.mywebsite.com': T.force('en') if userentered=='www.meinewebseite.de': T.force('de') if userentered=='www.misitioweb.es': T.force('es') On Tuesday, 9 April 2013 03:37:15 UTC-5, Dragan Matic wrote: > > Is it possible to pre

[web2py] Re: Difference in headers upload/download vs static file, also in auth.wiki

> I have a similar problem with web2py trunk Version 2.4.6-stable+timestamp.2013.04.07.19.55.04 and Firefox 19.0.2 (on Ubuntu) Oops, it seems that Firefox does not support .mp3 files in . The browser throws a debugging message saying the media has invalid format and it hides the embedded media

[web2py] getting data from query with SQLFORM.grid

Hi guys, I'm answering how can I take advantage from SQLFORM.grid in order to get aditionally the data from the query something like: SQLFORM.grid(): . . return (htmlcode, rawrows) grid, rows = SQLFORM.grid(query,fields=campos, editable=False, searchable=False, deletable=F

Re: [web2py] Re: .sum() and .count() in grid?

That causes an error: ERROR: syntax error at or near "ORDER" LINE 2:SELECT row_number(ORDER BY records DESC) as id, a... ^ Regards Johann On 9 April 2013 15:11, Niphlod wrote: > try with > > SELECT row_number(ORDER BY records DESC) as id, a.* >

[web2py] Re: .sum() and .count() in grid?

try with SELECT row_number(ORDER BY records DESC) as id, a.* FROM ( SELECT sabinet.jt AS journal, count(*) AS records FROM sabinet.sabinet GROUP BY sabinet.jt ) a -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from

Re: [web2py] Re: datetime diff between tables

it seems can't handle compute for datetime diff between tables in database side, i've found the clue on controller side : *db.py* db.define_table('check_out', Field('check_in', 'reference check_in'), Field('room', 'reference room'), Field('guest', 'reference guest'), Field('descrip

[web2py] Re: .sum() and .count() in grid?

On Saturday, 6 April 2013 00:04:24 UTC+2, Niphlod wrote: > > You just need to: > - include a pkey, better if resembles a sequence, and have a Field of > type 'id' matching it > > This is not very usable. Here is an example: In postgresql: CREATE OR REPLACE VIEW sabinet.sabinet_records_per_jo

[web2py] Re: How to merge two tables

You're right about the uuid... I can't remember why it's even there and it doesn't make sense for what I'm looking to do. And your solution worked! Thank you. I don't know why I didn't see that. David On Monday, April 8, 2013 4:59:24 PM UTC-4, Cliff Kachinske wrote: > > db(db.table1.col1 == db.

[web2py] Re: CSV import design advice

> > I am looking for some advice on getting the information into the model. > Do you mean you want to set the model definitions dinamically with from csv data? 1 - Write a function for each different source > 2 - Write a function that creates a staging file that will use the same > import func

[web2py] OAuth login and creating new user info

Hi, I'd like to use w2p to support facebook login. When a new user signs up to the system, obviously, they should be added to the auth_user table. I'd like to create a new record for them also which can be linked to the auth_user. Another constraint is that I'd prefer not to modify the base gluon

[web2py] Re: preserve search criteria in sqlform.grid after component reLOAD

Thanks Niphlod, based on that I worked it out. For us mortals, here's how I did it. This is at my level of understanding, not up to one-liners yet :) The view linked to the menu the user clicks on LOADs the sqlform grid controller like so: {{=LOAD('default','order_import_status.load',ajax=Tr

[web2py] Re: calling custom_store and custom_retrieve using parameters

Another option -- when submitting a form, the value for db.file.client should be in request.vars.client, so you could do: custom_store=lambda file, filename, path: store_file(file, filename, path, db.client(request.vars.client).client_dir_name if request.vars.client else None) You will also

[web2py] Re: Server-Sent Events

ok, all clear! One point though: with a threaded webserver web2py can manage as many connections as there are free threads: it's not blocking everything at the first SSE yielding loop, it doesn't communicate with new connections as soon as there are n open connections, with n == max number of th

[web2py] Re: making your web2py application online

Hi Abbas, As mentioned by Massimo, "~usernames" are only for static files only. However web.iiit.ac.in suports PHP with a Apache2 server. It is not expected that you host a Web2py application there. Will be best if you could host it on an external server. For educational purpose, you may want to

[web2py] Re: Custom forms controller and view separation of concerns

All HTML helpers act like dictionaries with respect to their attributes (and attributes beginning with "_" become HTML element attributes), so for a string field: f.custom.widget.fieldname['_size']=10 will yield: Anthony On Tuesday, April 9, 2013 5:42:49 AM UTC-4, Nguyen Minh Tuan wrote: >

[web2py] Re: How to - using DAL for "Between"

Thanks All - I understood how SQLForm.grid works with query. Thanks for your help. Cheers Rahul On Tuesday, April 9, 2013 12:46:40 PM UTC+5:30, Niphlod wrote: > > it takes a query, not a set > query = db.table.field > 2 > grid = SQLFORM.grid(query) > -- --- You received this message be

[web2py] Re: Server-Sent Events

> the subscribe part is a method that listens "blocking" and "resumes" as > soon as a message is received (so, it blocks if there are no new messages > until there is a new one) > so, in your SSE action you should do something like (pseudo-code) > > Yup. That's my point - without gEven, it woul

[web2py] Re: Custom forms controller and view separation of concerns

Hi Anthony, I try to custom view by using form.custom, But I have trouble in format control, Ex : I want to set textbox size to 10 or whatever Can I add more attributes to form.custom.widget.fieldname? Thanks, Tuan. On Sunday, October 7, 2012 9:44:57 PM UTC+7, Anthony wrote: > Depending on

[web2py] Re: Server-Sent Events

On Tuesday, April 9, 2013 12:50:42 AM UTC+3, Paolo Caruccio wrote: > > When I wrote the small app "SSE_clock" I was searching a replacement for a > "long polling javascript code" that I was using in order to push db's table > update notifications to clients. I abandoned the project by lack of

[web2py] Query for an entity in GAE using id

Hi, I'm trying to get a Offer entity in my DB (GAE) and I'm doing something like this: offerKey = gae.Key.from_path('Offer', offer.id) # offer is my the offer using DAL. Now I have to make a decrementation inside a transaction GAE: if (not gae.run_in_transaction(decrementNumRooms, offerKey)):

[web2py] webiste language based on domain name?

Is it possible to present a language based on domain name? If I have a multiple national domains registered for my web site - for example if I have www.mywebsite.com, www.meinewebseite.de or www.misitioweb.es I would like to do something like: if userentered=='www.mywebsite.com': T.force('e

[web2py] Re: list:string type field is empty value on edit page

yeah, my mistake. thanks for correct me -- --- 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 https

[web2py] Re: smartgrid - limit which fields are editable after creation of record

why this can't work for readable? i've tried with db.thetable.thefield.readable = (request.args(-2) == 'new') but the result is not expected. on edit and view i still can read the field. anyone know about this? thank you -- --- You received this message because you are subscribed to the Goog

[web2py] Re: How to implement PostgreSQL "ts_rank" function for full text search?

there's no support for full-text queries on DAL, you have to resort to executesql. On Tuesday, April 9, 2013 12:59:31 AM UTC+2, Lisandro wrote: > > I've succesfully implemented postgresql fulltext search (or at least a > basic implementation). > In the model I have: > > from gluon.dal import SQL

[web2py] Re: How to - using DAL for "Between"

it takes a query, not a set query = db.table.field > 2 grid = SQLFORM.grid(query) -- --- 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...@g