K H Subrahmanyan writes:
I am using zope and gadfly for my project. but while using the SQL methods, I get the error if I use the "like" option.
E.g.. select * from table where Emp_name like "*rama*"
I will get the following error. Maybe, you should look at an SQL book or other SQL description...
1. strings are surrounded by '...' not "..." 2. the "match sequence" wildcard is "%" not "*" Dieter
I am using zope in linux. I have added one Image.(size : 56 x 103). Now even if I delete it and add another different picture with the SAME Id, then also, I will get the same (previous) picture, except that the size will be change to the size of the new picture. the problem will be same even if I open that object and upload a new image. what may be the problem. thanks in advance. subrahmayn.
K H Subrahmanyan wrote:
I am using zope in linux.
I have added one Image.(size : 56 x 103).
Now even if I delete it and add another different picture with the SAME Id, then also, I will get the same (previous) picture, except that the size will be change to the size of the new picture.
the problem will be same even if I open that object and upload a new image.
what may be the problem.
thanks in advance. subrahmayn.
Your browser is cacheing the image. Clear your disk and memory caches, then re-load the page. That should do it. If you need to prevent this, one strategy would be to generate a unique ID for your images whenever they change, and take that into account in your DTML. I've been thinking about this but haven't implemented it yet. -- ................. paul winkler .................. slinkP arts: music, sound, illustration, design, etc. web page: http://www.slinkp.com A member of ARMS: http://www.reacharms.com
hi, I would like to export the data in my zope database to excel. I have done the reverse process that is, I have stored the excel file in text format and imported the data into my database and now I want to export back. is there any method. thanks in advance. subrahmayan
Create a CVS file, which if formatted correctly will open fine in Excel. ----- Original Message ----- From: "K H Subrahmanyan" <subrahmanyan.kalathur@wipro.com> To: "Dieter Maurer" <dieter@handshake.de>; <curtis@cardgate.net>; <zope@pri-um.com>; <webmaven@lvcm.com> Cc: <zope@zope.org> Sent: Wednesday, February 14, 2001 11:37 AM Subject: [Zope] [Zope]: export to excel
hi, I would like to export the data in my zope database to excel. I have done the reverse process that is, I have stored the excel file in text format and imported the data into my database and now I want to export back.
is there any method.
thanks in advance. subrahmayan
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
Yep ----- Original Message ----- From: "Jerome Alet" <alet@unice.fr> To: "Phil Harris" <phil.harris@zope.co.uk> Cc: "K H Subrahmanyan" <subrahmanyan.kalathur@wipro.com>; "Dieter Maurer" <dieter@handshake.de>; <curtis@cardgate.net>; <zope@pri-um.com>; <webmaven@lvcm.com>; <zope@zope.org> Sent: Wednesday, February 14, 2001 12:50 PM Subject: Re: [Zope] [Zope]: export to excel
On Wed, 14 Feb 2001, Phil Harris wrote:
Create a CVS file, which if formatted correctly will open fine in Excel.
you probably meant CSV, for Comma Separated Values, instead of CVS for Concurrent Versionning System...
bye,
Jerome Alet
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
participants (5)
-
Dieter Maurer -
Jerome Alet -
K H Subrahmanyan -
Paul Winkler -
Phil Harris