Ok, works ;) On Tue, 18 Nov 2008 12:50:29 -0800 (PST) mdipierro <[EMAIL PROTECTED]> wrote:
> > Now I get it! Yes, this is a bug introduced in 1.47. Fixed in trunk > now. > > Massimo > > On Nov 18, 2:26 pm, pigmej <[EMAIL PROTECTED]> wrote: > > Hmmm > > > > I can select them, update etc. But in update form always "None" is > > selected ( first record ). > > > > The same thing in web2py-admin. Records has correct values but in > > update form there is nothing selected in this field. > > > > I have now the same problem with todo table... > > > > I'm sure that it works about 7 days ago ( or less ), but now it > > doesn't work... > > > > Latest ver from svn ( commit #483 ) > > > > On Nov 18, 8:51 pm, mdipierro <[EMAIL PROTECTED]> wrote: > > > > > what does this: > > > > > I see dropdowns too, but any value of this one ( with category, > > > defined db.docs_pages_ver.category.requires) is selected... > > > > > mean? > > > > > On Nov 18, 11:44 am, pigmej <[EMAIL PROTECTED]> wrote: > > > > > > Hmmm > > > > > > I see dropdowns too, but any value of this one ( with category, > > > > defined db.docs_pages_ver.category.requires) is selected... > > > > > > I do not need the second relation... > > > > > > On Nov 18, 5:00 pm, mdipierro <[EMAIL PROTECTED]> wrote: > > > > > > > db.docs_pages_ver.category.requires=IS_NULL_OR(IS_IN_DB > > > > > (db,'docs_categories.id','docs_categories.name',error_message="...")) > > > > > > > works for me and I see the dropdown categories. > > > > > there is no > > > > > > > db.docs_pages.category.requires=IS_NULL_OR(IS_IN_DB > > > > > (db,'docs_categories.id','docs_categories.name',error_message="...")) > > > > > > > could this be your problem? > > > > > > > Massimo > > > > > > > On Nov 18, 9:55 am, pigmej <[EMAIL PROTECTED]> wrote: > > > > > > > > Massimo, have you got my message ? > > > > > > > > On Nov 18, 2:58 pm, mdipierro <[EMAIL PROTECTED]> > > > > > > wrote: > > > > > > > > > If you want you can send me the entire code privately. > > > > > > > > > Massimo > > > > > > > > > On Nov 18, 3:46 am, pigmej <[EMAIL PROTECTED]> wrote: > > > > > > > > > > Massimo, > > > > > > > > > > That's part of my model, all tables are difined. And > > > > > > > > works everything except this one relation. > > > > > > > > > > No idea why it does not work. > > > > > > > > > > On Nov 18, 5:01 am, mdipierro <[EMAIL PROTECTED]> > > > > > > > > wrote: > > > > > > > > > > > I rearranged the order of you code and removed those > > > > > > > > > cols referencing tables that are not defined. The > > > > > > > > > following code works: > > > > > > > > > > > import datetime > > > > > > > > > now=datetime.datetime.today() > > > > > > > > > > > db=SQLDB('sqlite://storage.db') > > > > > > > > > > > db.define_table('docs_categories', > > > > > > > > > SQLField('name','string',length=150), > > > > > > > > > SQLField('url','string',length=60), > > > > > > > > > SQLField('descr','text'), > > > > > > > > > SQLField('short','string',length=150), > > > > > > > > > SQLField('created','datetime',default=now), > > > > > > > > > ) > > > > > > > > > > > db.define_table('docs_pages_ver', > > > > > > > > > SQLField('content','text'), > > > > > > > > > SQLField('created','datetime',default=now), > > > > > > > > > SQLField('order_in','integer', > > > > > > > > > default=1), SQLField('category',db.docs_categories), > > > > > > > > > SQLField('svn','integer'), > > > > > > > > > SQLField('descr','text') > > > > > > > > > ) > > > > > > > > > > > #docs_pages_ver > > > > > > > > > db.docs_pages_ver.category.requires=IS_NULL_OR(IS_IN_DB > > > > > > > > > (db,'docs_categories.id','docs_categories.name',error_message="Błąd > > > > > > > > > synchronizacji")) > > > > > > > > > db.docs_pages_ver.content.requires=IS_NOT_EMPTY(error_message="Należy > > > > > > > > > wypełnić") > > > > > > > > > db.docs_pages_ver.created.requires=IS_DATETIME(error_message="To > > > > > > > > > musi być data") > > > > > > > > > db.docs_pages_ver.order_in.requires=IS_NULL_OR(IS_INT_IN_RANGE > > > > > > > > > (1,99,error_message="Musi być liczbą między 1 a 99")) > > > > > > > > > db.docs_pages_ver.svn.requires=IS_NULL_OR(IS_INT_IN_RANGE > > > > > > > > > (1,10000,error_message="To musi być liczba")) > > > > > > > > > > > #docs_categories > > > > > > > > > db.docs_categories.name.requires=IS_NOT_IN_DB > > > > > > > > > (db,'docs_categories.name',error_message="Taka > > > > > > > > > wartość już istnieje w bazie") > > > > > > > > > db.docs_categories.url.requires=IS_NOT_IN_DB > > > > > > > > > (db,'docs_categories.url',error_message="Taka wartość > > > > > > > > > już istnieje w bazie") > > > > > > > > > db.docs_categories.descr.requires=IS_NOT_EMPTY(error_message="Należy > > > > > > > > > wypełnić") > > > > > > > > > db.docs_categories.short.requires=IS_NOT_EMPTY(error_message="Należy > > > > > > > > > wypełnić") > > > > > > > > > db.docs_categories.created.requires=IS_DATETIME(error_message="To > > > > > > > > > musi być data") > > > > > > > > > > > On Nov 17, 8:40 pm, mdipierro > > > > > > > > > <[EMAIL PROTECTED]> wrote: > > > > > > > > > > > > I will give this a try later tonight. > > > > > > > > > > > > Massimo > > > > > > > > > > > > On Nov 17, 5:59 pm, pigmej <[EMAIL PROTECTED]> wrote: > > > > > > > > > > > > > Yarko it's after :) > > > > > > > > > > > > > I copied parts from it and paste there. So thats > > > > > > > > > > > not that problem ;) > > > > > > > > > > > > > On Nov 18, 12:55 am, "Yarko Tymciurak" > > > > > > > > > > > <[EMAIL PROTECTED]> wrote: > > > > > > > > > > > > > > OH! > > > > > > > > > > > > You need to realize one thing: web2py > > > > > > > > > > > > EXECUTES your models - > > > > > > > > > > > > > > db.docs_categories.name.requires.... > > > > > > > > > > > > > > must appear AFTER the db.define_table which > > > > > > > > > > > > defines docs_categories.... > > > > > > > > > > > > > > Try to arrange your code to account for this - > > > > > > > > > > > > then see what you get. > > > > > > > > > > > > > > On Mon, Nov 17, 2008 at 5:39 PM, pigmej > > > > > > > > > > > > <[EMAIL PROTECTED]> wrote: > > > > > > > > > > > > > > > so.... > > > > > > > > > > > > > > > Any single error. Just nothing select in > > > > > > > > > > > > > Category dropdown if I generate > > > > > > > > > > > > > SQLFORM(db.docs_pages_ver,values,showid = > > > > > > > > > > > > > False). All other dropdown's are selected > > > > > > > > > > > > > ( author and parrent ) but not this one.... > > > > > > > > > > > > > > > Part of model (it's enough?): > > > > > > > > > > > > >http://wklej.to/bpL170 > > > > > > > > > > > > > > > On Nov 18, 12:28 am, mdipierro > > > > > > > > > > > > > <[EMAIL PROTECTED]> wrote: > > > > > > > > > > > > > > what error do you get? can I see the model? > > > > > > > > > > > > > > > > On Nov 17, 4:00 pm, pigmej > > > > > > > > > > > > > > <[EMAIL PROTECTED]> wrote: > > > > > > > > > > > > > > > > > Did not works. > > > > > > > > > > > > > > > > > On Nov 17, 10:26 pm, mdipierro > > > > > > > > > > > > > > > <[EMAIL PROTECTED]> wrote: > > > > > > > > > > > > > > > > > > Do not know whitout lookig at models > > > > > > > > > > > > > > > > but try replace > > > > > > > > > > > > > > > > > > db.docs_pages_ver.category.requires=IS_NULL_OR(IS_IN_DB > > > > > > > > > > > > > > > > (db,'docs_categories.id','docs_categories.name > > > > > > > > > > > > > ',error_message="...")) > > > > > > > > > > > > > > > > > > with > > > > > > > > > > > > > > > > > > db.docs_pages_ver.category.requires=IS_NULL_OR(IS_IN_DB > > > > > > > > > > > > > > > > (db,'docs_categories.id','%(id)s',error_message="...")) > > > > > > > > > > > > > > > > > > then try replace %(id)s with %(name)s > > > > > > > > > > > > > > > > > > On Nov 17, 3:14 pm, pigmej > > > > > > > > > > > > > > > > <[EMAIL PROTECTED]> wrote: > > > > > > > > > > > > > > > > > > > Controler: > > > > > > > > > > > > > > > > > > > def test(): > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > values=db(db.docs_pages_ver.id==47).select()[0] > > > > > > > > > > > > > > > > > return > > > > > > > > > > > > > > > > > SQLFORM(db.docs_pages_ver,values,showid > > > > > > > > > > > > > > > > > = False) > > > > > > > > > > > > > > > > > > > model: > > > > > > > > > > > > > > > > > db.docs_pages_ver.category.requires=IS_NULL_OR(IS_IN_DB > > > > > > > > > > > > > > > > > (db,'docs_categories.id','docs_categories.name > > > > > > > > > > > > > ',error_message="...")) > > > > > > > > > > > > > > > > > db.docs_pages_ver.author.requires=IS_IN_DB > > > > > > > > > > > > > > > > > (db,'users.id','users.nick',error_message="...") > > > > > > > > > > > > > > > > > db.docs_pages_ver.parrent.requires=IS_NULL_OR(IS_IN_DB > > > > > > > > > > > > > > > > > (db,'docs_pages.id','docs_pages.title',error_message="...")) > > > > > > > > > > > > > > > > > ... > > > > > > > > > > > > > > > > > > > And in output everything is ok except > > > > > > > > > > > > > > > > > category field. All fields > > > > > > > > > > > > > are > > > > > > > > > > > > > > > > > selected correctly, except this one. > > > > > > > > > > > > > > > > > In category field there is nothing > > > > > > > > > > > > > > > > > selected. There are the same > > > > > > > > > > > > > kind > > > > > > > > > > > > > > > > > of relations etc. > > > > > > > > > > > > > > > > > > > I have no idea what's wrong > > > > > > > > > > > > > > > > > > > Btw. > > > > > > > > > > > > > > > > > > > return values.category returns an > > > > > > > > > > > > > > > > > correct integer ( it exists in > > > > > > > > > > > > > > > > > db.category.id ) > > > > > > > > > > > > > > > > > > > Any ideas ? > > -- Pozdrawiam, Jędrzej Nowak --~--~---------~--~----~------------~-------~--~----~ 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 from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---