On Sunday 10 February 2008 1:12 pm, Adrian Klaver wrote: > > Tried the temp Cursor method. I did not get a syntax error but I also did > not get any data. The sequence of commands was: > > pl_biz=self.getBizobj() > pl_tc=pl_biz.getTempCursor() > pl_tc.execute("select * from plant1 where common ilike 'agast%'"
The above line was actually: pl_tc.execute("select * from plant1 where common ilike 'agast%'") Also select * from plant1 where common ilike 'agast% shows up in the server log. > pl_tc.fetchall() > [] > > The same query from psql returns : > > production=> SELECT * from plant1 where common ilike 'agast%'; > p_item_no | common | genus | species | > variety | plant_type | series | season | ts_insert | > ts_update | user_update | user_insert | color | category_type | > category_sub_type > -----------+---------------------------------+-----------+------------+---- >----- > --------+------------+--------+-----------+---------------------+---------- >----- > ------+-------------+-------------+-------+---------------+---------------- >--- 8 | agastache heather queen | agastache | cana | mint > > | flower | | perennial | 2004-01-01 00:00:00 | 2007-12-20 > > 16:04:02 | postgres | postgres | NULL | plant | normal > 6 | agastache camphor hyssop | agastache | | > camphor > hyssop | herb | | unknown | 2004-01-01 00:00:00 | > 2008-01-30 10:01:20 | aklaver | postgres | NULL | plant | > normal 9 | agastache mosquito plant | agastache | cana | mint > > | herb | | unknown | 2004-01-01 00:00:00 | 2008-01-30 > > 10:01:20 | aklaver | postgres | NULL | plant | normal > 7 | agastache apricot sunrise | agastache | NULL | > apricot > sunrise | herb | | unknown | 2004-01-01 00:00:00 | > 2008-01-30 10:01:20 | aklaver | postgres | NULL | plant | > normal 10 | agastache licorice mint(purple) | agastache | foeniculum | > anise hyssop | herb | t | unknown | 2004-01-01 00:00:00 | > 2008-02-01 19:19:34 | postgres | postgres | NULL | plant | > normal 11 | agastache korean mint | agastache | rugosa | mint > > | herb | | unknown | 2004-01-01 00:00:00 | 2008-02-02 > > 15:14:17 | aklaver | postgres | NULL | plant | normal > 732 | agastache rupestris | agastache | rupestris | > > | herb | | unknown | 2004-01-01 00:00:00 | 2008-02-02 > > 15:14:17 | aklaver | postgres | NULL | plant | normal > (7 rows) -- Adrian Klaver [EMAIL PROTECTED] _______________________________________________ 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]