Re: [Zope] Data.fs Recovery

2008-04-15 Thread Martijn Jacobs
Godwin Vaz wrote: Martin, The file size is 2GB. Could that be the problem? Older versions of python (and the one used with zope2.4 is VERY old, probably 2.1) have indeed a filesize limit of 2 Gb so here is your problem. Well, It was about time to migrate to a newer version anyway :) The ldap

Re: [Zope] Data.fs Recovery

2008-04-15 Thread Godwin Vaz
Martin, The file size is 2GB. Could that be the problem? Yes I did stop and remove the index file and start again. Workaround I followed: Installed Zope 2.10.5 on my desktop (Win XP) Dumped the Data.fs into the instance Zope 2.10.5 happily ran through the Data.fs though with a few product miss

Re: [Zope] Problem with DTML and JOINS(ZSQL)

2008-04-15 Thread Peter Bengtsson
Zope is agnostic of whatever SQL you enter. In other words, they compile differently and their errors are completely different. I suggest you do this: 1. Fake the ZSQL to make sure your DTML is correct by changing the SQL to something like this: SELECT 'drug_name_test', 'route_of_admin_test', et

Re: [Zope] Problem with DTML and JOINS(ZSQL)

2008-04-15 Thread Jaroslav Lukesh
Did you try the Test tab at ZSQL method management page? If it does not work, you will get error from SQL server. If it works and you does not get any data, then your query is not fit to any data. - Original Message - From: member madhangc To: zope@zope.org Sent: Tuesday, April 15, 20

[Zope] Problem with DTML and JOINS(ZSQL)

2008-04-15 Thread member madhangc
Dear all, I am developing a web application for a biological research institute down here in india. I have some problem in using JOINS. The below is the queries i used, *SQL query **File name : drug* select drug_name,dtype from bio_info_schema.drug order by dtype *File name:drug_gene_details* No

Re: [Zope] type checking

2008-04-15 Thread Chris Withers
Jaroslav Lukesh wrote: Variable is integer Variable is not integer Variable is not number Argggh! My eyes! They bleed! Please dear god just use a python script or external method... Chris -- Simplistix - Content Management, Zope & Python Consulting - http://www.

Re: [Zope] try clause in external method

2008-04-15 Thread Chris Withers
Jonathan wrote: A couple of things... 1) Have bare try/except clauses may cause you grief ;-)19 Specifically, in this case, I'll bet an "unexpected exception" is being raised and swallowed... 2) When an error is trapped by the 'try' statement the transaction is not committed (ie. nothing

Re: [Zope] Data.fs Recovery

2008-04-15 Thread Martijn Jacobs
What is the file size of the Data.fs file? Did you try stopping zope, removing the Data.fs.index file and starting it again? Apologies if this is not the right forum I have a corrupt Data.fs file and would appreciate some help recovering data. Zope 2.4 (still in the Stone Age) OS: Windows 20