July 1999 - Zope - Zope lists

RE: [Zope] Writing to SQL Databases
by Michel Pelletier 19 Jul '99

19 Jul '99

> -----Original Message----- > From: Ross J. Reedstrom [mailto:reedstrm@wallace.ece.rice.edu] > Sent: Monday, July 19, 1999 2:07 PM > To: Sean McMains > Cc: 'zope(a)zope.org' > Subject: Re: [Zope] Writing to SQL Databases > > > >  > This will work if quoted. > or perhaps > >  This will not work, a) because it's not quoted and b) because ZSQL methods *do* expect the data structure DTML calls 'REQUEST' but ZSQL methods call it 'request'. Although many Zope method signatures contain 'REQUEST', some contain 'request' or 'req' but expect the same data structure. This is the danger Zone when using keyword argument. In the case of ZSQL methods, it's 'request=REQUEST'. It would probably be best to stick with your first example, quoted. -Michel > > should do it. > > Ross > -- > Ross J. Reedstrom, Ph.D., <reedstrm(a)rice.edu> > NSBRI Research Scientist/Programmer > Computer and Information Technology Institute > Rice University, 6100 S. Main St., Houston, TX 77005 > > _______________________________________________ > Zope maillist - Zope(a)zope.org > http://www.zope.org/mailman/listinfo/zope > > (For developer-specific issues, use the companion list, > zope-dev(a)zope.org - http://www.zope.org/mailman/listinfo/zope-dev ) >

2 1

Re: [Zope] passing an URL from Apache to ZServer
by O.l.i.v.e.r T.h.u.n.s 19 Jul '99

19 Jul '99

>I'm not sure of the details, but this looks like it needs a rewrite and >a proxy. The Apache rewrite module works pretty well with the proxy >module to do some interesting stuff. I would look at the docs for the >rewrite model, specificly dealing with the 'R' flag. I know the proxy and rewrite module and I could do a rewrite, but this will not work. I rewrite http://sub.domain.com/path/script.cgi?var1=My&var2=Name to http://sub.domain.com:9673/redirect_module/path/script.cgi?var1=My&var2= Name but this will not work. Do you know how I could encode the original URL in the request URL for ZServer? (How could I pass the URL to the ZPublisher module without getting an error?) P.S.: really quick reply :-))) >> Hi, I have a little problem and need your support :-) >> I want to do this: >> >> Apache gets a request >> http://sub.domain.com/path/script.cgi?var1=My&var2=Name >> >> Apache forwards this to ZopeHTTPServer (or ZServer) through the proxy >> module >> >> A ZPublisher module should get the URL >> (/path/script.cgi?var1=My&var2=Name) and redirect to >> http://other.domain.com/path/script.cgi?var1=My&var2=Name >> >> Is this possible? >> I think it should be possible with PCGI, but this is much more >> overhead. I'm using ZPublisher not Zope (don't need it for this >> projekt).

1 0

passing an URL from Apache to ZServer
by O.l.i.v.e.r T.h.u.n.s 19 Jul '99

19 Jul '99

Hi, I have a little problem and need your support :-) I want to do this: Apache gets a request http://sub.domain.com/path/script.cgi?var1=My&var2=Name Apache forwards this to ZopeHTTPServer (or ZServer) through the proxy module A ZPublisher module should get the URL (/path/script.cgi?var1=My&var2=Name) and redirect to http://other.domain.com/path/script.cgi?var1=My&var2=Name Is this possible? I think it should be possible with PCGI, but this is much more overhead. I'm using ZPublisher not Zope (don't need it for this projekt). Oliver

2 1

RE: [Zope] Writing to SQL Databases
by Sean McMains 19 Jul '99

19 Jul '99

Quotes? QUOTES? Q U O T E S? #Sigh#. Everything starts working wonderfully once I use quotes. I settled on this format, since it seems easiest:  Everything's easy once you know how, eh? Thanks, everyone. Sean > -----Original Message----- > From: Michel Pelletier [SMTP:michel@digicool.com] > Sent: Monday, July 19, 1999 3:40 PM > To: 'Graham Chiu'; zope(a)zope.org > Subject: RE: [Zope] Writing to SQL Databases > > > > > -----Original Message----- > > From: Graham Chiu [mailto:anon_emouse@hotmail.com] > > Sent: Monday, July 19, 1999 4:24 PM > > To: zope(a)zope.org > > Subject: Re: [Zope] Writing to SQL Databases > > > > >I don't get an error, but neither do I get the data inserted > > as it should > > >be. I've also included this code: > > > > > >Name: > > >Year: > > >E-Mail: > > > >  > > > > This will, of course, need to be quoted  > > -Michel > > > > > ------- > > Regards, Graham Chiu > > gchiu<at>compkarori.co.nz > > > > _______________________________________________ > > Zope maillist - Zope(a)zope.org > > http://www.zope.org/mailman/listinfo/zope > > > > (For developer-specific issues, use the companion list, > > zope-dev(a)zope.org - http://www.zope.org/mailman/listinfo/zope-dev ) > > > > _______________________________________________ > Zope maillist - Zope(a)zope.org > http://www.zope.org/mailman/listinfo/zope > > (For developer-specific issues, use the companion list, > zope-dev(a)zope.org - http://www.zope.org/mailman/listinfo/zope-dev )

1 0

RE: [Zope] Writing to SQL Databases
by Michel Pelletier 19 Jul '99

19 Jul '99

> -----Original Message----- > From: Graham Chiu [mailto:anon_emouse@hotmail.com] > Sent: Monday, July 19, 1999 4:24 PM > To: zope(a)zope.org > Subject: Re: [Zope] Writing to SQL Databases > > >I don't get an error, but neither do I get the data inserted > as it should > >be. I've also included this code: > > > >Name: > >Year: > >E-Mail: > >  > This will, of course, need to be quoted  -Michel > > ------- > Regards, Graham Chiu > gchiu<at>compkarori.co.nz > > _______________________________________________ > Zope maillist - Zope(a)zope.org > http://www.zope.org/mailman/listinfo/zope > > (For developer-specific issues, use the companion list, > zope-dev(a)zope.org - http://www.zope.org/mailman/listinfo/zope-dev ) >

1 0

Global Object IDs
by Jason Spisak 19 Jul '99

19 Jul '99

Alexander, I just recieved the digest of the list, and I posted a similar question about how to use a counter property in Zope 2. The old way doesn't seem to be working.  doesn't add to the counter for objects below 2 down from the root folder. Funny thing is, it used to. Is this what you use for Globally unique id's? Jason Spisak webmaster(a)mtear.com

1 0

Writing to SQL Databases
by Sean McMains 19 Jul '99

19 Jul '99

Hi folks, I've been working with Zope for a month or two now off and on, trying to figure out how to port several of my existing websites to Zope, since it will make my life much easier and more pleasant. (I really am impressed with the work you've done, DC folks! Great job!) One area that's giving me fits right now is inserting data into a SQL Database. By working with the existing documentation and sample code, I've gotten database connections set up and templates built, but am missing something at the insert phase. Here's the template I'm using: ID: addEntry Arguments: nameField emailField maidenField yearField websiteField Query Template: insert into alumDirectory (ALUMNAME, ALUMEMAIL, ALUMMAIDEN, ALUMYEAR, ALUMWWW ) values (, , , ,  ) I've verified that this template works when I use the TEST function. But when I try to call it:  I don't get an error, but neither do I get the data inserted as it should be. I've also included this code: Name: Year: E-Mail: to verify that the form is returning good values, and it is. So, I'm befuddled. I know I'm probably doing something obviously wrong, probably with the way I'm calling the template, but I can't figure it out and would welcome help! I'm running the latest non-Alpha Zope on Windows NT. Thanks in advance! Sean McMains

3 2

Grabbing specific indexes from an #in
by craigv＠jps.net 19 Jul '99

19 Jul '99

I am trying to find a way to grab a specific index from an #in. I would like to use this much like an array in which I could ask for the object at index [i]. Is there a way to grab specific indexes from an #in without iterating through the entire list of objects? Thanks, --Craig

1 0

manage_changeProperties
by Jason Spisak 19 Jul '99

19 Jul '99

Zopists, What permissions does a user have to have to use manage_changeProperties. And it is not "Mange Properties" because a user with that permission gets an unauthorized traceback to manage_changeProperties. Actually even with all permissions a user can't access manage_changeProperties unless the DTML is proxied with the Manager Role. Anyone have a thought as to why this is? Jason Spisak webmaster(a)mtear.com

1 0

RE: [Zope] Writing to SQL Databases
by Sean McMains 19 Jul '99

19 Jul '99

Alas, neither of these options works.  just does the same thing as my original format. No error, but no change to the database.  when I try to submit the change gives me this error: Invalid attribute name, "addentry(request", for tag  Any other ideas? Anybody have any samples I can look at that take the results of a form and put them into a SQL database? Thanks Ross et al, Sean > -----Original Message----- > From: Ross J. Reedstrom [SMTP:reedstrm@wallace.ece.rice.edu] > Sent: Monday, July 19, 1999 1:07 PM > To: McMains, Sean [RICH4:2V64:EXCH] > Cc: 'zope(a)zope.org' > Subject: Re: [Zope] Writing to SQL Databases > > On Mon, Jul 19, 1999 at 11:32:01AM -0400, Sean McMains wrote: > > Hi folks, > > > > I've been working with Zope for a month or two now off and on, trying to > > figure out how to port several of my existing websites to Zope, since it > > will make my life much easier and more pleasant. (I really am impressed > with > > the work you've done, DC folks! Great job!) > > > > One area that's giving me fits right now is inserting data into a SQL > > Database. By working with the existing documentation and sample code, > I've > > gotten database connections set up and templates built, but am missing > > something at the insert phase. > > > > Here's the template I'm using: > > > > ID: addEntry > > Arguments: nameField emailField maidenField yearField websiteField > > > > Query Template: > > insert into alumDirectory > > (ALUMNAME, > > ALUMEMAIL, > > ALUMMAIDEN, > > ALUMYEAR, > > ALUMWWW > > ) > > values > > (, > > , > > , > > , > >  > > ) > > > > I've verified that this template works when I use the TEST function. But > > when I try to call it: > > > >  > > > >  > > or perhaps > >  > > should do it. > > Ross > -- > Ross J. Reedstrom, Ph.D., <reedstrm(a)rice.edu> > NSBRI Research Scientist/Programmer > Computer and Information Technology Institute > Rice University, 6100 S. Main St., Houston, TX 77005

1 0