[web2py:14297] Re: how to do dal not like?

2008-12-30 Thread vince
oh thanks alot. i was searching for this NOT operator on the manual for long! -vince On Dec 30, 3:56 pm, "Yarko Tymciurak" wrote: > On Tue, Dec 30, 2008 at 1:34 AM, vince wrote: > > > anyway to do sql not like? > > db(!(db.members.name.like('%a%'))).select() or something like that? > > try: >

[web2py:14298] Re: how to do dal not like?

2008-12-30 Thread Yarko Tymciurak
yeah It's listed in the book index under "not" -- the logical operators section... and also mentioned in the section about orderby as a negation operator (to get reverse ordering) On Tue, Dec 30, 2008 at 2:01 AM, vince wrote: > > oh thanks alot. i was searching for this NOT operator on the

[web2py:14299] Re: an equivalent for Django edit-inline tabular/stacked form

2008-12-30 Thread mdipierro
Thank you. I will look into it. I agree it would be useful. Massimo On Dec 29, 3:59 pm, xpareto wrote: > 1. Mr. Prof. Di Pierro ,thank you for this great work . I wish web2py > become for the web frameworks what Python is for the programming > languages - an optimum mix of power, simplicity and

[web2py:14300] Re: code of conduct - open source organization

2008-12-30 Thread mdipierro
I agree. On Dec 29, 9:13 pm, Kirby Turner wrote: > I read through the current draft of the organization charter and it > seems like a great start. But parts of the Code of Conduct seem too > restrictive especially for my situation. I am self-employed - been in > business for just over 5 years.

[web2py:14301] Re: sqlrow to json again

2008-12-30 Thread mdipierro
Thank you Tim, your patch is in trunk! Massimo On Dec 29, 3:09 pm, Timothy Farrell wrote: > OK, I've got my faster method ready. But I have a question before we lock > down the API. > In your method, you have the mode parameter as either a dict or list type. > While expressing a similar tho

[web2py:14302] Re: Many-to-Many widgets

2008-12-30 Thread Fran
On Dec 30, 5:59 am, vince wrote: > http://groups.google.com/group/web2py/browse_thread/thread/29655ebffb... > this is a simple one. maybe you can base on this widget and workout > something. t2.widget() is indeed a nice, simple UI to look at borrowing from. This uses a single text field to store

[web2py:14303] Re: Many-to-Many widgets

2008-12-30 Thread Fran
> t2.widget() t2.tag_widget() of course ;) Another issue with using this widget as-is would be referential integrity - need to ensure that all lists are updated if 'tags' are deleted (not generally an issue for real tags, but is for when trying to squeeze m2m functionality into here) F --~--~--

[web2py:14304] Re: Many-to-Many widgets

2008-12-30 Thread Fran
& another limitation ;) I need to be able to store both UUI & Name. t2.tag_widget() can't store dicts, only lists... F --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this gr

[web2py:14305] Re: T3 patterns - wishfull thinking

2008-12-30 Thread notabene
Thank You very much for Your suggestions. But ... The copy function was not meant as a record copy function - but as a t2.create function where a record was used as default values in the form. Regarding the popup-window. That is must usefull. But I don't see where the manipulation/edit of a fie

[web2py:14306] Re: google messed up?

2008-12-30 Thread mr.freeze
http://mdp.cti.depaul.edu seems to be the first hit on google again. That's good. On Dec 29, 1:50 pm, "Yarko Tymciurak" wrote: > some AS228822 info:http://www.robtex.com/dns/llnw.net.html > > On Mon, Dec 29, 2008 at 1:37 PM, mr.freeze wrote: > > >http://www.google.com/safebrowsing/diagnostic?si

[web2py:14307] response.slash?

2008-12-30 Thread mr.freeze
On line 404 of admin/controllers/default.py there is this: if not response.slash and app==request.application: Is this a typo or real object? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" g

[web2py:14308] Re: Many-to-Many widgets

2008-12-30 Thread vince
oh actually i haven't look t2's widget yet. i'll have a look i will need to sort out a widget for m2m using multiple select box too soon. i'll post it here if i come up with anything. i had an implement for below 50 options using a single text field holding the id in csv. that's no good for you i

[web2py:14309] Re: open source organization again

2008-12-30 Thread dhmorgan
from Charter, goals section: > 2. Certify the knowledge and ethical standards of its members I'm wondering what that might look like. - Daniel On Dec 27, 1:18 pm, mdipierro wrote: > Some of you may remember previous threads on creating an organization > to support web2py adoption and provide

[web2py:14310] central widget repository

2008-12-30 Thread mr.freeze
Is there one? If not, should there be one? I love widgets. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe fr

[web2py:14311] Re: open source organization again

2008-12-30 Thread mmstud
On 30 joulu, 18:55, dhmorgan wrote: > from Charter, goals section: > > > 2. Certify the knowledge and ethical standards of its members > > I'm wondering what that might look like. Thou shalt not condemn other coders. And if coder requests help for one line, give him two. But seriously, im inter

[web2py:14312] Re: T3 patterns - wishfull thinking

2008-12-30 Thread Yarko Tymciurak
Have you looked at using mydb.mytable.myfield.default=pattern? You can copy standard fields this way, by selecting a record, saving it in a row, and using that as the default field.The default fields can change programmatically (so they can be different over execution, e.g. one thing a

[web2py:14313] Re: google messed up?

2008-12-30 Thread Yarko Tymciurak
Massimo - out of curiosoty, did you take some action, either w/ Google or AS22822/LLNW network? On Tue, Dec 30, 2008 at 10:11 AM, mr.freeze wrote: > > http://mdp.cti.depaul.edu seems to be the first hit on google again. > That's good. > > On Dec 29, 1:50 pm, "Yarko Tymciurak" wrote: > > some AS

[web2py:14314] Re: response.slash?

2008-12-30 Thread Yarko Tymciurak
hehehe --- that is suspiciously the only variable reference in the entire source tree to slash; undoubtedly a typo context suggests that was meant to be reponse.flash Massimo? ;-) On Tue, Dec 30, 2008 at 10:33 AM, mr.freeze wrote: > > On line 404 of admin/controllers/default.py there i

[web2py:14315] widgets in SQLTABLE

2008-12-30 Thread mr.freeze
Is it possible to use widgets in a SQLTABLE? Did I mention I love widgets? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com T

[web2py:14316] Re: Many-to-Many widgets

2008-12-30 Thread mdipierro
I will soon release an improved version. Possibly tomorrow. Massimo On Dec 30, 10:48 am, vince wrote: > oh actually i haven't look t2's widget yet. i'll have a look > > i will need to sort out a widget for m2m using multiple select box too > soon. i'll post it here if i come up with anything. >

[web2py:14317] Re: T3 patterns - wishfull thinking

2008-12-30 Thread notabene
That will do! Thank You. On Dec 30, 6:48 pm, "Yarko Tymciurak" wrote: > Have you looked at using mydb.mytable.myfield.default=    pattern? > > You can copy standard fields this way, by selecting a record, saving it in a > row, and using that as the default field.    The default fields can ch

[web2py:14318] Re: central widget repository

2008-12-30 Thread mdipierro
there should be. we could use the wiki for this. Massimo On Dec 30, 11:30 am, "mr.freeze" wrote: > Is there one? If not, should there be one? I love widgets. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py

[web2py:14319] Re: open source organization again

2008-12-30 Thread mdipierro
We will have online tests. If members choose to take online tests, results will be posted. tests will be created by users and approved by users. Massimo On Dec 30, 11:35 am, mmstud wrote: > On 30 joulu, 18:55, dhmorgan wrote: > > > from Charter, goals section: > > > > 2. Certify the knowledge a

[web2py:14320] Re: google messed up?

2008-12-30 Thread mdipierro
no. It just came back. On Dec 30, 11:50 am, "Yarko Tymciurak" wrote: > Massimo - out of curiosoty, did you take some action, either w/ Google or > AS22822/LLNW network? > > On Tue, Dec 30, 2008 at 10:11 AM, mr.freeze wrote: > > >http://mdp.cti.depaul.eduseems to be the first hit on google again

[web2py:14321] Re: response.slash?

2008-12-30 Thread mdipierro
fixed in trunk On Dec 30, 11:55 am, "Yarko Tymciurak" wrote: > hehehe --- that is suspiciously the only variable reference in the entire > source tree to slash; undoubtedly a typo context suggests that was > meant to be reponse.flash > > Massimo? ;-) > > On Tue, Dec 30, 2008 at 10:33 AM

[web2py:14322] Many to Many (sort of)

2008-12-30 Thread mdipierro
New in trunk. Please give this a try: db=SQLDB('sqlite://storage.db') db.define_table('person',SQLField('name')) db.define_table('dog',SQLField('name'),SQLField('person','text')) db.dog.person.requires=IS_IN_DB (db,'person.id','person.name',multiple=True) This is not the same many2many as Django

[web2py:14323] Re: Many to Many (sort of)

2008-12-30 Thread mdipierro
I made an improvement and re-posted it. The references are stored as |1|3|...| i.e. as ids separated by | in a text field. This way it is easy to edit them manually. Invalid references are deleted when the field is edited, ignored otherwise. Values can be searched efficiently with db.table.field.

[web2py:14324] Re: Many to Many (sort of)

2008-12-30 Thread Fran
On Dec 30, 11:37 pm, mdipierro wrote: > New in trunk. Please give this a try: Looking promising :) However fails if I try to use uuid instead of id: db.define_table('owner',SQLField('uuid',length=64,default=uuid.uuid4 ()),SQLField('name')) db.define_table('dog',SQLField('name'),SQLField('owner'

[web2py:14325] Re: Many to Many (sort of)

2008-12-30 Thread Fran
On Dec 30, 11:37 pm, mdipierro wrote: > Thoughts? I'd prefer the UI to be more like t2.tag_widget() in that select should be multi- by default...not having to hold the Ctrl key down. F --~--~-~--~~~---~--~~ You received this message because you are subscribed to

[web2py:14326] Re: Many to Many (sort of)

2008-12-30 Thread mdipierro
1) try svn 602 or launchpad 330. They should work with uuid. 2) IS_NULL_OR(IS_IN_DB(...multiple=True)) is not supposed to work because if multiple=True IS_IN_DB does not poses constraints on how many you select. You may select 0. Hence it would be equivalent to IS_IN_DB(...multiple=True) On Dec

[web2py:14327] Re: Many to Many (sort of)

2008-12-30 Thread Fran
On Dec 30, 11:37 pm, mdipierro wrote: > New in trunk. Please give this a try: No referential integrity. If I delete an owner who was associated with a dog then the reference to the deleted owner stays in the dog.owner field. F --~--~-~--~~~---~--~~ You received t

[web2py:14328] Re: Many to Many (sort of)

2008-12-30 Thread mdipierro
All it takes is build a new widget that look like t2.tag_widget() and acts like gluon.sqlhtml.MultipleOptionsWidget.widget since the logic does not change. Can you help with this? Can you do so that it is CSS neutral (perhaps using checkboxes)? Massimo On Dec 30, 6:44 pm, Fran wrote: > On De

[web2py:14329] Re: Many to Many (sort of)

2008-12-30 Thread mdipierro
No. But but it is done in such a way that does not break anything and it is not visible when you edit the field. The price to pay to make it fast and work on GAE. On Dec 30, 6:47 pm, Fran wrote: > On Dec 30, 11:37 pm, mdipierro wrote: > > > New in trunk. Please give this a try: > > No referenti

[web2py:14330] Re: Many to Many (sort of)

2008-12-30 Thread Fran
On Dec 31, 12:45 am, mdipierro wrote: > 1) try svn 602 or launchpad 330. They should work with uuid. I still get this error: value not in database! The names show up fine but when I submit this error shows up. I have: db.define_table('owner',SQLField('name'),SQLField ('uuid',length=64,default=u

[web2py:14331] Re: Many to Many (sort of)

2008-12-30 Thread Fran
On Dec 30, 11:37 pm, mdipierro wrote: > New in trunk. Please give this a try: Another thing which doesn't work, but would be good to have possible is this kind of thing: db.dog.owner.display=lambda id: (id and [db(db.owner.id==id).select() [0].name] or ["None"])[0] i.e. be able to display the

[web2py:14332] Re: Many to Many (sort of)

2008-12-30 Thread mdipierro
thanks. Think I got them now. Fixed in 604/332. Massimo On Dec 30, 6:51 pm, Fran wrote: > On Dec 31, 12:45 am, mdipierro wrote: > > > 1) try svn 602 or launchpad 330. They should work with uuid. > > I still get this error: > value not in database! > > The names show up fine but when I submit

[web2py:14333] Re: Many to Many (sort of)

2008-12-30 Thread mdipierro
try something like this... db.dog.owner.display=lambda x: ', '.join([db(db.person.uuid=id).select ()[0].name for id in x[1:-1].split('|')]) Massimo On Dec 30, 6:59 pm, Fran wrote: > On Dec 30, 11:37 pm, mdipierro wrote: > > > New in trunk. Please give this a try: > > Another thing which doesn

[web2py:14334] template language patch

2008-12-30 Thread DenesL
Massimo, I sent you a patch proposal to template.py that allows python code to be included in views without the use of pass statements by following a few easy rules. Please have a look and let me know of any comments. --~--~-~--~~~---~--~~ You received this message

[web2py:14335] Re: central widget repository

2008-12-30 Thread mr.freeze
I moved over the AlterEgo article on widgets to get things started and placed it under web2py/Recipes/Widgets on the menu: https://mdp.cti.depaul.edu/web2py_wiki/default/wiki/widgets What is the best way for users to submit their widgets? On Dec 30, 1:27 pm, mdipierro wrote: > there should be.

[web2py:14336] Re: central widget repository

2008-12-30 Thread Baron
That would be great. That wiki link has a certificate problem for me: Secure Connection Failed mdp.cti.depaul.edu uses an invalid security certificate. The certificate is not trusted because it is self signed. The certificate is only valid for Massimo Di Pierro On Dec 31, 2:33 pm, "mr.freez

[web2py:14337] Re: central widget repository

2008-12-30 Thread Yarko Tymciurak
yeah I think it has that problem for everybody ;-) On Wed, Dec 31, 2008 at 12:02 AM, Baron wrote: > > That would be great. > > That wiki link has a certificate problem for me: > > Secure Connection Failed > > mdp.cti.depaul.edu uses an invalid security certificate. > > The certificate is not