- Zope - Zope lists

Re: [Zope] ZOracleDA Null Columns and Authorisation
by Anthony Baxter 29 Jul '99

29 Jul '99

>>> Neill Cox wrote > Also I get occasional errors from Zope when executing my Oracle queries. > Could this be a problem of the ZOracleDA not being compatible with Zope > b1? Is anybody else using Oracle with b1? What are your experiences? Hi there, See the recent discussions on this - eg, Chris Petrilli's post yesterday pointing at http://www.zope.org/Download/DAStatus I've played with ZOracleDA a small amount with my Zope2 test installation, and rapidly decided it just wasn't worth the pain. For now my Zope2 test installation is DA-less, and all DB work is on my good ol' hacked-to-within- an-inch-of-it's-life 1.10.3ish installation. (It's 1.10.3, with various patches from CVS back-ported when I needed the fix/feature). Is anyone planning to do the magic for ZSybaseDA? I know DC have a Sybase DA that they're not releasing, but what about the free one? Anthony

1 0

RE: [Zope] paramters to sql methods have to be in REQUEST????
by Brian Lloyd 29 Jul '99

29 Jul '99

> > "Jay, Dylan" wrote: > > > > > > Why is it that > > > > > >  > > >  > > >  > > > > > > doen't work and > > > > > >  > > >  > > > does?????? > > > > > > Is this a bug? If so can it be fixed as it is annoying. Two things to note here: first, if you have defined 'MatchPattern' in the 'arguments' list of the SQLMethod, you can pass it directly as a keyword argument:  The reason that SQLMethods don't respect the entire namespace is mostly to prevent unintended things from happenning (by the SQL Method picking up and using a name from the namespace that you really didn't intend for it to use). SQLMethods _intentionally_ force you to be a little more explicit about what variables can be used in them - more so than DTML Methods/Documents, because if you have a variable collision in DTML, no real harm is done. At worst, the client sees a rendered document that doesn't make much sense. For SQLMethods the consequences of such a thing are are a bit worse, since you could end up inserting bad data into your database... Hope this helps! Brian Lloyd brian(a)digicool.com Software Engineer 540.371.6909 Digital Creations http://www.digicool.com

1 0

ZOracleDA Null Columns and Authorisation
by Neill Cox 29 Jul '99

29 Jul '99

I've done some more investigation of my original problem and my troubles are definitely related to null values. It seems that Zope is insisting on authentication if any of the values returned from a query are null. If I wrap the possibly null columns in an nvl function they work fine. I notice that there have been several other threads relating to Zope b1 and null objects and anuthentication problems. Perhaps this is another example. Also I get occasional errors from Zope when executing my Oracle queries. Could this be a problem of the ZOracleDA not being compatible with Zope b1? Is anybody else using Oracle with b1? What are your experiences? Any light that you Zope experts could shed on this would be very welcome. I have several projects that I would like to use Zope for, but its hard to push them forward with these kind of unsolved problems hanging over them. I know it's only _beta_ software, but its such _wonderful_ beta software. Cheers, Neill +---------------------------------------------------------------------+ | Neill Cox | | Ingenious Software Pty Ltd Phone : +61 2 6258 4858 | | 35 Carlile St Fax : +61 2 6258 5737 | | Evatt ACT 2617 AUSTRALIA | +---------------------------------------------------------------------+

1 0

RE: [Zope] wrong value for integer variable?
by Michel Pelletier 29 Jul '99

29 Jul '99

> -----Original Message----- > From: Donald Holten [mailto:donner@biophysics.lanl.gov] > Sent: Wednesday, July 28, 1999 4:14 PM > To: michel(a)digicool.com > Cc: zope(a)zope.org > Subject: RE: [Zope] wrong value for integer variable? > > > Something very interesting... I changed the code as > you said, and, as I > sort of figured, it didn't work (only because I saw that > python has no way to > convert strings to ints). Sure it does, int(). In DTML, you can access this via the _ namespace, ie. <dtml-if "_.int('1') == 1"> Hey, it works! </dtml-if> -Michel

4 5

importing data to mysql from zope
by ainis 29 Jul '99

29 Jul '99

Well, it's easy to pass variables to ZSQL Methods and create new records in this way in database. The question is: Is there any way to pass whole data files to be imported to the database? I know "LOAD DATA bla bla bla" stuff but this is done from the mysql client. The whole point would be doing this from browser. Any ideas?

1 0

'creating' a variable from sequence-item
by Tony McDonald 29 Jul '99

29 Jul '99

Hi, I've got a page where 'n' radio button sets are displayed and the use has to select a correct answer from each of the groups. Dumping the data out is easy: (questions is a lines property with a single entry 'Is the sky blue?' type question. Note the last piece to tell the form how many questions where on the screen. Answers please::<br> <dtml-in questions> <dtml-var sequence-item>:: <input type=radio name=answer<dtml-var sequence-index> value="1"> (true) <input type=radio name=answer<dtml-var sequence-index> value="-1"> (false) <input type=radio name=answer<dtml-var sequence-index> value="0" checked> (dunno) <br> <dtml-if sequence-end> <input type=hidden name=numquestions:int value=<dtml-var sequence-index>> </dtml-if> </dtml-in> Notes: 1) checked means the radio button is set, that stops problems with variables such as 'answern' not being defined. Pedagogically, it's an open call whether you should assume the student doesn't know to begin with :) 2) numquestions:int stops problems with the numquestions+1 code a bit later on. Processing them is easy *if* I don't mind what order the keys are displayed in... <dtml-in "REQUEST.form.items()"> <dtml-var sequence-key> : <dtml-var sequence-item><BR> </dtml-in> Notes: Pretty standard stuff. form is a dictionary containing all the variables in the form (ie REQUEST.form.['answer2'] will get that value). unfortunately, I do mind, so I have to do some hairy hoop jumping... <dtml-in "_.range(0, numquestions+1)"> Variable Name: answer<dtml-var sequence-index>, Composed Variable Name=<dtml-var "_.string.join(('answer', _.str(_['sequence-index'])),'')">, Value of Composed Variable Name: <dtml-var "_[_.string.join(('answer', _.str(_['sequence-index'])),'')]"><br> </dtml-in> Notes: 1) _range(0, numquestions+1) is in Zope 2 and acts like the Python range command, except it's got some error checking. 2) _.str(['sequence-index']) is needed to convert sequence-index into a string so that string.join can do its work (the delimiter is '' so it's a standard join). 3) the _[] part is to 'lookup' the Composed Variable name in the namespace. yikes! I *must* be doing something dumb here :) Any thoughts on doing it better? cheers tone. ------ Dr Tony McDonald, FMCC, Networked Learning Environments Project http://nle.ncl.ac.uk/ The Medical School, Newcastle University Tel: +44 191 222 5888 Fingerprint: 3450 876D FA41 B926 D3DD F8C3 F2D0 C3B9 8B38 18A2

2 2

RE: [Zope] paramters to sql methods have to be in REQUEST????
by Jay, Dylan 29 Jul '99

29 Jul '99

> -----Original Message----- > From: Michel Pelletier [mailto:michel@digicool.com] > Sent: Thursday, July 29, 1999 16:30 > To: Jay, Dylan > Cc: 'zope(a)zope.org' > Subject: Re: [Zope] paramters to sql methods have to be in REQUEST???? > > > "Jay, Dylan" wrote: > > > > Why is it that > > > >  > >  > >  > > > > doen't work and > > > >  > >  > > does?????? > > > > Is this a bug? If so can it be fixed as it is annoying. > > This is not a bug. ZSQL methods take keyword arguments, or snif > REQUEST, but do not sniff the namespace. This is because the > namespace > could be huge. But how is that any different from inside a DTML method. The namespace is huge there too. > Try: > >

1 0

paramters to sql methods have to be in REQUEST????
by Jay, Dylan 29 Jul '99

29 Jul '99

Why is it that    doen't work and   does?????? Is this a bug? If so can it be fixed as it is annoying.

2 1

more on SQL tree structures.
by Anthony Baxter 29 Jul '99

29 Jul '99

I've got a db table that's essentially storing a tree of objects - ( obj_id int, parent_id int, name varchar ) I've got this working with the #tree display fine, with the help of the previous discussions on zope-list (thank god I index my mail spool) The next question is a bit trickier - Given an obj_id, I want to display (in zope) the list of parent_ids of it back to the root object - any ideas on the best way to do this loop? I can always just do it in an external method, but this seems like cheating to me. Anthony

1 0

Oops--ZServer on Port 80
by Mike Owens 29 Jul '99

29 Jul '99

OK false alarm. It turns out that I had ftp on port 21 going and when I tried the -P option it conflicted.

1 0