April 2000 - Zope - Zope lists

Re: [Re: [Zope] Z ODBC Error Value: unpack sequence of wrong size ]
by Ioan Coman 06 Apr '00

06 Apr '00

Thank you Hung! I can manage the database by Z SQL methods even I get that error. Yes! It really works. (Someone did reply me with that tip.) Ignore that message and create Z SQL methods! I'm not using Access2000. Just Access 97. Thank you all! Ioan. "Hung Jung Lu" <hungjunglu(a)hotmail.com> wrote: >Also, sqlmethods are broken in 2.1.5 - need to upgrade to 2.1.6 > > I am having exactly the same problem. I was running 2.1.1 before, > and got the "unpack sequence of wrong size" error. I thought, > OK, I'll upgrade to 2.1.6. Surprise! It does not fix anything. :( > > The funny thing is that I can browse the table structures. > (I have tables created in Access.) Just that I cannot > "select" nor "create" tables. > > Has anyone been able to run ZODBC with Access2000 on 2.1.6? > Or is ZODBC only good for 2.1.4? Does anyone know where I can > get a Win32 binary copy of Zope 2.1.4? > > Ioan: are you using Access 2000? Could that be the source of > the problem? > > regards, > > Hung Jung > ____________________________________________________________________ Get free email and a permanent address at http://www.netaddress.com/?N=1

1 0

Bug in List/Records ????
by Luis Cortes 06 Apr '00

06 Apr '00

I have the following code for a simple International timesheet application: >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> <dtml-var standard_html_header> <H1>Timesheet for <dtml-in "sqlSelectSingleControl()"> [<dtml-var week_end>] </dtml-in> <br> For [<dtml-var "AUTHENTICATED_USER">] </H1> <form action="dtmlVerifyTimeSheet" method="POST"> <table border=2> <tr> <th rowspan="2"> Accounts <dtml-comment> ================================================================ Place days of week headings ================================================================ </dtml-comment> <dtml-in "['Monday','Tuesday','Wednesday','Thursday','Friday','Saturday','Sunday']"> <th colspan="2"> <dtml-var sequence-item> </dtml-in> <dtml-comment> ================================================================ place USA or MEX headings ================================================================ </dtml-comment> <tr> <dtml-in "1,2,3,4,5,6,7"> <th>USA<th>MEX </dtml-in> <dtml-comment> ================================================================ 1. Place DROP down list of Charge Accounts per row 2. Place 7 Hour Edit Boxes for usa/mex per row ================================================================ </dtml-comment> <dtml-let list="DBGetAccts()"> <dtml-in "1,2,3,4,5,6,7,8,9,10"> <dtml-let rowid=sequence-item> <dtml-comment> ================================================================ Charge Accounts per row ================================================================ </dtml-comment> <tr><td> <SELECT NAME="items.acct:records"> <dtml-in list> <OPTION SELECTED VALUE="<dtml-var aid>"> (<dtml-var aid>) <dtml-var description> </OPTION> </dtml-in> </SELECT> <dtml-comment> ================================================================ mex/usa hours per row ================================================================ </dtml-comment> <dtml-in "1,2,3,4,5,6,7"> <td> <input type="float" name="items.usa:records" maxlength = "4" size="4"> <td> <input type="float" name="items.mex:records" maxlength = "4" size="4"> </dtml-in> </dtml-let> </dtml-in> </dtml-let> <dtml-comment> ================================================================ place OK button ================================================================ </dtml-comment> </table> <input type = "submit" value="OK"> </form> <p> Today is <dtml-var ZopeTime fmt=Date>, the time is <dtml-var ZopeTime fmt=Time>.</P> <dtml-var standard_html_footer> >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Please notice that I have an adjustable number of charge accounts. What is nice is that I get an ordered list from my records which looks like: [acct: 1, mex: , usa: , mex: , usa: , mex: , usa: , mex: , usa: , mex: , usa: , mex: , usa: , acct: 1, mex: , usa: , mex: , usa: , mex: , usa: , mex: , usa: , mex: , usa: , mex: , usa: , mex: , usa: , acct: 1, mex: , usa: , mex: , usa: , mex: , usa: , mex: , usa: , mex: , usa: , mex: , usa: , mex: , usa: , acct: 1, mex: , usa: , mex: , usa: , mex: , usa: , mex: , usa: , mex: , usa: , mex: , usa: , mex: , usa: , acct: 1, mex: , usa: , mex: , usa: , mex: , usa: , mex: , usa: , mex: , usa: , mex: , usa: , mex: , usa: , acct: 1, mex: , usa: , mex: , usa: , mex: , usa: , mex: , usa: , mex: , usa: , mex: , usa: , mex: , usa: , acct: 1, mex: , usa: , mex: , usa: , mex: , usa: , mex: , usa: , mex: , usa: , mex: , usa: , mex: , usa: , acct: 1, mex: , usa: , mex: , usa: , mex: , usa: , mex: , usa: , mex: , usa: , mex: , usa: , mex: , usa: , acct: 1, mex: , usa: , mex: , usa: , mex: , usa: , mex: , usa: , mex: , usa: , mex: , usa: , mex: , usa: , acct: 1, mex: , usa: , mex: , usa: , mex: , usa: , mex: , usa: , mex: , usa: , mex: , usa: , mex: , usa: , mex: , usa: ] The problem, if you will carefully notice, is that from acct:1 to the next acct:1 there are only 6 pairs of mex:, usa:, in the rest there are 7 and in the last acct:1 to end of list there are 8! Is this behavior correct??? I really doubt it, but if it is correct can someone explain it to me??? regards, Luis. -- ====================================================== Luis Cortes Pollak EPD (915) 621-6113 ======================================================

1 0

globals() ????
by katrin 06 Apr '00

06 Apr '00

Hi everybody, can anyone tell me what exactly globals() is? What does it do? Or what does it consist of? Thanks, Katrin

2 1

ZSQL Method (input argument)
by Gergely Gulis 06 Apr '00

06 Apr '00

Hi, I am new at Zope. So I have difficulties while i am building a website. The problem: I use the Zope's own SQL database. I'd like to insert datas via Web into it. I wanna give some information with checkboxes, but as far as i know, if i do not select a checkbox, the HHTP request do not contain the value of the variable belongs to that checkbox. When I am defining the SQL insert command (as a query), I have to give the input arguments. So if i do not check a checkbox, the ZSQL Method screams for it. 1. At first i tried to define the table with default values, Error message No 1. 2. Then I tried to define the variables belonging the checkboxes in the folder as a propertiy with unchecked value, Error Message No. 2. I have no more idea. How can I solve this problem? Thanks in advance, Gergo

2 1

Starting Zope (NT Service) with chosen parameters
by Hugo Ramos 06 Apr '00

06 Apr '00

Yellow, I would like to have the same facility to start Zope in an NT box (as a service) as I have in Linux!!! Is that too much to ask? I think not! So anyone started Zope with '-w 80' or another special parameter in an NT box (AGAIN: Zope is an NT Service)?????? After i get this done (with your VERY needed help) I promise to write a how-to on this... thanks --- Hugo Ramos - hramos(a)ruido-visual.pt Ruido Visual - Telecomunicacoes Interactivas, Lda

2 2

Does GUF work with 2.1.6?
by Tony McDonald 06 Apr '00

06 Apr '00

Hi all, Can someone confirm that GenericUserFolder 1.2.0 works with Zope 2.1.6? - I'm looking very closely at GUF as UserDB 1.3. doesn't work fully with 2.1.6 and I really need SQL authentication. I've just installed a clean 2.1.3 and updated to 2.1.6 using the mini-installer and then installed GUF 1.2.0. I've followed the instructions at http://www.zope.org/Members/hippy/GUF_SQL_crypt_1_1 which certainly help in the setting up process, as well as reading the README in the GUF distn. User 'jorge' has roles of Anonymous Manager defaultrole specialrole I've tried using cookie and standard authentication, and have set an index_html doc in the same folder as the acl_users folder to have no perms. for 'Anonymous' and view for 'Manager'. I always get a basic authentication dialog pop up and 'jorge', 'secret' is not recognised. It looks a very interesting package, but at the moment, I'm stumped. any advice would be appreciated. tone ------ Dr Tony McDonald, FMCC, Networked Learning Environments Project http://nle.ncl.ac.uk/ The Medical School, Newcastle University Tel: +44 191 222 5888 Fingerprint: 3450 876D FA41 B926 D3DD F8C3 F2D0 C3B9 8B38 18A2

2 1

Socket Problems
by Patrick Lewis 06 Apr '00

06 Apr '00

I have kind of a stupid question about sockets. When starting zope (using z2.py -D) I get: ------ 2000-03-25T18:56:54 PROBLEM(100) ZServer Computing default hostname ------ 2000-03-25T18:56:54 INFO(0) ZServer Medusa (V1.13) started at Sat Mar 25 10:56:54 2000 Hostname: milo Port:8080 ------ 2000-03-25T18:56:54 INFO(0) ZServer FTP server started at Sat Mar 25 10:56:54 2000 Authorizer:None Hostname: milo Port: 8021 ------ 2000-03-25T18:56:54 INFO(0) ZServer PCGI Server started at Sat Mar 25 10:56:54 2000 Unix socket: /usr/local/src/Zope-2.1.4-src/var/pcgi.soc Traceback (innermost last): File "/usr/local/src/Zope-2.1.4-src/z2.py", line 551, in ? port=MONITOR_PORT) File "/usr/local/src/Zope-2.1.4-src/ZServer/medusa/monitor.py", line 264, in __init__ monitor_server.__init__ (self, hostname, port) File "/usr/local/src/Zope-2.1.4-src/ZServer/medusa/monitor.py", line 168, in __init__ self.bind ((hostname, port)) File "/usr/local/src/Zope-2.1.4-src/ZServer/medusa/asyncore.py", line 205, in bind return self.socket.bind (addr) socket.error: (49, "Can't assign requested address") Using z2.py -D -m '' (disabling the monitor), everything works fine. (Except no monitor, obviously). Using -m with other socket numbers results in the same error. (49, "Can't... ). FreeBSD 3.4, Zope 2.1.4, running as root. Any ideas what to try? I would like to use the monitor, if just for the coolness factor. Thanks in advance. Patrick Lewis <pl(a)teleport.com>

3 3

Redirection Question
by Tom Scheidt 06 Apr '00

06 Apr '00

Ive created a Product with this line: <dtml-call "RESPONSE.redirect( DestinationURL() +'manage_main')"> To redirect the user back to the management screen of the document he/she has created, but it don't work. Any ideas? The full document: <dtml-var standard_html_header> <dtml-with "manage_clone(story_html,REQUEST['new_id'],REQUEST)"> <dtml-call "manage_changeProperties(title=REQUEST['new_headline'], producer=REQUEST['new_producer'], headline=REQUEST['new_headline'], subhead=REQUEST['new_subhead'], source=REQUEST['new_source'], shortstory=REQUEST['new_shortstory'], story=REQUEST['new_story'], byline=REQUEST['new_byline'], copy=REQUEST['new_copy'], image=REQUEST['new_image'], caption=REQUEST['new_caption'], )"> </dtml-with> <dtml-call "RESPONSE.redirect( DestinationURL() +'manage_main')"> Congratulations! <dtml-var standard_html_footer> ************************* Tom Scheidt www.falsemirror.com tom(a)falsemirror.com *************************

2 1

RE: [Zope] PTK Issue Tracker
by Yanko, Curtis (GSP) 06 Apr '00

06 Apr '00

I wasn't sure if they had put a nice interface on your product or rolled their own. Now I think it is a ZClass that isn't publicly available. Sure would be nice if it was ;-) -Curt Yanko > -----Original Message----- > From: Shalabh Chaturvedi [SMTP:shalabh@pspl.co.in] > Sent: Thursday, April 06, 2000 9:20 AM > To: Yanko, Curtis (GSP); zope(a)zope.org > Subject: Re: [Zope] PTK Issue Tracker > > Yanko, Curtis (GSP) wrote: > > Is that tracker the iTracker product or something new? > > The PTK tracker and the iTrack Issue Tracker are two completely different > products. > > The iTrack product is newer among the two and lags behind in features. > > Cheers, > Shalabh > > > -Curt Yanko > >

1 0

Re: [Zope] Re: Newbie method rendering question -- Squishdot
by Chris Withers 06 Apr '00

06 Apr '00

Doh! Didn't see that bit... Try: <dtml-with squish> <dtml-var index_html> </dtml-with> It might work, after that I'm out of ideas :( Chris PS: I see you tried the above with <dtml-var "index_html()">, so it probably won't work. My advice would be to aim to move away from Squishdot unless it does what you want. I think a lot of these problems are 'cos it's old code and Butch Landingin doesn't seem to have much time to maintain it. You could try emailing him at squishdot(a)yahoo.com. Larry Albert wrote: > > At 12:15 PM 4/6/00 +0100, you wrote: > >Try <dtml-var squish>... It migth work. > > That's what I did (see below), and it didn't. Any other suggestions? > > Larry > > ><dtml-var "squish"> is just returning the object instance, not rending the > object... > > > >Chris > > > >Larry Albert wrote: > >> > >> I tried this again, but I'm still having problems. I would like to include > >> the contents of a Squishdot site, which is at /squish/index_html, within a > >> DTML method at /Squishmirror. > >> > >> After some offline suggestions following my earlier post, I've tried > >> > >> <dtml-var squish> > >> > >> in Squishmirror, which gets me simply the phrase > >> "<Products.Squishdot.Squishdot.SquishSet instance at 12cdce0>" encoded in > >> the HTML of the output. Same result for <dtml-var "_.getitem('squish', 1)"> > >> and <dtml-var "squish()">. > >> > >> However, > >> > >> <dtml-var "squish"> > >> > >> gets me "<SquishSite instance at 011EF790>" in the HTML, as does <dtml-var > >> "_.getitem('squish', 0)">. > >> > >> One of these should have worked, shouldn't it? Or is there something about > >> products, or Squishdot in particular, that resists being called this way? > >> Do I need to pass the site a different namespace somehow? I'd like to be > >> able to include the method, not just redirect to it. > >> > >> Any help would be appreciated. > >> > >> Larry Albert > >> lda(a)rice.edu > >> > >> Earlier post: > >> >I would like to include the contents of a Squishdot site, which is at > >> /squish/index_html, within a DTML method at /Squishmirror. In Squishmirror > >> if I use > >> > > >> ><dtml-with squish> > >> > <dtml-var "index_html()"> > >> ></dtml-with> > >> > > >> >it gives me an error, seemingly in the process of rendering /index_html > >> (not the /squish/index_html that I want.) If I instead try > >> > > >> ><dtml-with squish> > >> > <dtml-var "squish.index_html()"> > >> ></dtml-with> > >> > > >> >it gives me an error because it can't render the first siteheader variable > >> within /squish.index_html. > >> > > >> >Is it not possible to render a product from a different location? Or am I > >> just getting the calling syntax wrong? (Or both?) > >> > > >> >Thanks for any help, > >> > > >> >Larry Albert > >> >lda(a)rice.edu > >> > > >> > >> _______________________________________________ > >> Zope maillist - Zope(a)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 ) > >

1 0