On Sunday 10 February 2008 11:13:06 am Adrian Klaver wrote:
> Is there a way to do the equivalent of an Access pass through query?
> The reason I ask is I tried the following:
> pl_ds.execute("select * from dataset where common ilike 'agast%'")
> and got this error message:
> OperationalError: near "ilike": syntax error
> ilike is valid syntax for Postgres. I also get the same error for distinct
> on(). I realize it would be a nightmare to accommodate all the SQL dialects
> in the parser, so is possible to bypass the Dabo parser on a case by case
> basis?
>
> --
> Adrian Klaver
> [EMAIL PROTECTED]How about using select * from dataset where lower(common) like 'agast%' BTW is 'dataset' part of pl_ds (a Dabo DataSet) or a generic name of a table? I ask because I'm sure Dabo does not support 'ilike' in a select statement on a Dabo dataset. -- John Fabiani _______________________________________________ Post Messages to: Dabo-users@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users Searchable Archives: http://leafe.com/archives/search/dabo-users This message: http://leafe.com/archives/byMID/dabo-users/[EMAIL PROTECTED]
