[Zope] Problem for extracting long text with zsql method?

b.nguyen@chime.ucl.ac.uk b.nguyen@chime.ucl.ac.uk
Fri, 17 Jan 2003 16:32:09 -0000


Hi,

I am having problem here.

I am running Zope 2.0 in my machine with platform Win XP.   I have succeed=
 in 
connecting Zope to mysql database (which is currently held in another mach=
ine, Unix 
server) by using ZODBCDA-3.1.0b2-win32-py21.

And A testing table called =91news=92 has been created with following fiel=
ds:

+-------------+------------------+------+-----+---------+----------------+
| Field       | Type             | Null | Key | Default | Extra          |
+-------------+------------------+------+-----+---------+----------------+
| NID             | int(10) unsigned |      | PRI | NULL    | auto_increme=
nt |
| Name          | varchar(100)     |      |     |         |               =
 |
| Subject       | varchar(255)     |      |     |         |               =
 |


I then set up a very simple Zsql method as follow :

      select Name, Subject from news

It works fine and will return all correct data only if the Subject value i=
s not long, ie if 
Subject has value 

*   This is just a test. 
It will work

*   This is just a test. This is just a test. This is just a test. This is=
 just a test. This is just a test. 
    This is just a test. This is just a test.
Will return the following error

Error, sql.error: None 


Because the =91news=92 table is just for testing, it is rather small.  It =
only has 5 rows of data 
in total. Hence, I have ruled out the possibility that the returning resul=
t is too big.  But I 
could be wrong.  

It would be great help if someone could give me a direction to solve the a=
bove problem.



Bonnie