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: [email protected]
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]
