March 1999 - Zope - Zope lists

RE: [Zope] ZOracleDA and long numbers
by TFE MMS JARVIS JOHN 23 Mar '99

23 Mar '99

I have no problems with other applications as long as I stick with floats. Notably, Zope on Windows running through ODBC has no problems--the values are all converted to python L types. (Hey! maybe I should take a look at the ODBC code...) This is what originally led me to believe that the problem wasn't with Oracle, but within the OCI interface to Zope. I also thought that it also might have something to do with my Linux install, but SQL*Net doesn't have problems and Zope works wonderfully except for long numbers. Environment info: Zope 1.10.2 ZOracleDA 2.0.0 RedHat Linux 5.2 Oracle Net8 Client Apache > -----Original Message----- > From: Jordan B. Baker [SMTP:jbb@spyderlab.com] > Sent: Tuesday, March 23, 1999 1:22 PM > To: TFE MMS JARVIS JOHN > Cc: zope(a)zope.org > Subject: Re: [Zope] ZOracleDA and long numbers > > On Tue, 23 Mar 1999, TFE MMS JARVIS JOHN wrote: > > > Hi all! > > > > I'm having a problem with running queries containing long numbers. > > I found in db.py that the data type NUMBER is converted to an > > integer which overflows in my case. > > > > The errors: > > > > Error, oci.error: (1455, 'ORA-01455: converting column overflows integer > > datatype\012') > > Without having yet looked at the source(*) could this be an error > occuring in Oracle itself? > > I just noticed the ORA-* which is typically an Oracle error message. > > ------- > Jordan B. Baker -- jbb(a)spyderlab.com > weaving the web @ http://www.spyderlab.com > (*) - BEWARE :) >

1 0

sort order for tree display?
by Joe Van Andel 23 Mar '99

23 Mar '99

I'm still experimenting with ZOPE and the FAQ tool, which uses the 'tree' display widget. When I add a category or a FAQ entry, these items seem to appear in reverse order of the order I added them. The FAQ widget index_html DTML contains the line:  On what basis are the categories sorted? By name of the object's folder? Is there anyway to get the entries sorted in the order they were entered? Thanks much! Joe VanAndel Internet: vanandel(a)ucar.edu National Center for http://www.atd.ucar.edu/~vanandel/home.html Atmospheric Research

1 0

Re: Zope digest, Vol 1 #185 - 21 msgs
by Jason Spisak 22 Mar '99

22 Mar '99

Ty: Again, the usefullness of your code is only outweighed by your generousity. I'm trying to get a personal schedular for my people, and I didn't want to go outside of Zope(since they are using that for thier everyday needs). And here you are with your Calendar tag. Thanks! Oh, I am reading your source to gleen how to implement the persistance of appointments, any hints? Jason Spisak webmaster(a)mtear.com Message: 1 From: tsarna(a)endicor.com (Ty Sarna) Subject: [Zope] Calendar tag released Date: 21 Mar 1999 21:17:56 GMT Organization: Endicor Technologies, Inc., San Antonio, Texas To: zope(a)zope.org People have been asking for my Calendar tag product, so I've uploaded a beta version to the contributed software page. With the DateTime class fixed in zope 1.10.x, it should be stable (in 1.9, misccalculations sometimes cause botches like repeated days). Have fun, and let me know what you think. When I get a chance I'll probably add a Year mode and polish up the documentation and call it 1.0.

1 1

passings vars to sql method
by Fredy Villa 22 Mar '99

22 Mar '99

Zopists, I run into a problem. I have a DTML Methos that call an SQL Method. The SQL method, displayTasks, has two parameters, userID and statusID. The DTML method does have access to the variables userID and statusID prior to calling the sql method with a  tag. The DTML method looks like this:  <H2> </H2> <P><b></b></P> List of tasks: <form action=displayUser method=post> <SELECT NAME=statusID>  <OPTION VALUE=>  </SELECTED> <input type=hidden name=userID value=> </form> <table>  <tr><td></td><td></td><td> </table>  THE SQL methos look like this: select * from task_schedule where task_schedule.userID =  AND task_schedule.statusID =  -------------------------------------------------- I basically can't run the query because it cannot get a value for userID or statusID. How do I pass these vars to the sql method from a dtml method??? Thanks in advance, Fredy Villa FVilla(a)GestaltTechnology.com

2 1

ZTables (Tablula) and SQL databases
by Robert OConnor 22 Mar '99

22 Mar '99

Looking for some enlightenment: <set learning on> I understand that Ztables was formerly Tabula an object database. If one were starting from scratch without legacy data would it make sense to use an object database instead of a relational database? If so, is ZTables/Tabula a full, robust database system that can scale up and exceed the features of Oracle or SQLxxx databases? What are the pros/cons of Object vs Relational databases. Currently it appears that Ztables/Tabula is priced at $1,500 but eventually may become open source. >From recent posts on the list *"Make site searchable" *"one 'document' in many 'folders'" It seems like Ztables would be an Ideal solution to these problems. ie, rather than the kludge of multiple copies of the SAME document, ONE copy in the database. Also, searching by key or full text would be possible. But for further enlightenment, can anyone point to good examples on the web of the use of ZTables/Tabula? woops, your request to <set learning off> has been denied! :-) -bobo connor

2 1

Re: [Zope] one 'document' in many 'folders'
by Stefan Franke 22 Mar '99

22 Mar '99

I just thought a little more about the approach having a pool and some proxy objects that refer to the pool. I think it could be made quite neat when using just the following code for the proxies (DTML documents):  So you just need to put zope_is_cool inside your pool and add DTML documents with the above code under the same id to your folder structure wherever you like. Just check it out. Two caveats: - You have to use DTML documents, not methods, otherwise id() refers to the folder's id - Make sure that zope_is_cool really exists inside your pool, or you get an infinite redirection! (zope_is_cool is not found in the pool and then sought for along the aquisiton path, which refers to zope_is_cool itself, which redirects to the pool which ...) Maybe this could be even generalized to some kind of "symbolic link" product. Ideas anyone? Stefan

2 1

Re: [Zope] MySQL LAST_INSERT_ID...
by Tom Jenkins 22 Mar '99

22 Mar '99

Hi Phil, Sorry I didn't make things clear (maybe I'll update the list?). Yes I solved my problem and feel really dumb. I didn't realize that the traceback is in the error page as a comment. Once I found that out, I saw immediately that the arguments passed in had a couple of extra fields that I didn't use (the master and detail tables share some initial fields). I took them out of the sql statement and the form, but I didn't remove them from the argument list. (Just an FYI, the system allows you to add additional detail records, the first one is autogenerated from the master) > Hi Tom, > > I have been on vacation and can't tell whether you have solved your problem. > > If you are still having problems email me. I am doing exactly what you > want to do so I will dig through my code and send you some tested examples > if you like. > > Phil. > > >To followup my last post, I'm getting an exception when trying to use > >MySQL's "select LAST_INSERT_ID()" function: -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Tom Jenkins DevIS (http://www.devis.com) Can the denizens of this group enlighten me about what the advantages of Python are, versus Perl? "python" is more likely to pass unharmed through your spelling checker than "perl". An unknown poster and Fredrik Lundh, 11 Sep 1998

1 0

Re: [Zope] one 'document' in many 'folders'
by Johan Lindstrom 22 Mar '99

22 Mar '99

Pavlos wrote: >Assuming you have a folder Entries and folders Python and Zope. An entry >in the entries folder is a DTML doc with a lines property named sections >containing the sections (folder names) where the given entry belongs to. >In the root folder you have a DTML method like: (untested) This is great, I'm planning on doing exactly this myself. Roughly, if I don't want sluggish performance, what would the upper limit be in regard to number of articles? Are we talking hundreds of articles? Thousands? /J - Zope ultra-newbie ------ ---- --- -- -- -- - - - - - Johan Lindström BossMedia Sourcerer johanl(a)bahnhof.se http://www.bahnhof.se/~johanl/ If the only tool you have is a hammer, everything tends to look like a nail

1 0

RE: [Zope] Impact of Zope on hosting provider?
by Paul Everitt 22 Mar '99

22 Mar '99

Jim wrote: > I decided before signing up with a hosting server to wait for > Zope 2, which > I've seen a couple of references to. What's the deal on > that? One place > promised a better integrated web server. If Zope moves more > torward being a > totally self contained server, then I don't want to mess with > Apache or IIS. I expect ZServer, which is the better integrated package that you're talking about, to enter beta within the next three weeks. --Paul

1 0

Calendar tag released
by tsarna＠endicor.com 21 Mar '99

21 Mar '99

People have been asking for my Calendar tag product, so I've uploaded a beta version to the contributed software page. With the DateTime class fixed in zope 1.10.x, it should be stable (in 1.9, misccalculations sometimes cause botches like repeated days). Have fun, and let me know what you think. When I get a chance I'll probably add a Year mode and polish up the documentation and call it 1.0.

1 0