- Zope - Zope lists

TAL / Z SQL Method
by Arjan Huijzer 03 Feb '03

03 Feb '03

Hello, I am having a problem with calling multiple Z SQL Methods from within Page Templates. What I need to accomplish is calling a Z SQL Method using a parameter value from another Z SQL Method. My code looks like: <p tal:repeat="cd container/z_sql_methods/select_cd"> <span tal:replace="cd/cd_title">CD Title</span> <ul tal:repeat="song container/z_sql_methods/select_songs"> <li content="song/song_title">Song Tile</li> </ul> </p> As you can see I have two Z SQL Methods, namely "select_cd" and "select_songs". For every CD that is in the database, the songs need to be retrieved. This is done by using the second Z SQL Method that takes one parameter, "cd_id". How can i pass this parameter "cd_id" in the TAL statement? I have looked through the available docs, but couldn't find the solution. Can someone please help me or point to a relevent piece of documentation? Thanks in advance!! Arjan Huijzer __________________________________________________ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com

3 2

Restrictions to domains, Logoff page
by Sven Jacobs 03 Feb '03

03 Feb '03

I have two questions: 1) Is it possible to restrict the Zope Server to special domains, rejecting requests from all other domains? 2) Where do I change the page loaded after logging of from the Zope management environment? Thanks in advance! -- Sven Jacobs TEDSoft GmbH jacobs(a)tedsoft.de www.tedsoft.de

2 2

Running Python Scripts via the Management Interface
by Asad Habib 03 Feb '03

03 Feb '03

Hello. Does anyone know why the following script stalls when I run it in Zope's Management Interface using the 'Test' command? context.manage_addProperty(propertyId, propertyValue, propertyType) All it does is add a property to a folder. The script does function properly and doesn't stall when I access it from a DTML method. However, it stalls when I run it directly. Any help would be appreciated. Thanks. -Asad __________________________________________________ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com

2 1

Big Thanks...
by Samir Mishra 03 Feb '03

03 Feb '03

Again, thank you all for your help. Much appreciated. Still struggling, but not floundering... Samir

1 0

RE: [Zope] RESPONSE.setStatus(), what does that do?
by pskipwort＠touchcorp.com 03 Feb '03

03 Feb '03

Without looking at the docs, I'd assume this sets the HTTP response code - ie '200' for a successful request, etc etc. Cheers P -----Original Message----- From: mail(a)peterbe.com [mailto:mail@peterbe.com] Sent: Monday, 3 February 2003 12:08 PM To: zope(a)zope.org Subject: [Zope] RESPONSE.setStatus(), what does that do? I noticed in Dieter Mauer's Chapter 3 book this DTML:: ... <dtml-except> <dtml-call "RESPONSE.setStatus(error_type)"> ... What does that setStatus actually do? Or, what does it help? _______________________________________________ Zope maillist - Zope(a)zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )

4 3

IP Address
by Simon Faulkner 03 Feb '03

03 Feb '03

Can I get the IP Address of a visitor to my site? I need to use it to modify the response of my program. Simo

5 4

Restricting products in add list
by Sean K 03 Feb '03

03 Feb '03

Hi all, Is there a way to display in the add list only the products you want added to a product that subclasses Folder. I have subclassed folder and added methods that add other products that are components of the overal product. This is to make distribution of the prodcut easier and editing contents more visual. I would like the add list restriced when inside the sublassed folder, and would like the sub products removed from the list when outside. If this is wishful thinking, that's fine, it would just make use of the product more intuitive. Thanks Sean Kemplay __________________________________________________ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com

2 1

RESPONSE.setStatus(), what does that do?
by Peter Bengtsson 03 Feb '03

03 Feb '03

I noticed in Dieter Mauer's Chapter 3 book this DTML:: ... <dtml-except> <dtml-call "RESPONSE.setStatus(error_type)"> ... What does that setStatus actually do? Or, what does it help?

1 0

ZPT - conditional metal:define-slot
by Max M 02 Feb '03

02 Feb '03

I have a template (Only relevant parts here) <td width="20%" bgcolor="#CCCCCC"> <div metal:define-slot="leftColumn">leftColumn</div> </td> <td width="60%" bgcolor="#FFFFFF"> <div metal:define-slot="primary">primary content</div> </td> <td width="20%" bgcolor="#FFFFFF"> <div metal:define-slot="secondary">secondary content</div> </td> Wich I call like: <div metal:fill-slot="leftColumn"> Lef content </div> <div metal:fill-slot="primary"> primary content </div> <div metal:fill-slot="secondary"> secondary content </div> But I would really like the "secondary" column/td to be optional. So that if I don't have any content for it, it will no be there. Does anybody have a clue as for the best way to do something like this? regards Max M

2 2

KinterbasdbDA and Stored Procedures Question.
by Derek Basch 02 Feb '03

02 Feb '03

Hello, Has anyone ever successfully used the KinterbasdbDA to pass a stored procedure to an Interbase/Firebird SQL server? I picked up a project that I hadn't touched in a few months and discovered that the Firebird database adaptor I had been using seems to have fallen on the way side. (ZFirebirdDA): http://www.zope.org/Members/philh/ZFireBirdDA_news So, I found KinterbasdbDA which seems to work fine except for this error when I try a simple stored procedure: Error, kinterbasdb.ProgrammingError: (-104, 'execute.isc_dsql_prepare: Dynamic SQL Error. SQL error code = -104. Token unknown - line 1, char 19. execute. ') Herecallingquery callin the SP: EXECUTE PROCEDURE SP_CDR_DELETE ('12/12/2002','12/13/2002'); Anyone see what I am doing wrong? Thanks, Derek Basch __________________________________________________ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com

1 0