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 )
