[web2py] Re: Postgres LIKE case sensitive

2011-12-17 Thread Massimo Di Pierro
Not very easy because the dal does implement a mechanism to pass parameters to adapter when delegating a function. Let me think about this... meanwhile please open an issue so your propose will be tracked. massimo On Dec 17, 11:58 pm, Floyd wrote: > Hello everybody, > I found that using .like()

[web2py] Postgres LIKE case sensitive

2011-12-17 Thread Floyd
Hello everybody, I found that using .like() method with Postgresql actually perform a case insensitive search (it uses ILIKE not LIKE). I read an old thread stating that this is for compatibility issues with mySql. I have a very big table with text field in upper-case so I don't need ILIKE but a

[web2py] nice article on web2py

2011-12-17 Thread Massimo Di Pierro
http://pixelturf.com/2011/12/15/if-python/ :-)

[web2py] Re: bug in changeset # d027fbf7601d > http://code.google.com/p/web2py/issues/detail?id=355

2011-12-17 Thread Carlos
Hi Massimo, Yes I'm using virtual lazy fields in the user table. Carlos

[web2py] Re: bug in changeset # d027fbf7601d > http://code.google.com/p/web2py/issues/detail?id=355

2011-12-17 Thread Massimo Di Pierro
Are you using virtual fields or storing functions in auth.user? Massimo On Dec 17, 7:32 pm, Carlos wrote: > Hi, > > I'm getting the following traceback after applying changeset # d027fbf7601d > > >http://code.google.com/p/web2py/issues/detail?id=355... > > Traceback (most recent call last): >  

[web2py] Re: bug in changeset # d027fbf7601d > http://code.google.com/p/web2py/issues/detail?id=355

2011-12-17 Thread Massimo Di Pierro
I reverted the change until it is tested more. On Dec 17, 7:32 pm, Carlos wrote: > Hi, > > I'm getting the following traceback after applying changeset # d027fbf7601d > > >http://code.google.com/p/web2py/issues/detail?id=355... > > Traceback (most recent call last): >   File "C:\web2py\gluon\main

[web2py] Re: smartgrid - still not resolving a problem

2011-12-17 Thread Massimo Di Pierro
The jquery.checkbox plugin replaces the usual checkbox with a [yes]/ [no] slider. If I replace 'slide' with 'click' the [yes]/[no] behaves the opposite way (yes for unchecked and no for checked). weird. On Dec 17, 8:17 pm, Anthony wrote: > On Saturday, December 17, 2011 7:46:51 PM UTC-5, Massimo

[web2py] Re: question about google app engine blob property

2011-12-17 Thread Massimo Di Pierro
Can you shows us exactly which extra field causes the conflict? Massimo On Dec 17, 8:09 pm, chawk wrote: > I am trying to build an app for google app engine.  I currently use > the auth_user for website registration.   I added some extra fields to > the registration.  I was trying to add an addi

[web2py] Re: Problem with form submission in nested components

2011-12-17 Thread monotasker
I thought some code might help. Here's the class that creates the LOAD helper to hold a form field widget: class AjaxSelect: def __init__(self, field, value, linktable): self.field = field self.value = value self.linktable = linktable def widget(self): #

[web2py] Problem with form submission in nested components

2011-12-17 Thread monotasker
I have a SQLFORM in a component that works smoothly. I'm placing another component inside that form, which loads just fine. But with that nested component present the form is no longer processed properly. The POST values (visible in Firebug) are all identical, whether or not the nested component

[web2py] Re: smartgrid - still not resolving a problem

2011-12-17 Thread Anthony
On Saturday, December 17, 2011 7:46:51 PM UTC-5, Massimo Di Pierro wrote: > > It was click. I switched to live because click broke > jquery.checkboxes.js plugin which I found very useful for something I > am building. How did it break? Do you need the event handler to attach to elements that are

[web2py] Re: SQLFORM.grid custom labels in edit form for each row

2011-12-17 Thread Anthony
Sorry, forgot that the label will get escaped. Anyway, there is now a fix in trunk. On Saturday, December 17, 2011 4:58:49 PM UTC-5, brushek wrote: > > > The bug isn't with LABEL, it's with SQLFORM.search_menu, which tries to > > translate field.label without first converting to a string in case

[web2py] question about google app engine blob property

2011-12-17 Thread chawk
I am trying to build an app for google app engine. I currently use the auth_user for website registration. I added some extra fields to the registration. I was trying to add an additional auth_user field for avatar file upload. it appears that this will conflict with google blob property. Doe

[web2py] bug in changeset # d027fbf7601d > http://code.google.com/p/web2py/issues/detail?id=355

2011-12-17 Thread Carlos
Hi, I'm getting the following traceback after applying changeset # d027fbf7601d > http://code.google.com/p/web2py/issues/detail?id=355 ... Traceback (most recent call last): File "C:\web2py\gluon\main.py", line 523, in wsgibase session._try_store_on_disk(request, response) File "C:\web2p

[web2py] Re: smartgrid - still not resolving a problem

2011-12-17 Thread Massimo Di Pierro
It was click. I switched to live because click broke jquery.checkboxes.js plugin which I found very useful for something I am building. On Dec 17, 3:05 pm, Anthony wrote: > On Saturday, December 17, 2011 3:36:59 PM UTC-5, Massimo Di Pierro wrote: > > > We have this line in web2py.js: > > > jQuery

[web2py] Re: book 4th edition in PDF

2011-12-17 Thread Massimo Di Pierro
Should now work with Amex. On Dec 17, 1:46 pm, Adi wrote: > amex - invalid expression. should i wait, or to use other card?

[web2py] Re: book 4th edition in PDF

2011-12-17 Thread Massimo Di Pierro
generating epubs is next on the list. The plan is to allow to download you different formars once you buy one... work in progress On Dec 17, 4:10 pm, davidjensen wrote: > I buy ebooks from the internet commonly. Amazon, Barnes and Noble and > book publishers put table of contents, index, sample c

[web2py] Re: how to set the id of a textarea of a SQLFORM?

2011-12-17 Thread Alan Etkin
Once you have the object returned by SQLFORM(..), it can be explored with the method elements() wich returns a list of objects contained in the form. So you could iterate trough the list, and if the element is of type gluon.html.TEXTAREA, customize it with something like this: sub-element.attribut

[web2py] application can't find modules on fluxflex.com

2011-12-17 Thread ma...@rockiger.com
Hi I have a strange error: I uploaded the web2py-book application via git to my fluxflex account and I get the following error message: No module named plugin_notemptymarker If I look in the app admin indeed the plugin_notemptymarker.py file is not shown under modules. So I uploaded the fil

[web2py] Re: book 4th edition in PDF

2011-12-17 Thread Adi
got it w visa :) Thanks Massimo!

[web2py] Re: book 4th edition in PDF

2011-12-17 Thread davidjensen
Addendum: It would be nice to see it on Safari. On Dec 17, 4:41 pm, Massimo Di Pierro wrote: > I forgot amex has 15 digits cc numbers. I do not have ssh connection > at this time. I will fix this tonight. > > On Dec 17, 1:46 pm, Adi wrote: > > > > > > > > > amex - invalid expression. should i wa

[web2py] Re: book 4th edition in PDF

2011-12-17 Thread davidjensen
I buy ebooks from the internet commonly. Amazon, Barnes and Noble and book publishers put table of contents, index, sample chapters, surprise me, etc. I did not see any of those on the site. Also, it appears that many ebooks are going to epub. I am experimenting with NLP, the semantic web and oth

[web2py] Re: SQLFORM.grid custom labels in edit form for each row

2011-12-17 Thread brushek
> The bug isn't with LABEL, it's with SQLFORM.search_menu, which tries to > translate field.label without first converting to a string in case the > label is an HTML helper. > > Should be an easy fix, but for now, you can do: > > label=str(IMG(...)) > > or > > label=IMG(...).xml() None of this sou

[web2py] Re: smartgrid - still not resolving a problem

2011-12-17 Thread Anthony
On Saturday, December 17, 2011 3:36:59 PM UTC-5, Massimo Di Pierro wrote: > > We have this line in web2py.js: > > jQuery("input[type='checkbox'].delete", target).live('click',function() > { if(this.checked) if(!confirm(confirm_message)) > this.checked=false; }); > Actually, in this case (as with th

[web2py] Re: book 4th edition in PDF

2011-12-17 Thread Massimo Di Pierro
I forgot amex has 15 digits cc numbers. I do not have ssh connection at this time. I will fix this tonight. On Dec 17, 1:46 pm, Adi wrote: > amex - invalid expression. should i wait, or to use other card?

[web2py] Re: smartgrid - still not resolving a problem

2011-12-17 Thread Massimo Di Pierro
We have this line in web2py.js: jQuery("input[type='checkbox'].delete", target).live('click',function() { if(this.checked) if(!confirm(confirm_message)) this.checked=false; }); what should be change it into? On Dec 16, 8:57 pm, Anthony wrote: > On Friday, December 16, 2011 5:54:54 PM UTC-5, Cli

[web2py] how to set the id of a textarea of a SQLFORM?

2011-12-17 Thread Pepe Araya
Hello! is possible to set the id of a textarea of a SQLFORM? I have 2 forms on the same page but the textarea of both have the same id... thanks

[web2py] Re: book 4th edition in PDF

2011-12-17 Thread Adi
amex - invalid expression. should i wait, or to use other card?

[web2py] Re: smartgrid - still not resolving a problem

2011-12-17 Thread Adi
Thanks Anthony, delegate works perfectly fine :) I just saw somewhere too that live is being retired.. On top of everything I wanted to use the autocomplete feature instead of dropdown, but have to figure out the ways around when user selects the item, how to combine autocomplete events and th

[web2py] Re: the Set class should be deprecated

2011-12-17 Thread Massimo Di Pierro
I am reading this over and over... "a == b is a boolean". I know what you mean but it may be confusing to other users so I will clarify. It is a boolean when a and b have values, else it is just an expression. In dal, "a==b" is a query (an expression) that is evaluated on every record and if it ret

[web2py] Re: book 4th edition in PDF

2011-12-17 Thread Massimo Di Pierro
Good I think we can close this thread. I may change the app link as I merge with the html version. Possibly later today if I manage to dodge the holiday shopping. Massimo On Dec 17, 12:50 pm, Pepe Araya wrote: > Work for me. > > thanks.

[web2py] Re: book 4th edition in PDF

2011-12-17 Thread Pepe Araya
Work for me. thanks.

[web2py] Re: the Set class should be deprecated

2011-12-17 Thread Alan Etkin
> @Alan Etkin > Actually, (db.mytable.id == 3) is neither a tuple or a bool. The == > operator used on a field returns a Query object. Yes, you are right, what i was trying to say is that this: (a == b).select() is more confusing to me than the normal web2py instruction because in a python progr

Re: [web2py] Re: book 4th edition in PDF

2011-12-17 Thread Günter Kolousek
No problems with Mastercard! Cheers, Günter Am 2011-12-17 17:53, schrieb greenpoise: I get invalid expression in the card number...American express is the card..I tried no spaces between numbers& - but is a no go. On Dec 17, 8:43 am, Angelo Compagnucci wrote: I bought it! Wonderful!

[web2py] Re: book 4th edition in PDF

2011-12-17 Thread greenpoise
I get invalid expression in the card number...American express is the card..I tried no spaces between numbers & - but is a no go. On Dec 17, 8:43 am, Angelo Compagnucci wrote: > I bought it! > > Wonderful! > > 2011/12/17 Alan Etkin > > > > I did not understand that point. What did you mean?

Re: [web2py] Re: book 4th edition in PDF

2011-12-17 Thread Angelo Compagnucci
I bought it! Wonderful! 2011/12/17 Alan Etkin > > I did not understand that point. What did you mean? > > Ok, now i get it: > > Do not download if other customer has not reported back yet > > And the watermark has to be the text in the footer. > -- Profile: http://www.gild.com/compagnuccian

[web2py] Re: the Set class should be deprecated

2011-12-17 Thread lyn2py
I'm new to web2py and python, but if this argument is purely syntactic, I thought it would be db(table.id > 0).select() rather than (db.table.id > 0).select() Nonetheless, I'm good with what we have now, especially the ample examples in the web2py book to help me get up to speed. DAL is great!

Re: [web2py] Web Resources

2011-12-17 Thread Javier Quarite
On Sat, Dec 17, 2011 at 10:51 AM, chandrakant kumar wrote: > Hi Javier > > I'm working on same, let me know if we can collaborate. > > > Really? Well I'm actually beginning with web2py, It just came as an idea this project because I've seen others and also I was wondering how to do something like

[web2py] Re: SQLFORM.grid custom labels in edit form for each row

2011-12-17 Thread Anthony
The bug isn't with LABEL, it's with SQLFORM.search_menu, which tries to translate field.label without first converting to a string in case the label is an HTML helper. Should be an easy fix, but for now, you can do: label=str(IMG(...)) or label=IMG(...).xml() either of which will convert the

Re: [web2py] Web Resources

2011-12-17 Thread chandrakant kumar
Hi Javier I'm working on same, let me know if we can collaborate. On Sat, Dec 17, 2011 at 5:34 PM, Javier Quarite wrote: > Thanks everyone for the information, I'll try to read the documentation of > pythonfiddle because its FOSS, and try to do one using web2py hope it > works =) > > > Javi

[web2py] Re: SQLFORM.grid custom labels in edit form for each row

2011-12-17 Thread brushek
But... LABEL have some bug: http://code.google.com/p/web2py/issues/detail?id=566 On 16 Gru, 23:32, Anthony wrote: > In your table definition, you can specify a 'label' argument for each > field, and I think that can be whatever you want (e.g., an IMG tag, etc.). > > db.define_table('mytable',

[web2py] Re: book 4th edition in PDF

2011-12-17 Thread Alan Etkin
> I did not understand that point. What did you mean? Ok, now i get it: Do not download if other customer has not reported back yet And the watermark has to be the text in the footer.

[web2py] Re: Cron on FluxFlex

2011-12-17 Thread John Oliva
Thanks Alan.

[web2py] Record Versioning

2011-12-17 Thread Ron McOuat
Might not be a problem but the table mpn has a field with the same name mpn and the problem goes away if the archive portion of onaccept is removed.

[web2py] Re: Having multiple layouts (themes) and choosing from one

2011-12-17 Thread Alan Etkin
I think you could put conditional blocks inside a view included by the default layout: Then it should be possible to customize the views with user input or values stored in the database The view must have the {{ extend "layout.html" }} line And you can override the layout blocks with {{ block ...

Re: [web2py] Web Resources

2011-12-17 Thread Javier Quarite
Thanks everyone for the information, I'll try to read the documentation of pythonfiddle because its FOSS, and try to do one using web2py hope it works =) Javier Q

[web2py] Re: Cron on FluxFlex

2011-12-17 Thread Alan Etkin
The web2py book says: * hard cron: available if using the built-in web server (either directly or via Apache mod_proxy) * external cron: available if you have access to the system’s own cron service This post might help: http://getsatisfaction.com/fluxflex/topics/cant_we_use_crontab Apparently

[web2py] Re: book 4th edition in PDF

2011-12-17 Thread Alan Etkin
It worked, but i have a couple of questions: > do not try download is somebody else is an has not reported back. I did not understand that point. What did you mean? The downloaded book has a line added to each page with: "...copy exclusive for visa (a885b100 (...) d9b7f58b50eb)..." Is that th

[web2py] Re: book 4th edition in PDF

2011-12-17 Thread Alan Etkin
I am trying On Dec 16, 9:51 pm, Massimo Di Pierro wrote: > I apologize posting the electronic version of the book 4th ed in html > and pdf is taking longer than expected but truly I am almost done. The > delay was due to these facts: > > 1) complete rewrite of the online book app > 2) do not use

Re: [web2py] book 4th edition in PDF

2011-12-17 Thread Randolph Chaves
Worked for me! On Fri, Dec 16, 2011 at 10:51 PM, Massimo Di Pierro < massimo.dipie...@gmail.com> wrote: > I apologize posting the electronic version of the book 4th ed in html > and pdf is taking longer than expected but truly I am almost done. The > delay was due to these facts: > > 1) complete

[web2py] Re: book 4th edition in PDF

2011-12-17 Thread puercoespin
Massimo, why not use paypal or google cart for payment? I dont know what is stripes.. > BTW. This uses stripes for payment I do not store any client info. > I do store your email, name and order so that, in the future you will > be able to download new version without paying again.

[web2py] Re: Solidform: key-error

2011-12-17 Thread kenji4569
Hi Johann, I've just investigated the problem. Do you use virtual fields for computing the article_eq and ltitle? If so, SOLIDFORM as well as SQLFORM need to know the filed properties of the virtual fields, such as labels and representation. Then, one solution would be to define a "virtual table"

Re: [web2py] Re: Add placeholder to password field in web2py login form

2011-12-17 Thread Abhishek Gupta
Sorry, I got the error. Correct thing to be done was : {{register_form.element('input#auth_user_username')['_placeholder'] = 'Username'}} On 17 December 2011 12:48, Abhishek Gupta wrote: > Thanks, it worked. > > But surprisingly > form.element('input.username')['_placeholder'] = 'Username' > > d

Re: [web2py] Re: MARKMIN indentation

2011-12-17 Thread Vasile Ermicioi
aha, ok thank you