[web2py] Re: Resetting the database

2011-11-14 Thread Archibald Linx
> > -- > Vinicius Assef. > > On Mon, Nov 14, 2011 at 10:56 AM, Archibald Linx > > > > > > > > wrote: > > Thank you Bruno. > > > I am using SQLite. > > > I want to reset all the tables of my project. > > > Thanks, > >

[web2py] Re: Resetting the database

2011-11-14 Thread Archibald Linx
Thank you Bruno. I am using SQLite. I want to reset all the tables of my project. Thanks, Archibald On 14 nov, 01:44, Bruno Rocha wrote: > which database engine? > > http://zerp.ly/rochacbruno > Em 13/11/2011 22:38, "Archibald Linx" escreveu: > > > > >

[web2py] Resetting the database

2011-11-13 Thread Archibald Linx
Dear Web2py users, How can I reset the database of my Web2py project ? Thanks, Archibald

[web2py] Re: Validators, when are they necessary ?

2011-11-03 Thread Archibald Linx
Thank you Anthony. Your answers are always very clear. Archibald On 2 nov, 22:15, Anthony wrote: > On Wednesday, November 2, 2011 4:46:45 PM UTC-4, Archibald Linx wrote: > > > Dear Web2py users, > > > I have a few questions about validators, especially : when are they >

[web2py] Validators, when are they necessary ?

2011-11-02 Thread Archibald Linx
Dear Web2py users, I have a few questions about validators, especially : when are they necessary ? For example, if I have like in chapter 3 ( http://www.web2py.com/book/default/chapter/03?search=image_id ) : db.define_table('comment', Field('image_id', db.image)) Is "db.comment.image_id.requ

[web2py] Re: list of usernames

2011-11-02 Thread Archibald Linx
ld On 2 nov, 03:39, Anthony wrote: > On Tuesday, November 1, 2011 7:15:32 PM UTC-4, Archibald Linx wrote: > > > @auth.requires_login() > > def write_message(): > >     form = SQLFORM(db.message) > >     if form.process().accepted: > >         response.flash = 'G

[web2py] Re: list of usernames

2011-11-01 Thread Archibald Linx
eone" field is not. The "tosomeone" field remains empty. So the problem came from "form.process().accepted", without me noticing it at first. By keeping "if form.accepts(request.vars, session):", I solved my problem. Archibald On 29 oct, 13:20, Archibald Linx wrote: &

[web2py] Re: list of usernames

2011-10-29 Thread Archibald Linx
But now I am using "SQLFORM.factory", not exclusively "SQLFORM". Could the problem lie there ? Thanks for your help, Archibald On 28 oct, 19:18, Archibald Linx wrote: > Thank you Anthony, I have given it a thought and I will create another > table called "status"

[web2py] Re: list of usernames

2011-10-28 Thread Archibald Linx
so be able to create either a computed or > virtual field that concatenates name and status into a new list, and query > that. Depending on how many records you're dealing with, though, it might > be more efficient to go with a more normalized data structure. > > Anthony > > &

[web2py] Re: New questions about the book

2011-10-28 Thread Archibald Linx
Thank you very much Anthony. I have read Chapter 7 up to the "Hidden Fields" section and it is already more clear in my head. Archibald On 28 oct, 02:12, Anthony wrote: > On Thursday, October 27, 2011 7:57:31 PM UTC-4, Archibald Linx wrote: > > > 1) Sometimes I see in

[web2py] New questions about the book

2011-10-27 Thread Archibald Linx
Dear Web2py users, I have started playing around with Web2py. I am reading various parts of the book. I am very satisfied with the framework and I find the atmosphere of this mailing list very friendly. Thanks. I have some more questions about the book. 1) Sometimes I see in the documentation "i

[web2py] Re: list of usernames

2011-10-26 Thread Archibald Linx
r the help you gave me, Archibald On 26 oct, 20:35, Archibald Linx wrote: > Thank you Anthony. > > I don't know about the raw SQL query. I will ask on Stackoverflow and > post the link here. > > Best, > Archibald > > On 26 oct, 19:07, Anthony wrote: > > >

[web2py] Re: list of usernames

2011-10-26 Thread Archibald Linx
Thank you Anthony. I don't know about the raw SQL query. I will ask on Stackoverflow and post the link here. Best, Archibald On 26 oct, 19:07, Anthony wrote: > On Wednesday, October 26, 2011 12:21:33 PM UTC-4, Archibald Linx wrote: > > > Thank you Anthony ! > > >

[web2py] Re: book 3.2ed

2011-10-26 Thread Archibald Linx
Great :) Archibald On 26 oct, 19:02, Anthony wrote: > > In this post : > > >https://groups.google.com/group/web2py/browse_thread/thread/b81158ca4... > > it was noted that the possibility of the option "multiple=(0,9)" for > > the IS_IN_DB validator of "list:reference tag" was undocumented. > > I

[web2py] Re: book 3.2ed

2011-10-26 Thread Archibald Linx
Great work ! In this post : https://groups.google.com/group/web2py/browse_thread/thread/b81158ca46496caa/e7da3bbaefa03c90?hl=fr&lnk=gst&q=list+of+usernames#e7da3bbaefa03c90 it was noted that the possibility of the option "multiple=(0,9)" for the IS_IN_DB validator of "list:reference tag" was undoc

[web2py] Re: list of usernames

2011-10-26 Thread Archibald Linx
ing the length of request.vars.to. It > would only be an issue if the validation of request.vars.to could result in > it passing validation but its length changing as a result of that. > > Anthony > > > > > > > > On Wednesday, October 26, 2011 6:39:29 AM UTC-4,

[web2py] Re: list of usernames

2011-10-26 Thread Archibald Linx
re insert. Like this I am sure "forms.vars.to" does not contain anything fishy or dangerous. Thanks, Archibald On 25 oct, 18:30, Anthony wrote: > On Tuesday, October 25, 2011 11:45:41 AM UTC-4, Archibald Linx wrote: > > > Thank you Anthony. > > > All this works very nice

[web2py] Re: list of usernames

2011-10-25 Thread Archibald Linx
list:integer')) I want "status" to be a list of 0 as long as "to", but "db.message.status.default = [0]*len(db.message.to.default)" does not work. Do you have any suggestion ? Thanks, Archibald On 25 oct, 17:04, Anthony wrote: > On Tuesday, October 25,

[web2py] Re: list of usernames

2011-10-25 Thread Archibald Linx
4:16 AM UTC-4, Archibald Linx wrote: > > > It works great ! > > > Because a "list:reference" field gets a default constraint, I > > deleted : > > "IS_IN_SET(['Apples','Oranges','Bananas','Kiwis','Lemons'],multiple

[web2py] Re: list of usernames

2011-10-25 Thread Archibald Linx
t:reference" field ? I don't want more than 8 people for example. Thanks a lot, Archibald On 25 oct, 02:23, Archibald Linx wrote: > The documentation recommands the multiple select plug-in. > > http://www.web2pyslices.com/slices/take_slice/70 > > Sorry, > Archibald

[web2py] Re: list of usernames

2011-10-24 Thread Archibald Linx
The documentation recommands the multiple select plug-in. http://www.web2pyslices.com/slices/take_slice/70 Sorry, Archibald On 25 oct, 01:18, Archibald Linx wrote: > Thank you very much Richard and Anthony ! > > What's the easiest way to use these fields in the controlle

Re: [web2py] list of usernames

2011-10-24 Thread Archibald Linx
nd you maybe want to specified the >> representation of the list:reference field since it is a integer and replace >> it by the name or email of the user... >> >> To do that you need to user .represent() >> >> I let you read futher in the book.. >> >>

[web2py] list of usernames

2011-10-24 Thread Archibald Linx
Dear Web2py users, Do you sometimes use fields which are lists of usernames ? How would you write that : Field('usernames','list:reference db.auth_user.username')) ? Thanks a lot, Archibald

[web2py] Re: Web2py book

2011-10-24 Thread Archibald Linx
Dear Anthony, Thank you very much for this very clear answer. Archibald On 24 oct, 16:02, Anthony wrote: > On Monday, October 24, 2011 9:33:33 AM UTC-4, Archibald Linx wrote: > > > Dear web2py users, > > > I have some questions about the book : > > > 1)

[web2py] Web2py book

2011-10-24 Thread Archibald Linx
Dear web2py users, I have some questions about the book : 1) There is a typo here : http://www.web2py.com/book/default/chapter/10#Auto-completion It should be "if not request.vars.month:" and not "it not request.vars.month:" 2) On page 69, what do you mean by "private" ? " Class atributes, meth