[web2py:19928] sum do not work for gqldb

2009-04-16 Thread sharekey
records=db(db.mytable.id>0).select(db.mytable.field1, db.mytable.field2.sum(), groupby=db.mytable.field1) The code work for sqldb, but do not work for gqldb, I get error message " 'SQLField' object has no attribute 'sum' " on GAE. How do I sum a field on GAE? --~--~-~--~~---

[web2py:13929] Re: Select filter on GAE

2008-12-20 Thread sharekey
Is there any solution for this problem? On 12月20日, 下午3时27分, sharekey wrote: > many to many relation select do not work on GAE too. > > I try the dal example code on GAE as below: > tmp=db.define_table('author',SQLField > ('name'),migrate='test_author.

[web2py:13918] Re: Select filter on GAE

2008-12-19 Thread sharekey
) tmp=db.authorship.insert(author_id=aid,paper_id=pid) authored_papers=db((db.author.id==db.authorship.author_id)& (db.paper.id==db.authorship.paper_id)) rows=authored_papers.select(db.author.name,db.paper.title) I also get message "SyntaxError:SQLQuery:right site of filter must

[web2py:13913] Re: Select filter on GAE

2008-12-19 Thread sharekey
Correct the code categorys=db(db.dl_category.id==db.dl_category.parent_id).select() to categorys=db(db.category.id==db.category.parent_id).select() On 12月20日, 下午2时53分, sharekey wrote: > Hi all, > > I defined a table as below: > > db.define_

[web2py:13912] Select filter on GAE

2008-12-19 Thread sharekey
Hi all, I defined a table as below: db.define_table('category', SQLField('parent_id', 'integer'), SQLField('child_id', 'integer'), SQLField('sort_id', 'integer'), SQLField('name'), SQLField('description'))

[web2py:13628] Re: Table with boolean type field can not import from csv file on GAE

2008-12-16 Thread sharekey
Hi Massimo, I have tried the latest trunk, it still do not work, I get the same message "unable to parse csv file". On 12月16日, 下午5时35分, mdipierro wrote: > Can you please try the latest trunk and let me know? > > Massimo > > On Dec 16, 3:21 am, sharekey wrote: &g

[web2py:13624] Re: Table with boolean type field can not import from csv file on GAE

2008-12-16 Thread sharekey
Because I can not use svn at my office. On 12月16日, 下午5时42分, sharekey wrote: > I am sorry I can not try it now, I will do a try later. > > On 12月16日, 下午5时35分, mdipierro wrote: > > > > > Can you please try the latest trunk and let me know? > > > Massimo > >

[web2py:13622] Re: Table with boolean type field can not import from csv file on GAE

2008-12-16 Thread sharekey
I am sorry I can not try it now, I will do a try later. On 12月16日, 下午5时35分, mdipierro wrote: > Can you please try the latest trunk and let me know? > > Massimo > > On Dec 16, 3:21 am, sharekey wrote: > > > > > I am sure boolean values in the CSV are 'T'

[web2py:13617] Re: Table with boolean type field can not import from csv file on GAE

2008-12-16 Thread sharekey
Meanwhile, as a way around it, make sure boolean values in the CSV are > 'T' or 'F'. > > Massimo > > On Dec 16, 2:47 am, sharekey wrote: > > > > > Hi all, > > > I encount a problem that the table with boolean type field can not > > i

[web2py:13612] Table with boolean type field can not import from csv file on GAE

2008-12-16 Thread sharekey
Hi all, I encount a problem that the table with boolean type field can not import from csv file on GAE, any suggest? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this g

[web2py:12448] Re: "No databases in this application" on GAE

2008-11-24 Thread sharekey
ble + '.id>0'" 2) Replace "records=db(query).select (limitby=limitby,orderby=orderby)" with "records=db(eval(query)).select (limitby=limitby,orderby=orderby)" I hope appadmin in next version will work well on GAE! On 11月23日, 下午12时03分, Jonathan Ben

[web2py:12356] Re: "No databases in this application" on GAE

2008-11-21 Thread sharekey
"invalid SQL FILTER" and "no records" message. On 11月21日, 下午10时07分, mdipierro <[EMAIL PROTECTED]> wrote: > That is not necessarily a problem. Do not trust appadmin on GAE. can > you insert and select records? > > On Nov 21, 1:47 am, sharekey <[EMAI

[web2py:12275] Re: "No databases in this application" on GAE

2008-11-20 Thread sharekey
here are no tickets > 3) there are no tables either, until data is stored (that is how GAE > works) > 4) If you do not get a traceback your model is working > using google appserver locally is the same as running on google app > engine. > > Massimo > > On Nov 20, 11:33 pm, s

[web2py:12268] Re: "No databases in this application" on GAE

2008-11-20 Thread sharekey
<[EMAIL PROTECTED]> wrote: > Hi sharekey, > > we should make a distinction: develop for GAE or develop on GAE. > > with the current web2py you can develop for GAE. You develop on your > machine and then you upload your app as explained in various articles > here >

[web2py:12262] Re: "No databases in this application" on GAE

2008-11-20 Thread sharekey
Hi Massimo, Do you have any good idea for develope data-drive application on GAE? On 11月20日, 下午9时59分, mdipierro <[EMAIL PROTECTED]> wrote: > This is *very* dangerous. You are allowing anybody to manipulate your > data on GAE as they please. > > Massimo > > On Nov 20, 6:56 am, Jonathan Benn <[

[web2py:12261] Re: "No databases in this application" on GAE

2008-11-20 Thread sharekey
Hi Jonathan, I try my test follow your steps, but it still doesn't work yet. The browser print "No databases in this application" message as before. howerver, thanks for your help! On 11月20日, 下午8时56分, Jonathan Benn <[EMAIL PROTECTED]> wrote: > I have the same issue with appadmin. Here is my *

[web2py:12196] Re: "No databases in this application" on GAE

2008-11-19 Thread sharekey
d. > > Anyway, if you get to appadmin, then your code below is doing its job. > > Massimo > > On Nov 19, 7:47 pm, sharekey <[EMAIL PROTECTED]> wrote: > > > > > Hi All, > > I get "No databases in this application" when I > > browsehttp:/

[web2py:12192] "No databases in this application" on GAE

2008-11-19 Thread sharekey
de db.define_table('users', SQLField('name', 'string'), SQLField('email', 'string')) How can I make it work on GAE? Thanks for any help! Sharekey --~--~-~--~~~---~--~~ You received this message becaus