- Zope - Zope lists

RE: [Zope] MySQL LAST_INSERT_ID...
by Rob Page 16 Mar '99

16 Mar '99

Tom: [Reading from my support script..] This is where I say, "Hmm, I'm no expert on MySQL...." ;^) Anyone else have any ideas? This, um, worked on Sybase!? --Rob Tom Jenkins wrote: > > > To followup my last post, I'm getting an exception when > > > trying to use > > > MySQL's "select LAST_INSERT_ID()" function: > > > > > > Error, exceptions.KeyError: unhandled > > > > > > SQL used: > > > > > > select LAST_INSERT_ID() Rob Page replied: > >Try: > > > > select LAST_INSERT_ID() as fred > > > > then grab  > > > > If this works then I know what the problem is! :^) > > > > If you use the database's command line tool and run this > SQL statement I > > bet it returns a single value (i.e., it doesn't return a > table). The DA > > wants to munge and chew on rows in tables. If think that > if you use the > > select LAST_INSERT_ID() as fred you'll get a one-row, > one-column table > > -- this is what Zope wants. Then Tom wrote back: > Hi Rob, > Made the change and tested but still got the exception. > I ran it at the command line (for mysql) and it returns a > "table" with one > row and field

1 0

Newbie install Q? and the Zope web site
by Thomas Schruefer 16 Mar '99

16 Mar '99

Ok, two questions 1. What happened to the Zope web site, it seems to have gone down yesterday and still is not operating ? 2. I have downloaded ungziped and untared (Zope-1.10.2-linux2-x86.tgz), but the install instructions do not seem complete. I retrieved the INSTALL.TXT file from the doc directory and started to follow them, but their doesn't seem to be any 'access' file in this distribution. What's more some of the command line options come up as invalid, like -c,which the install program quit on saying it was a invalid option. The -c option doesn't even show up in the --help for the installer. I was hoping there would be some additional install info on the web site, but that's not working. Tom

2 1

RE: [Zope] MySQL LAST_INSERT_ID...
by Rob Page 16 Mar '99

16 Mar '99

> To followup my last post, I'm getting an exception when > trying to use > MySQL's "select LAST_INSERT_ID()" function: > > Error, exceptions.KeyError: unhandled > > SQL used: > > select LAST_INSERT_ID() Try: select LAST_INSERT_ID() as fred then grab  If this works then I know what the problem is! :^) If you use the database's command line tool and run this SQL statement I bet it returns a single value (i.e., it doesn't return a table). The DA wants to munge and chew on rows in tables. If think that if you use the select LAST_INSERT_ID() as fred you'll get a one-row, one-column table -- this is what Zope wants. --Rob

1 0

Re: [Zope] IRC channel
by Phil Harris 16 Mar '99

16 Mar '99

I for one think this is a brilliant idea! I visit the PHP3 channel on EFNET frequently, a real sense of community and friendship can be built. I really do hope this comes off, so let's make a go of this eh guys 8^) See you there. Phil ----- Original Message ----- From: Fredy Villa <FVilla(a)GestaltTechnology.com> To: <zope(a)zope.org> Sent: Tuesday, March 16, 1999 1:07 PM Subject: [Zope] IRC channel >Dear Zopists, > > This is another post to make you aware of a new source of >information for Zope. You can access #zope on the EFNet servers. Their >is an infobot on this channel that could be a great resouce, but it >needs to learn a lot about zope. If you pay a visit to the channel, >query the bot by typing: /msg wizkid1 help. This will provide more >information on the bot. > >Cheers, > >Fredy Villa >Gestalt Technology >FVilla(a)GestaltTechnology.com > > >_______________________________________________ >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

IRC channel
by Fredy Villa 16 Mar '99

16 Mar '99

Dear Zopists, This is another post to make you aware of a new source of information for Zope. You can access #zope on the EFNet servers. Their is an infobot on this channel that could be a great resouce, but it needs to learn a lot about zope. If you pay a visit to the channel, query the bot by typing: /msg wizkid1 help. This will provide more information on the bot. Cheers, Fredy Villa Gestalt Technology FVilla(a)GestaltTechnology.com

1 0

sequence of numbers
by Bill Randle 16 Mar '99

16 Mar '99

This may be a newbie question, but I've loked thru the doc and didn't spot any obvious way to do this, short of an External Method. What I want to do is given a limit number, iterate over a sequence of DTML commands. This would be an obvious use for #in (which I'm using elsewhere for other things) except I don't have a sequence - just the number of items in the sequence, as it were. In psuedo-code, what I'm after is something like this: for (i=0; i < ; i++) { // some DTML/HTML code using "i" } Now if, given a #var, I could get a list - e.g.:  --> list = [0, 1, 2, ... max_items] or [1, 2, ... max_items], it doesn't make much difference. then I could just use:  // some stuff using   Is there an easy way to do this? Is there *any* way to do it? -Bill Randle Central Oregon Internet billr(a)coinet.com

4 4

incrementally improving a product?
by julian＠zereau.net 16 Mar '99

16 Mar '99

If I build a product, deploy instances of it, and continue editing and reloading the product, will its instances be improved or will they be frozen at the state they were in when created? Also, is there any problem with the instances failing to work with a newer product version? --- Julian Morrison Programmer (Zereau Ltd)

3 2

Feature request - local file browsing
by Milos Prudek 16 Mar '99

16 Mar '99

Would it be possible to modify expected file type when I click on browse and want to add local image type? Browser always presents .htm extension, so that I need to change it to *. I run browser from windows, Zope itself is on linux box. -- Milos Prudek

2 1

Re: [Zope] access content informations & use mailhost services properties
by Service Informatique CHSR 16 Mar '99

16 Mar '99

Nobody responded. So it went to the Collector. I don't even know if this is a bug. >Also, before I submit this to the Collector, is it normal that the "use >mailhost services" >doesn't appear in the security tab of the folders? Each product has its >permissions >that are listed, but nothing with the mailhost object. >I had to change it directly in the mailhost object. >If it's normal, it means that i can't give global permission for mailhost >objects??? >What confuse me, however, is that the mailhost object claims to "acquire" >permission >settings from its parents, but nowhere in its parents i can define the >permissions. Regards, Jephte CLAIN Service Informatique CHSR

1 0

Newbie: trouble getting started under Windows 98
by Robert Wentworth 16 Mar '99

16 Mar '99

While I expect to eventually be working under Unix (once I can convince my hosting provider to install Zope), at present I'm trying to use Zope under Windows 98. The problem is: it's not working. I'm using the Zope HTTP server, and I can contact the management system just fine, a prowl around looking at everything. But if I try to add an object (whether it be a DTML Document, a Folder, or an "Item" from the sample_product package (which I installed), what happens is: I am allowed to fill out the form where you enter object creation fields (ID, title, etc.), but when I send that form the HTTP server never returns. Any clues as to how to fix this, or debug it, or get any idea as to what is happening? Robert Wentworth

1 1