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
_______________________________________________
Zope-Dev maillist  -  Zope-Dev@zope.org
http://mail.zope.org/mailman/listinfo/zope-dev
**  No cross posts or HTML encoding!  **
(Related lists - 
 http://mail.zope.org/mailman/listinfo/zope-announce
 http://mail.zope.org/mailman/listinfo/zope )

Reply via email to