- Zope - Zope lists

Using ZOracleDA in external methods
by Nemeth Miklos 15 Jan '00

15 Jan '00

In my application I need to call PL/SQL stored procedures returning data in their OUT arguments. Z SQL methods do not support OUT or IN/OUT arguments. I'd like to call DCOracle methods directly, but I need the very connection object allocated by the ZOracleDA object for the application thread. The majority of database manipulation tasks are done by Z SQL methods, and my external functions (calling these stored procedures) have to share the transaction context. How to get the connection object of the application thread from a ZOracleDA object? I browsed the source code but I am not trained enough to figure out myself. NM

1 0

Re: [Zope] Arguments to DTML methods
by J C Lawrence 15 Jan '00

15 Jan '00

On Fri, 14 Jan 2000 17:05:45 -0800 J C Lawrence <claw(a)kanga.nu> wrote: > On Fri, 14 Jan 2000 16:24:48 -0500 Michel Pelletier > <michel(a)digicool.com> wrote: BTW _.None gave me problems in the DTML method trying to get to the ZCLass' property sheet. I found the following much happier: <dtml-var "dtml-method(_, PARENTS[0], uncle='bob')"> so that the called method got it's parent's property sheet. > Ahh, does that mean that I can reliably do the following: > <dtml-in zsql_method> > <dtml-var dtml_method_x((_, _.None, bob='uncle')> > </dtml-in> If so I haven't been able to make it work blast it. It looks like I should be able to use aq_explicit ala: <dtml-in zsql_method> <dtml-var dtml_method_x(aq_explicit, _.None, bob='uncle')> </dtml-in> but that raises access violations on _.None (least that's where I think they're coming from). I'm getting a little lost here. Ideas? -- J C Lawrence Home: claw(a)kanga.nu ----------(*) Other: coder(a)kanga.nu --=| A man is as sane as he is dangerous to his environment |=--

1 0

Epoch time use
by Jerry 15 Jan '00

15 Jan '00

I should have mentioned : <stml-var ZopeTime> There have been several messages re. to this topic, timezone issues, and GMT (Greenwich Mean Time) in the last few days. Scan up the list to get some ideas. Even though the title doesn't seem related, some of the "REQUEST.set not incrementing" messages have ZopeTime examples. Later, Jerry S.

1 0

RE: [Zope] Organizing Zope Content
by Maik Roeder 15 Jan '00

15 Jan '00

Hi James ! > Neither the Issue or Article will know about how the article is to > ultimately be formatted (actually the article contains minimal HTML > formatting, but these objects don't know whether they will be contained in > tables, frames, etc.) You have a Model which contains the domain objects issue and article. These two domain objects just maintain the problem related information. > Outside of the content hierarchy would be one or more objects (Folders, > currently) which define the various "pages" of the newsmagazine. Currently > I have a "HomePage" which displays an abbreviated version of the "top > story" along with ads and other bits of information. I also have a > "CurrentIssue" page which displays a list of all headlines available in the > current issue. Finally I have a "NewsPage" which defines the layout of the > actual news pages. You have three different views which render the Model to a Screen presentation. > To display a particular news story, a URL similar to the following is used: > > http://foobar.news.com/SiteRoot/20001001/1/NewsPage > Via acquisition, the NewsPage folder would be able to get story information > from both the Article object itself (1) and the Issue object > (20001001). To look at a different article, simply use a different article > number. To view a different issue, use a different issue name. The mechanism by which your Views access the information in the domain objects is by Aquisition. > I had been thinking the opposite way where I would want to tell the > NewsPage for example to display a particular page. > In a traditional web site, the URL might have looked like this: > > http://foobar.news.com/NewsPage?issue=20001001&article=1 You can also base your views on Catalog searches. This way, the Catalog would provide you with the objects, and you neither have to explicitly create the aquisition path, nor do you have complicated URLs like they are used on traditional web sites. You just have an URL like: http://foobar.news.com/NewsPage http://foobar.news.com/HomePage http://foobar.news.com/IssuePage I add some suggestions how the views could look, but I must say that these are just simple ideas and that the code is untested. I just want to get the idea across. NewsPage view: <dtml-in "Catalog( meta_type=Article, issue=20001001, article=1)"> <a href="<dtml-var "Catalog.getpath(data_record_id_)">"> </dtml-in> Homepage_View <dtml-in "Catalog( meta_type=Article, issue=20001001)"> <dtml-if top_story==1> <a href="<dtml-var "Catalog.getpath(data_record_id_)">"> </dtml-if> </dtml-in> IssuePage <dtml-in "Catalog( meta_type=Article, issue=20001001)"> <a href="<dtml-var "Catalog.getpath(data_record_id_)">"> </dtml-in> > I've been playing around with my new scheme for a little bit and so far I > like it. Of course I still have a lot more to learn about coding in DTML > but I think I've got a structure which will support what I want to do. Or > so I hope. > > Comments and feedback are welcome. You have only talked about Views and Objects, and not about Controllers. Where do you place the Data Management Object ? How do writers add articles and edit them ? Views don't change objects, they just display them, and objects don't know what to do with themselves. Greetings, Maik Röder

1 0

Epoch time use
by Jerry.Spicklemire＠IFLYATA.COM 15 Jan '00

15 Jan '00

Actually, it doesn't work that way at all. I must have repressed the hours it took to verify that you can't use a fmt=XXX in REQUEST.set. You can do this, however : It is now <dtml-var "_.DateTime()" fmt="AMPM">. BTW, see http://lists.zope.org/pipermail/zope/1999-September/009657.html Later, Jerry S.

2 1

Re: [Zope] Arguments to DTML methods
by J C Lawrence 15 Jan '00

15 Jan '00

On Fri, 14 Jan 2000 16:24:48 -0500 Michel Pelletier <michel(a)digicool.com> wrote: > <dtml-var "aMethod(aMappingObject, aClient, arg1, arg2...)"> > 'aMappingObject' is a mapping containing the current 'namespace', > or the namespace you want this method to use. This is often '_' > (the current DTML namespace) > 'aClient' is an object you want to provide the namespace for this > method. This is often '_.None' (no client object) Ahh, does that mean that I can reliably do the following: <dtml-in zsql_method> <dtml-var dtml_method_x((_, _.None, bob='uncle')> </dtml-in> or to be a little more explicit and define the requested namespace: <dtml-in zsql_method> <dtml-var dtml_method_x((_, id, bob='uncle')> </dtml-in> So that dtml_method_x acquires the namespace added by the zsql_method, and thus access to the current row pulled from the DB? -- J C Lawrence Home: claw(a)kanga.nu ----------(*) Other: coder(a)kanga.nu --=| A man is as sane as he is dangerous to his environment |=--

1 0

Re: [Zope] Image sizing
by J C Lawrence 15 Jan '00

15 Jan '00

On Fri, 14 Jan 2000 17:47:37 -0500 Gregor <vorlon(a)iglou.com> wrote: > ----- Original Message ----- From: Jeff K. Hoffman > <jeff(a)goingv.com> >>> Given an image object (such as the perrenial single pixel >>> invisible GIF oft used in tables) > People still use that? Blech. I agree. I'm just not aware of another method of reliably (across browsers) forcing a minimum table width without putting visible data there. -- J C Lawrence Home: claw(a)kanga.nu ----------(*) Other: coder(a)kanga.nu --=| A man is as sane as he is dangerous to his environment |=--

1 0

RE: [Zope] Very important for CatalogWare zopists
by Brian Lloyd 15 Jan '00

15 Jan '00

> I have submitted this to the Collector and it is major for people who > have items in their ZODB that are Catalog aware. > > To create the bug follow these steps: > > 1.Create a Catalog Aware ZClass > 2.Create an instance of that class > 3.Make sure it is indexed by looking in the Catalog "Catolaged items" > tab > 4.Notice that there is *no* slash in front of the indexed url: > "MyFolder/myobject" > 5.Now clear the Catalog > 6.Go to the "Find Items to Catalog" > 7.Select just your New ZClass meta type so it is quick > 8.Click "Find" > 9.Make sure it is indexed by looking in the Catalog "Catolaged items" > tab > 10. Oh no! It has a different url. A leading slash! > "/MyFolder/myobject" > 11. Click on the link. It's broken! Hi Jason - these steps are equivalent to what is currently done on Zope.org (which is running on a checkout equivalent to 2.1.2), and this does not seem to be a problem there. While I won't totally rule out the possibility of something in Zope, the fact that we don't see this behavior seems to suggest that there might be something going awry in your particular ZClasses. In particular, I'd look for some difference in the way that it registers itself with the catalog at the time that it is created versus when it is "found" by the catalog. The difference could be a difference in either behavior, state or environment (i.e. is the acquisition context, etc. the same in both cases when the "absolute_url" method gets called to generate the url for the catalog? Is there any custom code around this logic?). The object constructor is a good place to start looking for this sort of thing - try to trace through the activity in the constructor versus what happens when the existing object is "found" by the catalog. If possible, try to see what the value of the url given to the catalog is what you expected it to be... > What this means is that if you have a lot of items in you > Catalog don't > ever ever ever use the "Find" machinery until Digital fixes this(It > worked in 2.0.0 Final). You will end up not being able to > edit/reindex > your objects, and the links in your applications may not > function. I have not heard any other reports of a problem like this, so until we can verify that it is a Zope problem I think that this is a little strong. If other Zopistas can reproduce this I would certainly like to hear about it though. Brian Lloyd brian(a)digicool.com Product Manager 540.371.6909 Digital Creations http://www.digicool.com

2 1

Image Property?
by Markus Strickler 15 Jan '00

15 Jan '00

Hi! I have a ZClass and want to add a property that references an image object. I tried to add a string property that contains the ID of the image but I couldn't come up with a way to reference the image in my view method. All the images are in the folder /images/ The image IDs have to contain suffixes (.jpg, .gif, etc). I'm pretty sure this can be done but just can't find a way how to. Can anyone help? Markus

1 0

Refer to sequence-index within SQLmethod?
by Jerry.Spicklemire＠IFLYATA.COM 14 Jan '00

14 Jan '00

Hi again, Perhaps if I get in the habit of adding more detail in the first message, a higher number of Zenful types will feel they have enough information to hazard a guess. Better late than never, so here's a sample of the code in the SQL Query Template Edit Box : update user_login_table set unique_row_id = <dtml-sqlvar "_.string.zfill(_.str(_.int('sequence-index')),9)" type=nb> and, here are even more ways to try adding a "sequence-item" argument into the ZSQLmethod Edit Window that don't work : _.getitem(sequence-index) , "_.getitem(sequence-index)" , expr=_.getitem(sequence-index) , expr="_.getitem(sequence-index)" , and, "expr=_.getitem(sequence-index) BTW, the question is bound to come up, as in, "Why in the name of Zope do you need to do this?" Wouldn't the world would be a lovely place if every table that any Desktop Database user had ever misconceived included a Record ID? Alas no. The shameful truth is, all I'm really trying to do is stuff a string that's predictably exclusive into each row, so that I can comfortably fall back into my bad old habits from dBase days, and easily retrieve single records for processing . . . Thanks for any clues! Jerry S.

2 1