- Zope - Zope lists

RE: [Zope] mySQL and Zope and multiple databases
by Schmidt, Allen J. 07 Aug '01

07 Aug '01

Yes, this is what I mean. I can do it from the mySQL admin tool just fine. I will look into external methods then. Thanks! -----Original Message----- From: Eric Walstad [mailto:eric@walstads.net] Sent: Tuesday, August 07, 2001 1:35 PM To: Schmidt, Allen J.; Zope mailing list Subject: RE: [Zope] mySQL and Zope and multiple databases Allen, I just reread your message and I think misunderstood it the first time. The link I sent before describes querying two databases, not querying against two MySQL Database connections in one ZSQL method... This kind of query could be run from an external method that queries the two databases and returns the result set to Zope, tho. I think that would do what you need. As each ZSQL method has one database connection property, I'm not sure how, or if, you could specify using two database connections in one ZSQL method. Eric. > -----Original Message----- > From: zope-admin(a)zope.org [mailto:zope-admin@zope.org]On Behalf Of Eric > Walstad > Sent: Tuesday, August 07, 2001 10:19 AM > To: Schmidt, Allen J.; Zope mailing list > Subject: RE: [Zope] mySQL and Zope and multiple databases > > > Hi Allen, > I haven't done it myself, but I may need to before long. :) So, > I just did > a quick Google search and found: > http://www.ultraviolet.org/mail-archives/mysql.1999/0323.html > I'd be interested to hear if this works for you. > Eric. > > > -----Original Message----- > > From: zope-admin(a)zope.org [mailto:zope-admin@zope.org]On Behalf Of > > Schmidt, Allen J. > > Sent: Tuesday, August 07, 2001 5:26 AM > > To: Zope mailing list > > Subject: [Zope] mySQL and Zope and multiple databases > > > > > > We are moving a bunch of stuff to mySQL. One database currently > exists and > > some of the new tables that need to be brought in have the same > > names. If I > > create a new database to house the new tables, how can I use ZSQL > > methods to > > compare fields in tables between two ZmySQL connections? > > > > Thanks > > > > _______________________________________________ > > 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

mySQL and Zope and multiple databases
by Schmidt, Allen J. 07 Aug '01

07 Aug '01

We are moving a bunch of stuff to mySQL. One database currently exists and some of the new tables that need to be brought in have the same names. If I create a new database to house the new tables, how can I use ZSQL methods to compare fields in tables between two ZmySQL connections? Thanks

2 2

Upper atribute and special caracters
by Alexandre Aguiar 07 Aug '01

07 Aug '01

Im trying to use the 'upper' atribute transform variables that contains special caracters like the example: textVar = "São Paulo" <dtml-var textVar upper> # And it returns SãO PAULO Is there something that I can do to fix it?? Thanks one more time for the help!

2 1

RE: [Zope] Building a page from multiple paramatised queries
by Farrell, Troy 07 Aug '01

07 Aug '01

A few bits of advice for you: 1) Never use an SQL key of ID with Zope. It could lead to a namespace collision, as id is a zope term referring to an objects id. You probably haven't had a problem _yet_, as ZSQL methods use the REQUEST namespace almost (there are some unusual instances) exclusively. I usually prefix it with something like "sql_" so I get "sql_Id". 2) To get SQL data from REQUEST explicitly, use <dtml-var expr="REQUEST.sql_variable_name"> (or is it <dtml-var expr="REQUEST.sql_variable_name()">) Try something like this: ### FeatureDetail ### <dtml-var name="standard_html_header"> <dtml-in name="FeatureDetailQuery"> <h1><dtml-var name="Name"></h1> <dtml-in name="Query2"> <p> <dtml-var name="bosco"> </p> </dtml-in> </dtml-in> ### FeatureDetailQuery ### SELECT * FROM Feature WHERE <dtml-sqltest sql_Id op="eq" type="int"> ### Query2 ### SELECT bosco FROM Fishsticks WHERE <dtml-sqltest sql_Id op="eq" type="int"> Note also that in my above FeatureDetail, if FeatureDetailQuery returns more than one row of data, you will get something like: <h1>SOme name</h1> <p> Stuff </p> <h1>Some other name</h1> <p> More stuff </p> Troy -----Original Message----- From: Giles Chamberlin [mailto:GChamberlin@Ridgeway-Sys.com] Sent: Tuesday, August 07, 2001 6:06 AM To: 'zope(a)zope.org' Subject: [Zope] Building a page from multiple paramatised queries I'm a zope novice so I'm probably missing something obvious. My intent is to build a web page from the results of two queries, each of which are paramatised by the same value. I've got a single query working fine: FeatureDetailQuery has a parameter ID and SQL: select * from Feature where <dtml-sqltest Id op=eq type=int> FeatureDetail is a simple web page: <dtml-var standard_html_header> <h1><dtml-var Name></h1> <dtml-var standard_html_footer> and I bind the two together by referencing them with the a href = FeatureDetailQuery/Id/<dtml-var Id>/FeatureDetail All's well. My problem is that I want to add the output of another query, also parametised by Id to the same web page and I'm stumped as to how to go about it. Any suggestions? Giles Chamberlin

1 0

RE: [Zope] SSL + ProxyPass + Zope question...
by Stephan Goeldi 07 Aug '01

07 Aug '01

>This is untested, but something like this might do what you want: > ><dtml-if expr="_.string.find(URL, '/manage') > -1"> ><dtml-call "RESPONSE.redirect('https:' + URL[5:])"> ><dtml-return "'REDIRECTING.. to secure port.. '"> ></dtml-if> Looks interesting. Where do I have to put it? _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

2 1

RE: [Zope] Cataloging AND (indexing OR meta data)
by sean.upton＠uniontrib.com 07 Aug '01

07 Aug '01

Since ZCatalog objects are 'dumb' and don't have direct access to the objects they have indexed, and it would be nice to have some of the data from those objects for search results pages somehow, we need some way of getting that data. Metadata is essentially a cache of that data (or a copy, that is) that is used for constructing result lists. You should only put fieldnames for properties containing summary data in the meta data tabs. An alternative to using metadata in Zope 2.3+ is using Catalog.getObject() which will return the object in each iteration; I currently do this in one of my applications because I have had problems using metadata on some fields (likely because I was doing it wrong). There is a big performance penalty for going about it this way, though, as you have to traverse the ODB to each object to get data for each line in your result list. Eventually, once I get it working right, I will switch this over to using metadata instead, which might increase re-indexing time, but increase result list performance since I eliminate the need for getObject()... Sean -----Original Message----- From: Peter Bengtsson [mailto:mail@peterbe.com] Sent: Tuesday, August 07, 2001 9:18 AM To: zope(a)zope.org Subject: [Zope] Cataloging AND (indexing OR meta data) I've got a bunch of objects that I catalog. I have added a few properties to the Indexes which makes it possible for me now to search on these properties. Everything is jolly! However, I honestly don't understand the Meta data tab. All I can practically do there is add names of properties and that already works spendid with the Indexes. Anybody got a clear explaination for ZCatalog-dummy on this one? PS. I read the Zope Book chapter on meta data but despite that I still didn't get it. Hopefully I've just lost a very important small piece of knowledge that is needed. Cheers, all _______________________________________________ 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

RE: [Zope] My first silly Question
by Farrell, Troy 07 Aug '01

07 Aug '01

Urk? I'm not sure we understand. I think you have something like this: folder1/folder2/folder3/folder4/page5 and a DTML Method at folder1/method2. If you want to show page5 in content 2, you need to do <dtml-var expr="folder2.folder3.folder4.page5(_.None, _)"> in the source for content 2. If that's not what you need, please clarify. Thanks. Troy -----Original Message----- From: Aruna Prabhakaran [mailto:aruna_prabhakaran@hotmail.com] Sent: Tuesday, August 07, 2001 6:19 AM To: zope(a)zope.org Subject: [Zope] My first silly Question HI, Thanks a lot for the reply.Now I know I am "in" :-) I have encountered a situation wherein I need to access a document located in a really far flung folder .I also need to build a URL to it so that I can jump to it from my present location. pls help Aruna Prabhakaran ZeOmega Infotech Pvt Ltd Bangalore India.

1 0

Virtual Site Hosting
by mixo 07 Aug '01

07 Aug '01

I have created a folder called "test1' through the management interface., which I can access by typing "lynx http://myhost:11011/test1". In my "httpd.conf" I have ++++++++++++++++++++++++++++++++++++++++++++++++++ <VirtualHost 192.168.1.1> DocumentRoot /var/www/html <IfModule mod_rewrite.c> RewriteEngine On RewriteLog "/var/log/httpd/rewrite_log" RewriteLogLevel 0 RewriteRule ^/local/ - [L] RewriteRule ^/(.*) http://myhost:11011/test1/$1 [P] </IfModule> </VirtualHost> +++++++++++++++++++++++++++++++++++++++++++++++++ Whenever I try to acces "192.168.1.1" I get the following error in my log file: ++++++++++++++++++++++++++++++++++++++++++++++++++++ [Tue Aug 7 15:33:18 2001] [error] [client 192.168.1.1] attempt to make remote request from mod_rewrite without proxy enabled: proxy:http://rmyhost:11011/test1/ ++++++++++++++++++++++++++++++++++++++++++++++++++++ And I get the following through a browser: ++++++++++++++++++++++++++++++++++++++++++++++++++++ 403 Forbidden Forbidden You don't have permission to access / on this server. _________________________________________________________________ ++++++++++++++++++++++++++++++++++++++++++++++++++++ What can I do to get around this? Mixo Shiburi P.S I am running Zope 2.5-6 and Apache 1.3-19 on Redhat linux 7.1 (kernel 2.4.x)

2 1

Cataloging AND (indexing OR meta data)
by Peter Bengtsson 07 Aug '01

07 Aug '01

I've got a bunch of objects that I catalog. I have added a few properties to the Indexes which makes it possible for me now to search on these properties. Everything is jolly! However, I honestly don't understand the Meta data tab. All I can practically do there is add names of properties and that already works spendid with the Indexes. Anybody got a clear explaination for ZCatalog-dummy on this one? PS. I read the Zope Book chapter on meta data but despite that I still didn't get it. Hopefully I've just lost a very important small piece of knowledge that is needed. Cheers, all

1 0

RE: [Zope] ping
by Farrell, Troy 07 Aug '01

07 Aug '01

Would you like spam (tm) with that? -----Original Message----- From: Chris Withers [mailto:chrisw@nipltd.com] Sent: Tuesday, August 07, 2001 10:56 AM To: Phil Harris Cc: zope(a)zope.org Subject: Re: [Zope] ping No (tm)

1 0