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 ____________________________________________________________________________________ Bored stiff? Loosen up... Download and play hundreds of games for free on Yahoo! Games. http://games.yahoo.com/games/front