[web2py] Re: PROBLEM WITH .CONTAINS() ON GAE

2016-06-24 Thread Anthony
You might also consider Google Cloud SQL, which the DAL also supports. Anthony On Friday, June 24, 2016 at 8:49:47 AM UTC-4, Anthony wrote: > > On Thursday, June 23, 2016 at 11:53:35 PM UTC-4, PRACHI VAKHARIA wrote: >> >> >> >> >> Thank you, Anthony. The Google Search API is a little too difficul

[web2py] Re: PROBLEM WITH .CONTAINS() ON GAE

2016-06-24 Thread Anthony
On Thursday, June 23, 2016 at 11:53:35 PM UTC-4, PRACHI VAKHARIA wrote: > > > > > Thank you, Anthony. The Google Search API is a little too difficult for me > to master, and also is billed. > I tried your other suggestion for simulating the .startswith query, but it > did not work in my case, eit

[web2py] Re: PROBLEM WITH .CONTAINS() ON GAE

2016-06-23 Thread PRACHI VAKHARIA
Thank you, Anthony. The Google Search API is a little too difficult for me to master, and also is billed. I tried your other suggestion for simulating the .startswith query, but it did not work in my case, either. *MODIFIED CONTROLLER FUNCTION* *def HomeList():* *if request.args(0):* *

[web2py] Re: PROBLEM WITH .CONTAINS() ON GAE

2016-06-23 Thread Anthony
No, I was not recommending changing the field type to list:string -- that isn't the appropriate field type for your data. I was just mentioning that .contains only works on list fields, and in that case, it is looking for complete word matches within the list. The bottom line is that you cannot

[web2py] Re: PROBLEM WITH .CONTAINS() ON GAE

2016-06-23 Thread PRACHI VAKHARIA
NEW MODIFIED CODE — STILL DOES NOT FUNCTION The following function does not work on GAE – the lines in Red. *MODEL* *htmlDB.define_table('Articles',* *Field('Title'),* *Field('HtmlBody', 'text', label="Enter Full Article"),* *Field('Abstract', 'text', label="Enter Abstract"),* *

[web2py] Re: PROBLEM WITH .CONTAINS() ON GAE

2016-06-23 Thread PRACHI VAKHARIA
*Thank you, Anthony and Massimo!* *What if I do not want Lists, but only a simple text field? There will be only one string field which is the name of a person (Author).How will using list: be different from the simple text field?And does .contains() work at all on GAE?* I am still a begin

[web2py] Re: PROBLEM WITH .CONTAINS() ON GAE

2016-06-23 Thread Massimo Di Pierro
I can confirm it does not. On Wednesday, 22 June 2016 07:25:27 UTC-5, Anthony wrote: > > I don't think the GAE datastore supports text search (you can use > .contains on a list:-type field, though). > > Anthony > > On Wednesday, June 22, 2016 at 3:51:44 AM UTC-4, PRACHI VAKHARIA wrote: >> >> >>

[web2py] Re: PROBLEM WITH .CONTAINS() ON GAE

2016-06-22 Thread Anthony
I don't think the GAE datastore supports text search (you can use .contains on a list:-type field, though). Anthony On Wednesday, June 22, 2016 at 3:51:44 AM UTC-4, PRACHI VAKHARIA wrote: > > > > > > *PROBLEM WITH .CONTAINS() ON GAE* > > The following function does not work on GAE – the line in