Re: [Zope-dev] More ZCatalog Stuff.
Steve Alexander [[EMAIL PROTECTED]] wrote: Christopher Petrilli wrote: SMOC :-) You're in the South Michigan Orienteering Club? http://www.angelfire.com/mi/SMOC/ Oh sorry, old reference... SMOC = Simple Matter of Code :) Chris -- | Christopher Petrilli | [EMAIL PROTECTED] ___ Zope-Dev maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope )
Re: [Zope-dev] 2.3.0. Unindex_object Tried To Unindex Nonexistent
Steve is right, though I fixed that problem when it snuck up on me, but apparantly it never got merged into the branches correctly. Don't we all love CVS? I personally had a problem with using 'i' as anything but a iterator variable. Chris -- | Christopher Petrilli | [EMAIL PROTECTED] - Original Message - From: "Steve Alexander" [EMAIL PROTECTED] To: "Andy Dawkins" [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; "Christopher Petrilli" [EMAIL PROTECTED] Sent: Monday, January 29, 2001 7:19 AM Subject: Re: [Zope-dev] 2.3.0. Unindex_object Tried To Unindex Nonexistent Andy Dawkins wrote: I'm having some more problems with the ZCatalog in Zope 2.3.0 I've got a name error in the file UnTextIndex.py Error Type: NameError Error Value: i I believe this is occuring when the catalog tries to unindex an object that isn't currently indexed. The traceback reports line 332: File /usr/zope/zope-2_3_0/lib/python/SearchIndex/UnTextIndex.py, line 332, in removeForwardEntry The line in question reads: LOG('UnTextIndex', ERROR, 'Unindex_objects tried to unindex nonexistent' ' document %s' % str(i)) The function never uses or declares i, however it does use documentId. I think perhaps the i should have been documentId but I thought i would check with you guys first. What do you think? You're right. In an earlier version in CVS, all the variables called "documentId" were called "i". I guess this one just missed the search-replace :-) Of course, documentId makes for much more readable code; although "i" is faster to type :) Change it to documentId and you'll be fine. -- Steve Alexander Software Engineer Cat-Box limited http://www.cat-box.net ___ Zope-Dev maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope )
Re: [Zope-dev] ZCatalog FieldIndex bug in Zope 2.3.0b3
On 1/26/01 11:41 AM, "Chris McDonough" [EMAIL PROTECTED] wrote: I've put the fieldindex bug in the collector. This is now fixed... It was a bizarre logic problem, but I could reproduce it easily :-) Thanks for finding this. Chris -- | Christopher Petrilli | [EMAIL PROTECTED] ___ Zope-Dev maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope )
Re: [Zope-dev] Import/Export in 2.3beta2
The reason it's gone is that it's not really a "view" of hte folder, but an action. It is, however, a bug that the button doesn't show up if the folder is empty. I'm quite sure Brian will fix this ASAP. Chris -- | Christopher Petrilli | [EMAIL PROTECTED] - Original Message - From: "Andy McKay" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, January 19, 2001 6:42 PM Subject: [Zope-dev] Import/Export in 2.3beta2 Is this a stupid question, or why cant i Import/Export into a folder in 2.3 b2 (Windows), there seems to be no tab... -- Andy McKay. ___ Zope-Dev maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope ) ___ Zope-Dev maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope )
Re: [Zope-dev] ZCatalog doesnt find Items
There could be problems depending on how a product handles dealing with attributes, but the exception should be caught. Note that the traceback is *not* in Catalog, but is in the Transaction manager. Can you talk about what other products you have installed? And hwat your object database looks like? Chris -- | Christopher Petrilli | [EMAIL PROTECTED] - Original Message - From: "Andre Schubert" [EMAIL PROTECTED] To: "Zope Development Maillist" [EMAIL PROTECTED] Sent: Friday, January 19, 2001 5:30 AM Subject: [Zope-dev] ZCatalog doesnt find Items Hi all, I have a problem with my ZCatalog object. If i have a Folder named Test and inside i create a ZCatalog object and some DTML-Objects/Methods the ZCatalog finds all Items. But when i install the ZCatalog in the root folder and start find Items a got the following error: Traceback (innermost last): File /usr/share/zope_2.2/Zope-2.2.0-src/lib/python/ZPublisher/Publish.py, line 222, in publish_module File /usr/share/zope_2.2/Zope-2.2.0-src/lib/python/ZPublisher/Publish.py, line 187, in publish File /usr/share/zope_2.2/Zope-2.2.0-src/lib/python/Zope/__init__.py, line 221, in zpublisher_exception_hook (Object: Traversable) File /usr/share/zope_2.2/Zope-2.2.0-src/lib/python/ZPublisher/Publish.py, line 175, in publish File /usr/share/zope_2.2/Zope-2.2.0-src/lib/python/Zope/__init__.py, line 235, in commit File /usr/share/zope_2.2/Zope-2.2.0-src/lib/python/ZODB/Transaction.py, line 290, in commit AttributeError: (see above) Are there some known conflicts with other Products?? I use Zope 2.2.2 and python 1.5.2 on Linux(i386) Who can help me as ___ Zope-Dev maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope ) ___ Zope-Dev maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope )
Re: [Zope-dev] Z Search Interface/ZCatalog bugs
Casey, Thanks for these... the first one is a new one to me, and I'll look at it (please still submit it so we can track it). The second is patched in a branch that will be merged before the release of b1. Chris - Original Message - From: "Casey Duncan" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, January 15, 2001 10:46 AM Subject: [Zope-dev] Z Search Interface/ZCatalog bugs There is a bug in 2.3.0a2 that prevents you from adding a Z Search Interface. It is basically a pathing issue to a dtml file that moved. The following is a patch for Aqueduct.py to temper this issue: 102c102 dtml_dir=Globals.package_home(globals()) --- dtml_dir=os.path.join(Globals.package_home(globals()),'dtml') There is also a bug in the Z Search Interface implementation of ZCatalog. Basically ZCatalog returns the list of Meta Data fields for both the searchable arguments and results. This means the search form created for a ZCatalog will probably not contain the correct fields. This patch corrects ZCatalog so that it returns its indexes as the searchable arguments. 448c448 for name in self._catalog.schema.keys(): --- for name in self._catalog.indexes.keys(): I will be sumitting these to the collector as well. -- | Casey Duncan | Kaivo, Inc. | [EMAIL PROTECTED] `-- ___ Zope-Dev maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope ) ___ Zope-Dev maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope )
Re: [Zope-dev] CatalogAware
On 1/5/01 7:16 AM, "Chris Withers" [EMAIL PROTECTED] wrote: uncatalog_object to be called on it (I'm not sure what method reindex_object causes to be called). unindex_object followed by index_object. I'm not convinced it's necessary, as no-one has said that uncataloging is a necessary step before catalogng something that's already in the catalog. Actually this is where the luminous KeyError lurks. If you don't unindex_object first (prior to 2.2.4), then you could potentially have words in the forward index that your object no longer contains, and eventually it could get into a state where you get a KeyError. In 2.2.4 I modified it (rather bluntly) to always do an unindex_object before even starting the index_object proceedings... This is obviously rather heavy, but it did prevent a lot of faulty uses... CatalogAware was wrong, for example :-) In 2.3a2 (hopefully :-) and if not a3), Jim and I have developed some merging code that will do much more intelligent merging of new and old data, reducing the size of transactions in the Catalog, and also preventing things from being touched when in fact nothing changed---this can be responsible for 70-80% of the bloat in some sites. In addition, many needless objects were touched when they had no relevance to the object being indexed. This should also help reduce bloat. Speed, so far is on par, and eventually we hope faster for most sites. Chris -- | Christopher Petrilli Digital Creations | [EMAIL PROTECTED]Where Zope comes from ___ Zope-Dev maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope )
Re: [Zope-dev] Keyword Indexes causing Keyerrors
On 12/20/00 11:33 AM, "Itamar Shtull-Trauring" [EMAIL PROTECTED] wrote: I'm getting tons and tons of keyerrors when making changes to a catalogaware object's keyword index and then reindex_object() it. Alternatively, the Catalog doesn't get updated at all. Is there any way to prevent this from happening, other than upgrading to 2.3? Are you getting KeyErrors or are you getting log messages complaining about keyts not existing? Chris -- | Christopher Petrilli Digital Creations | [EMAIL PROTECTED]Where Zope comes from ___ Zope-Dev maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope )
Re: [Zope-dev] Keyword Indexes causing Keyerrors
On 12/20/00 11:52 AM, "Itamar Shtull-Trauring" [EMAIL PROTECTED] wrote: KeyErrors - the logging says: 2000-12-20T16:33:00 ERROR(200) UnKeywordIndex unindex_object could not remove 3 from set This is not the "KeyError" in the sense that it's not propogated up to the top level, but it is a lookup error lower down. I will look into this, but it seems to continue to work correctly, even with the log messages (these are all due to trying to make sure things get unindexed correctly before reindexing). Are you getting incorrect data after reindexing the object? Chris -- | Christopher Petrilli Digital Creations | [EMAIL PROTECTED]Where Zope comes from ___ Zope-Dev maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope )
Re: [Zope-dev] regex (or re) modules
Because both are quite capable of crashing a thread (maybe the whole thing), with poorly written regex expressions. Creating infinate loops is easier than you think, esp if your regex requires backtracking to "solve". Perhaps there should be a simplified regex engine available, that I don't know. Chris -- | Christopher Petrilli | [EMAIL PROTECTED] - Original Message - From: "Tim McLaughlin" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, December 19, 2000 2:35 PM Subject: [Zope-dev] regex (or re) modules Does anybody know why these modules aren't available for DTML and Python Methods? (I already hacked my server, just wanna know what I'm riskin) ___ Zope-Dev maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope )
Re: [Zope-dev] more on keyword indexes
On 12/17/00 3:48 AM, "Dieter Maurer" [EMAIL PROTECTED] wrote: You either have to extend ZCatalog or wait some time. There are different people working on ZCatalog enhancements. At DC, I'm the one working on almost all of it right now, so if people else where are working on Zcatalog enhancements, they may want to talk to me as I believe Zope3 will be *substantially* different. I have had very good response to Collector bug reports for Zope itself. At least in the past, bug reports and even patches for ZCatalog probably have been ignored, however. I hope, this has changed meanwhile. Until recently, the person who best knew the Catalog was no longer working on it actively. I've now taken this over, and while I don't have the bandwidth to track zope-dev constantly, I do try to find things. I've also fixed untold numbers of bugs that were easy to do (there are some that are structural and will have to wait), and 2.3 will have a *substantially* better Catalog. Chris -- | Christopher Petrilli Digital Creations | [EMAIL PROTECTED]Where Zope comes from ___ Zope-Dev maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope )
Re: [Zope-dev] Changing hostname and port without SiteAccess
On 12/18/00 2:24 PM, "Dieter Maurer" [EMAIL PROTECTED] wrote: Martin Winkler writes: I cannot use SiteAccess (because I need multiple ZCatalogs), and my Zope server (port 8080) is behind squid (in http-accelerated mode - port 80). What I would need is changing the hostname and port in the html-responses like this: http://localname.com:8080/blah to http://officialserver.com/blah , so the client reconnects to squid, not zope itself. We have the same situation. We use SiteAccess *AND* ZCatalog. Please, see my message from a few days ago (to [EMAIL PROTECTED]). Please read the message I sent out an hour ago about Path updates to the Catalog... This is designed specifically to fix this problem. Chris -- | Christopher Petrilli Digital Creations | [EMAIL PROTECTED]Where Zope comes from ___ Zope-Dev maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope )
Re: [Zope-dev] IMPORTANT! Zcatalog path handling changes in 2.3
On 12/18/00 4:08 PM, "The Doctor What" [EMAIL PROTECTED] wrote: * Christopher Petrilli ([EMAIL PROTECTED]) [001218 14:13]: PLEASE take a look at this, and provide feedback ASAP. I would happy to, it looks like it does what I need (having siteaccess). However, I don't see a clear cut description what's changing and how. What needs to be done (in easy to understand language) to make sure it all goes smooth, etc. It's actually not as big an update as it looks... I simply grabbed the packages, there's much less changed than it looks like :-) The big differences are all explained in the link above the file. It's a big update, with lots of files. Will this work with 2.2.4? Is it dangerous? If you're asking for guinea pigs (bweep!) then I'm not sure I should be it, as I'm still trying to figure out what's going on in many ways. It should work fine with 2.2.4. Chris -- | Christopher Petrilli Digital Creations | [EMAIL PROTECTED]Where Zope comes from ___ Zope-Dev maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope )
[Zope] Re: [Zope-dev] IMPORTANT! Zcatalog path handling changes in 2.3
On 12/18/00 4:08 PM, "The Doctor What" [EMAIL PROTECTED] wrote: * Christopher Petrilli ([EMAIL PROTECTED]) [001218 14:13]: PLEASE take a look at this, and provide feedback ASAP. I would happy to, it looks like it does what I need (having siteaccess). However, I don't see a clear cut description what's changing and how. What needs to be done (in easy to understand language) to make sure it all goes smooth, etc. It's actually not as big an update as it looks... I simply grabbed the packages, there's much less changed than it looks like :-) The big differences are all explained in the link above the file. It's a big update, with lots of files. Will this work with 2.2.4? Is it dangerous? If you're asking for guinea pigs (bweep!) then I'm not sure I should be it, as I'm still trying to figure out what's going on in many ways. It should work fine with 2.2.4. Chris -- | Christopher Petrilli Digital Creations | [EMAIL PROTECTED]Where Zope comes from ___ Zope maillist - [EMAIL PROTECTED] 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 )
Re: [Zope-dev] License issues
this is not about religion and a flame war is the last thing I want I only wanted to let you know about these facts, and yes there're projects that have been hurt by "license issues", for example KDE. Regaurding licensing, twhile I wouldn't want to snuff out freedom of speech, I would say that we have already had the "Licensing Wars" about 18 months ago, and things are settled and non negotiable at this point. Arguing only creates tension in the community, which does more damage than good. If people choose not to use Zope because it doesn't have a GPL-style license, that is their freedom and we are sorry to see them leave the community, but it is impossible to please all of the people all of the time, and the ZPL pleases most of the people most of the time---including our investors. No speaking for Digital Creations! ;-) Chris ___ Zope-Dev maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope )
Re: [Zope-dev] ZCatalog index error
How are you getting things indexed and reindexed in the Catalog, if I might ask? Chris - Original Message - From: "Andy McKay" [EMAIL PROTECTED] To: "Chris McDonough" [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, November 06, 2000 6:42 PM Subject: Re: [Zope-dev] ZCatalog index error Thanks, will look forward to 2.2.3! I deleted an index and metadata, re created them and recatalogued the affected objects. That seem to solve it in my initial tests... keeping my fingers crossed. -- Andy McKay, Developer. ActiveState. - Original Message - From: "Chris McDonough" [EMAIL PROTECTED] To: "Andy McKay" [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, November 06, 2000 3:49 PM Subject: Re: [Zope-dev] ZCatalog index error Andy, This is a known issue with the catalog (searching the collector for "key error" will show you how common it has been). Chris Petrilli should be checking in some changes to the CVS 2.2 branch (and the trunk?) tomorrow that resolves it. The problem is evidently related to the way catalog.index_object() and catalog.unindex_object() do their thing. I'd advise you live with the issue until 2.2.3 comes out (which should be sometime this week, AFAIK). - Original Message - From: "Andy McKay" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, November 06, 2000 4:17 PM Subject: [Zope-dev] ZCatalog index error Im running into an odd bug with ZCatalog: I have am running a catalog query and Im getting this message. File D:\zope\lib\python\Products\ZCatalog\Lazy.py, line 193, in __getitem__ File D:\zope\lib\python\Products\ZCatalog\Catalog.py, line 197, in __getitem__ KeyError: 52536 This is the line where it seems to be setting all the scores to one, and I guess it can find the item 52536. else: # otherwise no score, set all scores to 1 r=self._v_result_class(self.data[index]).__of__(self.aq_parent) r.data_record_id_ = index r.data_record_score_ = 1 r.data_record_normalized_score_ = 1 The thing is my catalog is only 17,000 records in size, I have no item 52536 (no wonder it cant find it). I guess my best plan would be somehow to remove that the record for that item if I could... hmm... Any other ideas? -- Andy McKay, Developer. ActiveState. ___ Zope-Dev maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope ) ___ Zope-Dev maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope ) ___ Zope-Dev maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope ) ___ Zope-Dev maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope )
Re: [Zope-dev] ZCatalog index error
Well im not sure how much deleting the index and then recreating the index throught the management interface actually does. But I wrote an external method to basically do a find and apply to recatalog bunches of objects. Actually i meant originally, not the second time. Are you using CatalogAware to get objects to automatically index themselves? What exactly are you doing to get them in the Catalog in the first place? Chris ___ Zope-Dev maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope )
Re: [Zope-dev] Newbie SQL Question
On 10/10/00 11:33 AM, "Yvonne Totty" [EMAIL PROTECTED] wrote: HI! I am having a slight newbie problem and for the life of me cannot find any references for how to do it. I have input boxes on a page. I want the information from that box to be input into a database table upon clicking the Submit button. I cannot figure out how to get that information from point 'A' to point 'B'. Assuming your form has a field named the same as all of columns you want to insert (i.e. Foo, bar, whatever)... Then you can have it post to another method that has a line like this in it: dtml-call name="sqlInsertValues" And then have a SQLMethod called 'sqlInsertValues' that has a body like this: INSERT INTO mytable ( column1, column2, column3 ) VALUES ( dtml-sqlvar name="column1" type=string, dtml-sqlvar name="column2" type=int, dtml-sqlvar name="column3" type=string ) Remember to put these in the arguments list, or they won't be caught from the REQUEST namespace. Chris -- | Christopher Petrilli Digital Creations | [EMAIL PROTECTED]Where Zope comes from ___ Zope-Dev maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope )
Re: [Zope-dev] ZSQL returns integer only
On 10/6/00 12:19 PM, "Walter Miller" [EMAIL PROTECTED] wrote: The Oracle8i recordset I'm retrieving includes a few columns which are NUMBER(10,0) format which are milliseconds. I would like to divide each by 1000 and use the ROUND function to return a result with one decimal place, e.g. ROUND(column1/1000, 1) returns 3.1 where column1 == 3080. This works as expected in SQL*Plus. It returns the results as a number formated to one decimal place. ZSQL however returns only an integer. Any suggestions on how to get the decimal places to show? Please make sure you're using the latest Oracle DA, as there was a bug in handling of things that oracle returns as NUMBER(0,0) (which is basically a floating point, but we interpreted as a numberb ecause the scale was 0). Chris -- | Christopher Petrilli Digital Creations | [EMAIL PROTECTED]Where Zope comes from ___ Zope-Dev maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope )