[Zope-dev] need help to solve zgadfly database issue

[Dear]

Hi Every Body,

CASE 1.

1) I have created one page template which contains one
form  after submit i inserted the form values in to
zgadfly database table as given below Using External
Methods.


connection = gadfly.gadfly(dbName,dbPath)

cursor = connection.cursor()

cursor.execute("insert into tablename(....))

connection.commit()

connection.close()


2) Now to read this information i created .

   i) Z SQL Method
   ii) Z Search Interface. (used page template option)

But when i view the page it is not showing the valuse
which i have recently inserted, i need to restart the
ZOPE server to get these changes reflected. What i
mean
i Z SQL there is statement "select  * from table"

but without zestarting the server it is not pulling
the  valuse inserted in tables.

CASE 2.

now i tried second option to read data from tables.

instead of creating page template, i wrote External
Method, in which i created html page

systax like this

connection = gadfly.gadfly(dbName,dbPath)
cursor = connection.cursor()
cursor.execute("select * from table_name)
rc=cursor.fetchall()
connection.commit()
connection.close()

return rc

if i visit the page, zope is hanging, on status bar it
is showing messahe waiting...........

did any body face this problem , and can help me.



for both operations i am using External Methods.

Thanks in advance

Mukhtar
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.zope.org/pipermail/zope-dev/attachments/20070315/8cc329fa/attachment.htm