- Zope - Zope lists

Problems with Postgres 7.0
by Richard Taylor 02 Jun '00

02 Jun '00

I am having problems with the new release of Postgres (7.0). I have an application that has been connecting to a Postgres 6.5 database through ZPyGres without any problems. When I upgraded to 7.0 the query hangs the database connection and zope. Zope will not respond to any requests until I manually kill the 'postgres' process that is doing the query. I can issue the query direct to postgres through the command line without a problem. I thought this might be something to do with ZPyGres not being thread safe but I get the same results even if I force zope to only run 1 thread. Has anyone else seen problems with ZPyGres and Postgres 7.0? For now I have had to revert to Postgres 6.5. I did see some discussion on this list recently about something called ZPoPyDA but I can find no reference to it on the Zope web site. If this is a development of a new Postgres DA I would be very interested to see if it solves my problem, can anyone advice? Many thanks Richard

2 1

DTML newbie question on summation
by Coleman, Bryan 02 Jun '00

02 Jun '00

I can't seem to add variables using let. I just get a concatination of the integers. I am using ... <dtml-let total="SUNDAY + MONDAY + TUESDAY + WEDNESDAY + THURSDAY + FRIDAY + SATURDAY"> The days represent hours but are stored as integers in the database. - Bryan Patrick Coleman Questcon Technologies (336)273-2428 bcoleman(a)questcon.com

2 1

RE: [Zope] DTML newbie question on summation
by Marcus Collins 02 Jun '00

02 Jun '00

Hi! > -----Original Message----- > From: Coleman, Bryan [mailto:bcoleman@questcon.com] > Sent: 02 June 2000 15:20 > To: 'zope(a)zope.org' > Subject: [Zope] DTML newbie question on summation > > > I can't seem to add variables using let. I just get a > concatination of the integers. I am using ... > > <dtml-let total="SUNDAY + MONDAY + TUESDAY + WEDNESDAY + > THURSDAY + FRIDAY + SATURDAY"> > > The days represent hours but are stored as integers in the database. While they're stored as integers, some of the database adaptors return everything as strings. This would seem to be borne out by the concatenation. Try: <dtml-let total="_.int(SUNDAY) + _.int(MONDAY) + _.int(TUESDAY) + _.int(WEDNESDAY) + _.int(THURSDAY) + _.int(FRIDAY) + _.int(SATURDAY)"> to explicitly convert your results to integers. hth, -- Marcus

1 0

Re: Fwd: [Zope] postgres DA
by fog＠mixadlive.com 02 Jun '00

02 Jun '00

Scavenging the mail folder uncovered Paolo Comitini's letter: > what's the current status of ZPygreSQLDA and ZPoPyDA? if i were to choose, > which should i use? and the reasons for using it? > > i understand that ZPoPyDA is level 2 thread safety, and not quite sure what > ZPygreSQLDA thread safety is. I can only say that we started writing PoPy and ZPoPyDA because pygresql (and the adapter based on it) are *not* thread safe. we were experimenting deadlocks in zope when you mix db access from sql methods and external methods in the same page. on the other hand PoPy is pretty new and, before using it in production, needs more testing. i think it will stabilize pretty soon, because we will use it to build the web sites for our customers really soon now and that will apport a lot of testing/debugging. make your choice and be happy, federico -- Federico Di Gregorio MIXAD LIVE System Programmer fog(a)mixadlive.com Debian GNU/Linux Developer & Italian Press Contact fog(a)debian.org The reverse side also has a reverse side. -- Japanese proverb

3 2

Two in one?
by Andy Gates 02 Jun '00

02 Jun '00

Fun for all the family. I'm trying to produce a page that draws from two databases following one friendly search. The first chunk of data is from the search itself and returns, among others, an ID which I want to pass into the second chunk to search it. Kinda like this: Search page: blah Report page: loop thru hits on "blah" in db1, any of 6 fields (name, desc) show id show name show desc... loop thru hits in id db2 show users show friendlynames /loop /loop The problem I have is passing parameters to the db2 search. Even if I set the SQL method to use a parameter with the same name as the var returned by the first search, I get a Zope error telling me I'm not passing enouh parameters to it. Testing the methods independently they work fine. So, (as usual) what's the no-brain bozo error I'm making? Is is possible to programmatically pass variables around like this (surely it is,this would be trivial in ASP/JSP)? ---------------------- Andy Gates, Learning and Research Technology Andy.Gates(a)bristol.ac.uk - ICQ#74362415

2 2

RE: [Zope] images in access database
by peter 02 Jun '00

02 Jun '00

Is there a particular reason why you want to save the image _in_ the database. Why not just save the name of the imagefile, its path, its width and height etc. as text in an M$ Access database? One advantage of that is that you can store a desciption (authorname, and other info) together with the image entry. You could then pull all of this out to create your own <dtml-var variable> <dtml-in "sqlSelectAllImageFromAccess"> <img src="<dtml-var path_field>/<dtml-var imagefile>" width="<dtml-var width_field" etc...> </dtml-in> This can of course be made simpler and tweaked, maybe even through a Python module. Again; if you definitly want to save it as an OLE in Access, discard. -----Original Message----- From: zope-admin(a)zope.org [mailto:zope-admin@zope.org]On Behalf Of Terry Kerr Sent: 02 June 2000 04:44 To: zope(a)zope.org Subject: [Zope] images in access database Hi, I would like to be able to have gifs/jpgs stored in an MS access database and then pull the out using zope and display them in rendered documents. I am completely new to access. I have successfully installed the ODBCDA into zope, and are able to connect to an access database and pull ordinary text data out of tables. I have created a table in access with a column of type 'OLE object' and put a gif image in as data. This is the only way I know how to get an image into the table. The problem I think with this is that it is a link to the gif on the HDD, and doesn't actually have the data in the table? Anyway, when I pull the data out of the table from zope, access puts a header and footer around the gif binary data, and hence a simple <dtml-var blah> wont work to display the image. Has anyone else every pulled images from an access database. Will I have to write a method to strip the header and footer from the returned data before displaying the gif? terry. -- ----------------------------- Terry Kerr (terry(a)adroit.net) Adroit Internet Solutions http://www.adroit.net/ 03 9563 4461 0414 938 124 _______________________________________________ Zope maillist - Zope(a)zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )

1 0

Thread-safe PostgreSQL adaptor?
by Cary O'Brien 02 Jun '00

02 Jun '00

Ok, pygresql is now DB-SIG compliant and thread safe. http://druid.net/pygresql What has to be done to create a one-database-connection-per-thread PyGreSQL database adapter? Given the recent influx of resources into PostgreSQL this would seem like a nice thing. Comments? -- cary

5 8

RE: [Zope] Using sql to search in zope
by peter 02 Jun '00

02 Jun '00

Where's the 'LIKE' ? Such as SELECT * FROM table1 WHERE table1_id LIKE %field1_value% -----Original Message----- From: zope-admin(a)zope.org [mailto:zope-admin@zope.org]On Behalf Of wai(a)mahirnet.com Sent: 02 June 2000 09:10 To: zope(a)zope.org Subject: [Zope] Using sql to search in zope Hi All, I tried to build a search feature using sql in zope, this is what I normal do in sql to do a range search : select * from table1 where table1_id = %field1_value% But when I try it with zope, it will become select * from table1 where table1_id = %'value'% Which return an error : [ODBC Microsoft Access 97 Driver] Syntax error in query expression 'table1_id alike %'field1_value'%'.") Any idea or work around ?? Please help Cheers Wai _______________________________________________ Zope maillist - Zope(a)zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )

2 1

Re: [Zope] postgres DA
by Bak ＠ kedai 02 Jun '00

02 Jun '00

On Fri, 02 Jun 2000, Stephan Richter wrote: hi stephan! > > I was just playing around with ZPoPyDA and PoPy (the Python module). It was > a little tricky to install, since the setup scripts are not fully automatic > yet, and the library header files did not point to my PostGres header files > directory. After the installation is done, everything worked like butter. > Be sure to compile PostGres with multibyte support, since you may run in > troubles otherwise. The RPMs are compiled using that option. i installed postgresql from RPM, so i guess that's ok. i managed to install ZPoPyDA, create a database connection, and do SQL stuff with no problems. sorry for my ignorance, but what is multibyte support, and what kind of problem one might run into if postgres was not compiled with multibyte support? > I am not able to evaluate ZPoPyDA at this point until I haven't done some > type testing and had the thread safety proof itself. how do one test for thread safety level? again, sorry for such obvious question. > > Regards, > Stephan > -- > Stephan Richter > CBU - Physics and Chemistry > Web2k - Web Design/Development & Technical Project Management -- ------------------------------------------------------ http://www.kedai.com.my/kk Am I Evil?

1 0

Re: [Zope] images in access database
by Rik Hoekstra 02 Jun '00

02 Jun '00

> >I would like to be able to have gifs/jpgs stored in an MS access >database and then pull the out using zope and display them in rendered >documents. I am completely new to access. I have successfully >installed the ODBCDA into zope, and are able to connect to an access >database and pull ordinary text data out of tables. > >I have created a table in access with a column of type 'OLE object' and >put a gif image in as data. This is the only way I know how to get an >image into the table. The problem I think with this is that it is a >link to the gif on the HDD, and doesn't actually have the data in the >table? Anyway, when I pull the data out of the table from zope, access >puts a header and footer around the gif binary data, and hence a simple ><dtml-var blah> wont work to display the image. Has anyone else every >pulled images from an access database. Will I have to write a method to >strip the header and footer from the returned data before displaying the >gif? > Um, in general you'd have to have very strong reasons to put large objects like images in a database (especially in Access). This has a negative effect on the performance of your application as it adds to the overhead (putting another layer between your webserver and your image retrieval). I don't see what the gains would be. If you consider putting image descriptions in your database, do so and no more. Put the images on a filesystem somewhere and make your database records point to them. This is much easier and much faster. If the number of images is large you may have to do some thinking about the directory structure. hth Rik

1 0