Thanks Massimo, now working right!
On Sep 1, 10:58 am, mdipierro <mdipie...@cs.depaul.edu> wrote: > Interesting the bug is because of an off feature of GAE (at least on > localhost). If two fields are type StringListProperty they must be two > different instances of the StringListProperty class else the two > fields are just alias of each other. I did not see this documented > anywhere. > > Massimo > > On Sep 1, 6:24 am, "Martin.Mulone" <mulone.mar...@gmail.com> wrote: > > > > > ********************* > > /models/db.py > > ****************** > > > db.define_table('posts', > > db.Field('id', 'id'), > > db.Field('keywords', 'list:string'), #tags > > db.Field('fulltext', 'list:string'), migrate=True) > > > posts=db(db.posts.id>0).select() > > if not posts: > > > db.posts.insert(keywords=['key1','key2','key3'],fulltext=['full1','full2',' > > full3']) > > > db.posts.insert(keywords=['key10','key20','key30'],fulltext=['full10','full > > 20','full30']) > > > ************************** > > /controllers/default.py > > ************************** > > > def index(): > > response.flash = T('Welcome to web2py') > > > keywords=[] > > fulltext=[] > > posts = db(db.posts.id == 1).select() > > if posts: > > post = posts[0] > > keywords = post.keywords > > fulltext = post.fulltext > > > return dict(message=T('Hello > > World'),keywords=keywords,fulltext=fulltext) > > > **************************** > > /views/default/index.html > > ***************************** > > > {{extend 'layout.html'}} > > > {{if 'message' in globals():}}{{=H2(message)}}{{else:}} > > {{=BEAUTIFY(response._vars)}}{{pass}} > > > <hr /> > > <h1>List Problem</h1> > > <p>The problem is only on gae... correct: full1,full2,full3 .... > > key1,key2,key3</p> > > > {{=BEAUTIFY(response._vars)}} > > > ************************************************************* > > > And show this: > > > In local sqlite:http://yfrog.com/0tcorrectsqlitep > > > But in local-gae:http://yfrog.com/j3problemgaep > > > On Sep 1, 7:16 am, "Martin.Mulone" <mulone.mar...@gmail.com> wrote: > > > > This is a writing mistake, Massimo please take a look to the > > > application, i make it with keywords = ['keywords1','keywords2'] and > > > the problem still there. > > > > On 1 sep, 00:21, mdipierro <mdipie...@cs.depaul.edu> wrote: > > > > > there is an error right here: > > > > > post.update_record(keywords = 'keywords1 keywords2') > > > > > should be > > > > > post.update_record(keywords = ['keywords1','keywords2']) > > > > > On Aug 31, 9:45 am, "Martin.Mulone" <mulone.mar...@gmail.com> wrote: > > > > > > I don't get the logic of this problem. This problem only ocurrs in > > > > > GAE, local works fine. > > > > > > I'am using the new introduce features list:string > > > > > > My db definition is similar to this (only the necesary): > > > > > > db.define_table('posts', > > > > > db.Field('id', 'id'), > > > > > db.Field('keywords', 'list:string'), #tags > > > > > db.Field('fulltext', 'list:string'), migrate=true) > > > > > > When i changed the content with this (before i insert the record with > > > > > no problem): > > > > > > posts = db(db.posts.id == id).select() > > > > > if posts: > > > > > post = posts[0] > > > > > post.update_record(keywords = 'keywords1 keywords2') > > > > > > I list the db and all is fine. > > > > > > Then I modified the same record with this > > > > > > posts = db(db.posts.id == id).select() > > > > > if posts: > > > > > post = posts[0] > > > > > post.update_record(fulltext = 'fulltext1 fulltext2') > > > > > > I list the db and I have: > > > > > > ------------> keywords = 'fulltext1 fulltext2' > > > > > > I am really stuck with this problem.