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 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. >> > > What do you mean by "did not work"? Did you get an error, or it just > didn't return the results you expected? Note, searches are also case > sensitive, so your query would have to match the exact beginning of a > field's value, including the case. > > If you use ._select instead of .select, instead of running the query, > web2py will give you the GQL code that it generates for the query. Maybe > inspect that to see if it as expected. You could play around with it and > submit it via db.executesql() to see if you can come up with a working > query. > > Anthony > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
