- Zope - Zope lists

Weird ZOracle Error: Invalid Character
by Ken Kinder 10 Mar '00

10 Mar '00

I'm getting a weird invalid character error on my ZSQL Method using ZOracle... If anyone could help, I would appreciate it: I have a method with the following params: id username password firstname lastname title deskphone cellphone pagerphone emailaddr soffice_id sprdarea_id And the following query text: insert into suser (id, username, password, firstname, lastname, title, deskphone, cellphone, pagerphone, emailaddr, soffice_id, sprdarea_id) values (<dtml-var id>, '<dtml-var username>', '<dtml-var password>', '<dtml-var firstname>', '<dtml-var lastname>', '<dtml-var title>', '<dtml-var deskphone>', '<dtml-var cellphone>', '<dtml-var pagerphone>', '<dtml-var emailaddr>', <dtml-var soffice_id>, <dtml-var sprdarea_id>); When I test it with example feild values, it renders the following error: Error, oci.error: (911, 'ORA-00911: invalid character\012') With this SQL Used (which if you try in SQL*Plus, is perfectly valid): insert into suser (id, username, password, firstname, lastname, title, deskphone, cellphone, pagerphone, emailaddr, soffice_id, sprdarea_id) values (15476, 'kkinder', 'foo', 'Ken', 'Kinder', 'Database & Web Guru', '303 381 7631', 'None', 'None', 'kkinder(a)messagemedia.com', 0, 0); Any words of wisdom? -- Ken Kinder 303.381.7631

2 1

FW: [Zope] how do you do dynamic redirection?
by Michael Fox 10 Mar '00

10 Mar '00

<dtml-if "myvariable = 'xyz'"> <dtml-call "RESPONSE.redirect('yourlink')"> </dtml-if> Michael Fox Analyst/Programmer Century Software Pty Ltd Ph: +612 9460 1422 Fax: +612 9460 3098 This E-mail from Century Software Pty Ltd expresses the views of the sender and not necessarily the views of the Company. The E-mail and any files transmitted with it are confidential to the intended recipient at the E-mail address to which it has been addressed. The E-mail may not be disclosed or used by any other than the addressee, nor may it be copied in any way. If you are not the intended recipient please contact the sender as soon as possible and delete any copies of this message. Please note that although this E-mail has been checked, we cannot accept any responsibility for any transmitted viruses. It is therefore your responsibility to virus scan attachments (if any). -----Original Message----- From: zope-admin(a)zope.org [mailto:zope-admin@zope.org] On Behalf Of Graham Chiu Sent: Friday, March 10, 2000 10:37 AM To: zope(a)zope.org Subject: [Zope] how do you do dynamic redirection? I would like to redirect a user based upon a variable. <dtml-call "RESPONSE.redirect(/target?myvariable=xyz)"> raises a syntax error. Does the redirect command only take literals? ------- Regards, Graham Chiu gchiu<at>compkarori.co.nz http://www.compkarori.com/dynamo - The Homebuilt Dynamo http://www.compkarori.com/dbase - The dBase bulletin _______________________________________________ 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

Use only part of a list sequence? or External Method to Insert ZSQL?
by Joseph A. Archer 10 Mar '00

10 Mar '00

To all Zopists, <background> I have a form that has several dynamically generated options from a MySQL database. I have each option using a hard-coded array like name="mylist[0]", name="mylist[1]", etc..., and keep the value blank unless selection is made. Everything is working fine. In the next page, I will insert the Authenticated_user as the userid, and another field into a table in the MySQL database. When I get to the next page, I have: ... <dtml-in mylist> <dtml-if "_['sequence-item'] != ''"> <dtml-if "countuser(`AUTHENTICATED_USER`) < 6"> ##countuser counts user in table will be inserted into tabel here... </dtml-if> </dtml-if> </dtml-in> ... People are only allowed to have 5 entries in the table. </background> Here are my questions: 1. Should I use an External Method that accesses a ZSQL Method to insert the fields into the table? (please give me an example of this, it sounds interesting...) 2. Is there a way to only use the first 5 listings of the sequence? Maybe save into another list, then go directly to a ZSQL method insert? 3. Should I just quit and go home? :o) Any help would be greatly appreciated. virtually, Joseph A. Archer IT Coordinator Facilities Management James Madison University archerja(a)jmu.edu

1 0

problems with manage_delObject()
by M.J. Stahl 09 Mar '00

09 Mar '00

I currently have a hyperlink, that is used to delete an object that resides within the OOSStorage folder. [<a href="outofstock/OOSStorage/manage_delObject(<dtml-var id>)">SHIPPED</A>] The <dtml-var id> is interpreted just fine, but what it tells me when I click on the URL gives me a; (start error notice) Debugging Notice Zope has encountered a problem publishing your object. Cannot locate object at: http://160.100.0.1/inventory/backorders/outofstock/OOSStorage/manage_delObje cts%2820000428164227%29 (end error notice) [NOTE: 20000428164227 is the ID, I am assuming %28 and %29 are either the '()' or the '<>'] Can anyone give me any pointers on deleting an object directly through a hyperlink. I think I am on the right track but am missing something when trying to use the 'manage_delObjects()' function. Any enlightenment would be extremely appreciated. Best regards, MJ Stahl

2 2

Syntax error in XML-RPC How to?
by dillera＠isc.upenn.edu 09 Mar '00

09 Mar '00

hi: I'm trying to use the BasicAuth example in the "XML-RPC How To" http://www.zope.org/Members/Amos/XML-RPC I keep getting the Zope error when creaing the External Method: Zope has encountered an error while publishing this resource. Error Type: SyntaxError Error Value: invalid syntax -------- I've just cut and pasted this from the webpage, only removed extra padding spaces, and spliced the one big line back together: h.putheader("AUTHORIZATION", "Basic %s" % string.replace(encodestring("%s:%s" % (self.username, self.password)),"\012", "")) The code defines a class and a def: --------------- class BasicAuthTransport(xmlrpclib.Transport): def __init__(self, username=xxxx, password=xxxx): self.username=username self.password=password def request(self, host, handler, request_body): # issue XML-RPC request ---------------- In the Add External method page, where you enter in the Function name I've tried: request BasicAuthTransport BasicAuthTransport.request request.BasicAuthTransport Which is the right one? it want's the Function 'request', right? So, the syntax error must be something in the script. Any help would be appreciated. -andy

2 4

RE: [Zope] Silly newbie question
by Carlson, Christopher W. 09 Mar '00

09 Mar '00

Ha, ha! Silly me... Internally, my server is known as 'www.waco.ct' and I set up SiteAccess so that every request containing 'waco' and 'ct' is redirected to the SquishDot folder. Of course, this means that I instantly can't get back to the root folder for any reason. To fix it, I shut down Zope, removed the SiteAccess product manually, restarted, and got rid of the offending code. I offer this as a warning to others interested in SiteAccess--the product works great, but think a little before you set things up, lest you fall into the same trap I did. --- Chris -----Original Message----- From: Carlson, Christopher W. [mailto:Christopher.W.Carlson@ct.sgcna.com] Sent: Thursday, March 09, 2000 2:41 PM To: 'Rik Hoekstra' Cc: 'zope(a)zope.org' Subject: RE: [Zope] Silly newbie question This works perfectly. Thanks a bunch. Now, let's see if I can get through a week without having to resort to begging for help... --- Chris -----Original Message----- From: Rik Hoekstra [mailto:rik.hoekstra@inghist.nl] Sent: Thursday, March 09, 2000 2:12 PM To: Carlson, Christopher W.; zope(a)zope.org Subject: Re: [Zope] Silly newbie question [RH] You probably want the site-access product. It is available at http://www.zope.org/Members/4am/SiteAccess Rik _______________________________________________ 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 ) _______________________________________________ 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

newbie closing in on Zope / IIS
by Mitch Duvall 09 Mar '00

09 Mar '00

I think my Zope is working with IIS, but some of the icons in the Management screen can't be found. For example, the Control Panel icon is fine: http://localhost/scripts/zope.pcgi/p_/ControlPanel_icon is indeed there. This looks like an object reference, right? The Folder Icon: http://localhost/scripts/zope.pcgi/misc_/OFSP/Folder_icon.gif , however, is not. The same is true for the User Folder and DTML Method gifs (and a few others). In the Zope install, the gifs are in the root\lib\python\Products\OFSP\images folder. I'd welcome any suggestions. It's a minor problem, but it's a bit of an eyesore. Thank you! Regards, Mitch Duvall mduvall(a)webversant.com P.S. There was a thread about Zope / IIS last month. I was in a similar situation in which all I could see when I got to step 6 in Brian Hooper's how-to was the "Welcome to Zope" page. The change that got me into the Management screen and logged on was to use the default 401.5 error message for IIS' "Default Web Site". My thanks to all who've helped out. __________________________________________________ Do You Yahoo!? Talk to your friends online with Yahoo! Messenger. http://im.yahoo.com

1 0

ZODB and 'root()' object (QUEST)
by Oscar Picasso 09 Mar '00

09 Mar '00

HI, In the python interpreter I have done the following things: >>>import sys, ZODB, ZODB.FileStorage >>>db = ZODB.DB(ZODB.FileStorage('/usr/local/zope/zope214/Data.fs')) >>>root=db.open().root() Where 'Data.fs' is my Zope DB with a lot of stuff. Then I did the following things: >>>root.__dict__ >>>{} #result of the previous "command" >>>dir(root) >>>[] #result of the previous "command" >>>vars(root) >>>{'container' : {}} #result of the previous "command" I expected to find the stuff I have in my Zope DB. I double checked to look if I didn't made a typo on the longname of my Data.fs file, but all seems ok. I also saw that the modification time of Data.fs.lock and Data.fs.tmp were set to the time I run db=ZODB.DB(....... so I guess I chose the right Data.fs file. Can someone tell me where am I wrong? Thanks

2 2

problems with manage_delObject()
by M.J. Stahl 09 Mar '00

09 Mar '00

I currently have a hyperlink, that is used to delete an object that resides within the OOSStorage folder. [<a href="outofstock/OOSStorage/manage_delObject(<dtml-var id>)">SHIPPED</A>] The <dtml-var id> is interpreted just fine, but what it tells me when I click on the URL gives me a; (start error notice) Debugging Notice Zope has encountered a problem publishing your object. Cannot locate object at: http://160.100.0.1/inventory/backorders/outofstock/OOSStorage/manage_delObje cts%2820000428164227%29 (end error notice) [NOTE: 2820000428164227 is the ID, I am assuming %28 and %29 are either the '()' or the '<>'] Can anyone give me any pointers on deleting an object directly through a hyperlink. I think I am on the right track but am missing something when trying to use the 'manage_delObjects()' function. Any enlightenment would be extremely appreciated. Best regards, MJ Stahl

1 0

Zope lockups...
by jiva＠devware.com 09 Mar '00

09 Mar '00

I have seen a couple of people mention zope lockups on here before and I haven't seen any myself until just recently. (I have zope on about 5-6 machines and this is the first time I've seen this happen) Anyway, how can I diagnose this problem? So far I have only seen it happen twice, but it was twice in the last 24 hours, and I'm getting ready to roll out this app to some users. I'm concerned! Anyone have any suggestions? Symptoms are basically that it just stops responding. The web browser seems to connect, but it never completes the connection. Right now I have it running in debug mode to see if I can catch whatever it is with some console logging. This is on an NT Server running NT 4.0 -- Lack of skill dictates economy of style. - Joey Ramone

2 1