- Zope - Zope lists

dcoracle
by Adam Gotheridge 29 Dec '99

29 Dec '99

I can't find a single example how to use the dcoracle package and can't figure it out. The documentation says: Connect(connection_string) Constructor for creating a connection to the database. Returns a Connection Object. This looks fine and returns a connection object with dbc = oci_.Connect('scott/tiger@thunder') The docs describing connection object includes: cursor() Return a new Cursor Object. An exception may be thrown if the database does not support a cursor concept. I can't get this to work and don't know why. Code looks like: #!/usr/bin/python import sys sys.path.append('/usr/local/zope/Zope-2.0.1-linux2-x86/lib/python/Products/Z OracleDA/DCOracle') import Buffer, oci_ dbc = oci_.Connect('scott/tiger@thunder') cursor = dbc.cursor() error returned is: AttributeError: 'Connection' object has no attribute 'cursor' Can anyone post a simple example of how to connect and return a recordset? Thanks

3 2

dcoracle
by Adam Gotheridge 29 Dec '99

29 Dec '99

The text document at http://www.zope.org/Products/DCOracle/DCOracle.txt describes features of the product including transaction management and cursor/procedure use. How do I work this in zope? Is there a simple example somewhere? Thanks

2 1

RealServer and Zope
by Andrew Lahser 29 Dec '99

29 Dec '99

Does anyone have any experience integrating RealServer and Zope? Would they mind sharing? I am about to take on my first RealServer experiment and a few encoraging words would be great. Drew.

2 1

Annoying "This is not a Query" message
by Timothy Grant 29 Dec '99

29 Dec '99

Hi all, I thought that I had seen this mentioned before, but I can't find it in the archives, so I will ask again: Is there something that can be done to get rid of the really annoying and misleading "This is not a Query" message that comes up when you test a SQLMethod that does not return any rows (e.g., UPDATE or DEL queries) I spent a bunch of time chasing this error before I finally realized that my Queries were executing, I was just being given a spurious error. -- Stand Fast, tjg. Chief Technology Officer tjg(a)exceptionalminds.com Red Hat Certified Engineer www.exceptionalminds.com Avalon Technology Group, Inc. (503) 246-3630 >>>>>>>>>>>>EXCEPTIONAL MINDS, INNOVATIVE PRODUCTS<<<<<<<<<<<<

2 1

Tree tag to show only objects that evaluate from a expression
by Jason Spisak 29 Dec '99

29 Dec '99

Zopists, I am studying the documentation on the tre tag and looking at the source, and I'm not sure how to get this to work. I am using <dtml-tree expr="PARENTS[1]"> to get the tree tag of a folder above the current folder. I would like to only display the tree of objects in that folder that met a certain criteria. I have tried branches_expr=objectValues(etc...), but I need it to display only the tree of a few of that particular meta_type if they qualify, not all of them. Any ideas? Gradually wrangling the beast, -- Jason Spisak webmaster(a)hiretechs.com

1 0

MySQL?
by Don Undeen 29 Dec '99

29 Dec '99

More tutes please! Hello, I just started dealing with Zope, so You'll be seeing a lot of me here. I've been building a site with php and Mysql, and am now thinking of moving it over to Zope. I have some questions about setting this up. I've got the MySQL server running on another machine that I administer. I'd like to just install the MySQL client on the Zope machine, ans leave the database where it is. Php was nice, because it had MySQL support built in. Now I have to install some modules (or are they called products? I'm having trouble with the semantics) to get Zope to talk to MySQL, right? I've seen a couple different modules that say "MySQL (or mySQL)," and I don't know what modules I need, or how they have to be set up to talk to a MySQL server on another machine. Are there folks out there writing tutorials for just this sort of thing? It seems like the sort of thing that Zope is made for (big site mangaement with databases, all opensource code) If I could see some examples, it would help me along nicely towards groking this whole thing. Do these questions mean I'm not ready for Zope yet? BTW- I kinda like my php pages, is there a way to integarate them with the Zope system? That would be killer. Thanks and I look forward to your responses, Don Undeen zope(a)thechairs.net

2 1

Tree tag of a specific object
by Jason Spisak 29 Dec '99

29 Dec '99

Zopsters, I'd like to get the tree of a specific object. The ids of the objects are stored in a tokens property. <dtml-in tokens> <dtml-tree expr="_.getitem(_['sequence-item'])" branches_expr="objectValues(['DTML Method', 'DTML Document', 'Folder'])"> <a href="<dtml-var tree-item-url>" target="_parent"> <img src="<dtml-var icon>" border="0"><font size="-1"> <dtml-var title_or_id>></font></a> </dtml-tree> </dtml-in> If fails because it cannot get past the '_' in the expr portion of the tree tag. Any ideas? -- Jason Spisak webmaster(a)hiretechs.com

1 0

How to search for empty properties in ZCatalog - nifty solution
by Itamar Shtull-Trauring 29 Dec '99

29 Dec '99

The following python method returns a list of all the empty properties in the ZClass it's a method of. Add it as a KeywordIndex to your ZCatalog, and you can search for empty properties easily. For example, if you want to find all object where 'title' is empty, use: <dtml-in "catalog({'emptyProperties' : 'title'})"> ... </dtml-in> ================================================================ # ** function name: emptyProperties # ** parameters: self ## Return list of all empty properties in our propertysheets ## emptyproperties = [] #empty properties propertysheets = self.propertysheets.items() i = 0 for sheetname in propertysheets: sheetname = sheetname[0] if sheetname == 'webdav': i = i + 1 continue psheet = self.propertysheets[i] validprops = [] for pmap in psheet.propertyMap(): if pmap['type'] in ['string', 'text']: validprops.append(pmap['id']) for pname, pcontent in psheet.propertyItems(): if (pname in validprops) and (not pcontent): emptyproperties.append(pname) i = i +1 return emptyproperties

1 0

Zope and Xitami Web Server
by Glenn Williams 29 Dec '99

29 Dec '99

Hi Everybody, Does anybody have any experience on setting up iMatix Corporation's Xitami Web Server for use with Zope? They have a Long Running Process protocal similar to FastCGI. TIA, Glenn Advanced Decisions Inc. Running S.u.S.E. Linux 6.2 with KDE ____________________________________________________________________ Get your own FREE, personal Netscape WebMail account today at http://webmail.netscape.com.

1 0

Filling in forms and searching for data
by Timothy Grant 29 Dec '99

29 Dec '99

Hi all, Just wondering about a couple of issues. I have a form that contains a bunch of blanks. If I fill in that form and click "Add" the entry is added to my PostgreSQL database. If I have existing data in the form and click "Update" the record in my DB is updated. I'm trying to come up with a good Search mechanism. So far this is what I have: If I fill out part of the form and click "Search", I get a list of all matching records returned to me in a nice table. the first column of the table has a radio button and there is an "I Choose You..." button at the bottom of the list. I would like to take the record that the user indicated through use of the radio button and place it back in my Original form. I have come up with two possibilities for this and was wondering which might be the better choice. Possibility 1: I can build a series of lists for each column returned by the query, pass that list back to the originating form, index that list based on the value of the index of my radio button and fill in the blanks. (It actually works quite well) Possibility 2: I can pass back the radio button index to my form, and re-run the SQLQuery then select the appropriate row based on the index in fill in the blanks (I haven't tried this yet) For some reason I like the first better than the second, though something tells me I am needlessly sucking RAM to build a bunch of lists for which I only need one item. It seems that going back to disk for the second query is equally bad. Does anyone have a better suggestion? -- Stand Fast, tjg. Chief Technology Officer tjg(a)exceptionalminds.com Red Hat Certified Engineer www.exceptionalminds.com Avalon Technology Group, Inc. (503) 246-3630 >>>>>>>>>>>>EXCEPTIONAL MINDS, INNOVATIVE PRODUCTS<<<<<<<<<<<<

2 1