- Zope - Zope lists

How to pass variable to your z-sql method
by Rajani Iyer 05 May '00

05 May '00

Hi every body Is there any one who could till me how to pass variable to z-sql method. becoz i am working on search engine which has to be done in Zope. and my search engine ,searchs for many things so i need to built a query for e.g In Perl or PHP. select * from movies where $query $query is the Query you will be checking for diffrent things and passing it to sql query can any one could tell me how to pass value to my z-sql method if i have the one : select * from movies where <dtml-var query> * how to pass 'query' to my z-sql method in to the page where i will be using this z-sql method for search. -------------------------------------------------------------- QuantumLink Communications, Bombay, India

2 1

adding database records programitically
by Andy Pahne 05 May '00

05 May '00

hi, there, i have a few folders lying around in zope, and each of these folders contains a set of dtml-methods. each of the folders represents a page inside the website we are hosting. the dtml-methods hold the content for the pages. this kind of setup worked nice for a long time, but now there are too much folders, too much methods to maintain, and I am planning to move the contents into the database. I want to avoid typing all the data in again, because that has been done already. I tried this: <dtml-in "objectValues(['Folder'])"> <dtml-with "_['sequence-item']"> <dtml-call "a_sql_method_to_add_the_thing_into_the_database"> </dtml-with> </dtml-in> but this approach did not work for me. if i use <dtml-with nameOfFolder>, everything works fine, but iterating over the folders and using <dtml-with "_[sequence-item']"> did not. Andy Pahne, ap(a)net22.net net22 GmbH Bad Meinberger Strasse 1 32760 Detmold 0 52 31 - 580 640 http://www.net22.net

2 1

Invalid Date-Time String in ODBC
by Ali Baitam 05 May '00

05 May '00

I have an Access table with a date/time field. The field had date and time info (12/4/1999 14:00AM). I made an SQL Method on this table (through ODBC connection) but the test returned "Invalid Date-Time String". I removed the time portion in all the records but the error persisted. Any idea? ali

2 1

Zope on ISP
by Dave 05 May '00

05 May '00

I have Zope set up running under NT alongside IIS and AOLserver3. Works fine as I have complete control and admin rights. I would like to set up Zope on my ISP. I have access to the cgi-bin directory, can run python (and TCL). So how do you setup Zope? The ISP is using Redhat Linux 6.1 and an Apache web server. Tried using the source and compiling - no joy error about compiling rights. Tried using a precompiled version for Linux. The install seemed to work. Got a password setup and tried to run Z2.py without Zserver. Although no errors were returned nothing seemed to happen. I read the How-to on ISP/ZOPE and it assumes you can compile. Also read another how-to that refers to the ability to run under a user account. It then refers to the install.txt which didn't make much sense in the circumstance I was trying to operate. btw knowledge of Linux - not a lot. So how do you do it? Regards, Dave.

2 1

(no subject)
by Markus Hochreiter 05 May '00

05 May '00

hi, when I'm using this form and change methode to update a file, there is no file inserted, when I click object-view, I see the id of the object on the screen and not the file I want to upload! mex the form: <form action="AlpineProduct_change"> <input type="hidden" name="id" value="<dtml-var id>"> File: <input type=file name="file"> <input type=submit value="Change"> the change methode!!! AlpineProduct_change: <dtml-call "manage_upload(REQUEST['id'])">

2 1

__init__.py problem
by Chris Withers 05 May '00

05 May '00

Hi, As many of you will know, I'm working on modernising the Squishdot product. As part of doing this, I thought I'd bring __init__.py into line with the stuff on the Interfaces Wiki (sorry for missing this earlier, Michel ;-) and in the Boring product. Okay, starting with Squishdot 0.3.4, I changed http://www.bay-c.co.uk/init.py.old to http://www.bay-c.co.uk/init.py.new The restart went fine, but now when I try to 'Add a Squishdot Site' I get the following. I am totally at a loss as to why :( Any ideas gratefully recieved... cheers, Chris Error Type: TypeError Error Value: unbound Python method must be called with SquishSite 1st argument Traceback (innermost last): File E:\Zope\2179E4~1.6\lib\python\ZPublisher\Publish.py, line 214, in publish_module File E:\Zope\2179E4~1.6\lib\python\ZPublisher\Publish.py, line 179, in publish File E:\Zope\2179E4~1.6\lib\python\Zope\__init__.py, line 202, in zpublisher_exception_hook File E:\Zope\2179E4~1.6\lib\python\ZPublisher\Publish.py, line 165, in publish File E:\Zope\2179E4~1.6\lib\python\ZPublisher\mapply.py, line 160, in mapply (Object: addSquishdotForm) File E:\Zope\2179E4~1.6\lib\python\ZPublisher\Publish.py, line 102, in call_object (Object: addSquishdotForm) File E:\Zope\2179E4~1.6\lib\python\App\special_dtml.py, line 120, in __call__ (Object: addSquishdotForm) File E:\Zope\2179E4~1.6\lib\python\DocumentTemplate\DT_String.py, line 502, in __call__ (Object: addSquishdotForm) TypeError: (see above)

1 1

Re: SQL Session and Gadfly error.
by Anthony Baxter 05 May '00

05 May '00

>>> Hung Jung Lu wrote > Have you seen an error like > > Error Type: EOFError > Error Value: end of stream during parse near :: "f3pqQ'\012AND name"*" = 'person_id'" > > in using SQLSession with Gadfly? Anyway, it's not too important, just to let > you know that it seem to happen once in a while. Hard to reproduce, though. Hm - it looks like something's making gadfly upset. A couple of thoughts... make sure you're using the oneline form of encoding, or have patched gadfly to allow newlines in strings. if you can reproduce it, try putting a 'print' inside lib/python/Shared/DC/ZRDB/DA.py to dump out all SQL executed... look for a line that's something like: if src__: return query and put a line before it like print "SQL DEBUG:", query this will send all SQL executed by Zope to stdout. Obviously this is not something you should do on a busy server unless you're really sure of yourself (or desperate to track down what's going on...) Anthony

1 0

comparision between zope and other technologies
by nitin 05 May '00

05 May '00

We were planning on starting a web based project, and I was entrusted the task of performing an evaluation/comparision of the various options available , open source as well as commercial . The option we were considering were PERL , PHP , Cold Fusion , Servlets , Zope . Can anyboody pls point me towards an article / report where I can find a comparision in terms of varouos parameters like 1) Portability 2) Scalability 3) Reliability 4) Clustering 5) Security 6) Database Connectivity 7) ... thanks in advance Nitin

3 2

How to transpose a 2-D array?
by Jason Wong 05 May '00

05 May '00

Question: How do I transpose the contents of a 2-D array? Purpose: I have a ZSQL-Method which returns the rows (Model 1, Model 2 etc) as in Diagram 1 below (best viewed in a fixed-width font). I want to present this information in an HTML table as in Diagram 2 below. Diagram 1 ========= Model | Feature 1 | Feature 2 | Feature 3 | Feature 4 --------+-----------+-----------+-----------+----------- Model 1 | Yes | Yes | Yes | No --------+-----------+-----------+-----------+----------- Model 2 | Yes | Yes | No | No --------+-----------+-----------+-----------+----------- Model 3 | No | Yes | No | Yes Diagram 2 ========= | Model 1 | Model 2 | Model 3 ----------+---------+---------+--------- Feature 1 | Yes | Yes | No ----------+---------+---------+--------- Feature 2 | Yes | Yes | Yes ----------+---------+---------+--------- Feature 3 | Yes | No | No ----------+---------+---------+--------- Feature 4 | No | No | Yes tia - Jason Wong Digital View Ltd 2201 Nanyang Plaza 57 Hung To Road Kwun Tong HONG KONG Tel: +852-2861-3615 Fax: +852-2520-2987 www.digitalview.com

2 1

xmlrpc and zclass
by - 05 May '00

05 May '00

hi all i've read Amos xml-rpc articles at xml.com and has even succeeded in viewing and editing dtml methods and documents. now, i need to do stuff with zclass. i have a nested zclass (pub zclass, article zclass, etc). i can access the parent zclass ok. can anybody point me to adding a zclass instance and its property sheet. i think i need to do as the add_zclassForm constructor, ie createInObjectManager, do stuff in propertysheets.myzclass_property.manage_editProperties(REQUEST) but as of now, i'm still in the dark. how can i emulate the zclass constructor in xml-rpc? desperately seekin Zope Zen. thanks -- ------------------------------------------------------ http://www.kedai.com.my/kk Am I Evil?

2 1