- Zope - Zope lists

Re: [Zope] Zope-help
by Dieter Maurer 06 Jul '00

06 Jul '00

Bruno Nana writes: > select * > from iekunde >  > where (substring(firma,1,1)=substring(,1,1) or > substring(firma,1,1) > substring(,1,1)) and > (substring(firma,1,1)=substring(,3,1) or > substring(firma,1,1) < substring(,3,1)) >  > > And the error is this: > > Error Type: Error > Error Value: Error processing select * from iekunde where > (substring(firma,1,1)=substring(UuZ,1,1) or substring(firma,1,1) > > substring(UuZ,1,1)) and (substring(firma,1,1)=substring(UuZ,3,1) or > substring(firma,1,1) < substring(UuZ,3,1)) Invalid column name 'UuZ'. > Invalid column name 'UuZ'. Invalid column name 'UuZ'. Invalid column name > 'UuZ'. > > That mean that the operator ">" can only compare two number. It means that "UuZ" is interpreted as a *column name*, i.e. as a field in your database and not as a string. This is because, it is not enclosed in '...'. Such a column does not exist; therefore, the invalid column name errors. Instead of "<dtml-var alphabet>" you should use "<dtml-sqlvar alphabet type=string>". It does represent the constant string value correctly. Dieter

1 0

Re: [Zope] Reportlab and Zope
by Dieter Maurer 06 Jul '00

06 Jul '00

Jorge Magalhaes writes: > How i can insert the contents of the Local File System in to HTML environment? The easiest way, probably, is Jonothan Farr's LocalFS product. Dieter

1 0

Fw: [Zope] Re:Web Site newbie
by Loren Stafford 06 Jul '00

06 Jul '00

----- Original Message ----- From: "Loren Stafford" <lstaffor(a)dynalogic.com> To: "michael montagne" <montagne(a)easystreet.com> Sent: July 06, 2000 01:11 PM Subject: Re: [Zope] Re:Web Site newbie > As Andy also said, "It depends". It depends on what you want to do with > your website. Write and let us know so we can give more specific answers. > Chances are you can put all your content in Zope's database. > > Some folks decide to store some files outside of Zope and serve them thru > Apache, for any of the following reasons: > > 1. You've got thousands of them > 2. They're huge (full-length mpeg2 movies, for example -- hundreds of > megabytes) > 3. They need to be accessible to other applications > > But if you don't have such requirements, count on Zope for everything. > > -- Loren > > ----- Original Message ----- > From: "michael montagne" <montagne(a)easystreet.com> > To: <zope(a)zope.org> > Sent: July 06, 2000 06:49 AM > Subject: [Zope] Re:Web Site newbie > > > > Tremendous reply!! Just what I needed. I'm curious about one thing tho. > > <If you don't need a regular web server (for serving files outside of > Zope), > > stick with the built-in ZServer. > > > Does this mean that I have to have all my files in the zope folder? > > Wouldn't I want to do that anyway? Can you elaborate? > > I'd like to stick with the Zserver if I can but I don't want to run into > any > > road blocks too soon down the road. > > -mjm > > >

1 0

Re: [Zope] Calling Stored Procedures using DCOracle
by Dieter Maurer 06 Jul '00

06 Jul '00

> When I execute this : > >>> conn.callproc('addarticle',['dfdsf']) > > I get the following Error : > __getattr__ > raise error, 'no usable procedure named '+name > oci.error: no usable procedure named addarticle > > > How ever if I do this : > >>> conn.getSource('ADDARTICLE') > > It returns the source code. Notice the (potentially) essential difference: In "callproc" you use "addarticle" (i.e. all lowercase), but in "getSource" you use "ADDARTICLE" (i.e. all uppercase). Maybe, case is essential. > In short I need to run my stored procedures from python. They are all ready > and waiting to be used. Some one help me :-) Some days ago, I extended ZOracleDA with a method to call a stored procedure. ZOracleDA gives me a cursor. I used: return cursor.procedures.<my_procedure_name>(<my_arguments>) worked fine. Dieter

1 0

Re: [Zope] Sql result searchs with Z Catalog
by Dieter Maurer 06 Jul '00

06 Jul '00

asjf11(a)uaa.alaska.edu writes: > I need to somehow populate an ZCatalog index with the results of a > Z SQL Method. If you are familiar with ColdFusion, it needs to have > the same functionality as a Verity search on a collection (custom > indexed from a query). I am having trouble seeing how this might > be accomplished. You asked this question already several times. I did not answer, because I do not understand why you may want to do this. I cannot imagine why someone wants to emulate a fast relational search by a (comparatively) slow ZCatalog search. Thus, I must miss something. Anyway. ZCatalog is happy to catalog anything that is URL addressable. Using direct traversal (--> Z SQL User Guide) you can make database records URL addressable. You probably will need an explicit loop over your query result set and call "catalogObject" for each of them. Dieter

1 0

Squishdot giving DateTimeError(newbie)
by Rajil Saraswat 06 Jul '00

06 Jul '00

hi I am trying to setup squishdot. I had correctly setup the system(psotings etc were going on fine), but a weird thing happened as the 12 in the night passed by the squish stopped running. it is now giving Error:DateTimeError ErrorValue:UnrecognisedTimeZone I am running zope on MandrakeLinux7.1, is the time on the system got to this or is this a squish problem. Thanks for any clues

1 0

Re: [Zope] How do I specify a list element?
by Dieter Maurer 06 Jul '00

06 Jul '00

asjf11(a)uaa.alaska.edu writes: > I have a list (I think) created this way: > > (date = '31-DEC-1999') > > <dtml-call "REQUEST.set('MyList', _.string.split(date, '-'))"> > > so now REQUEST['MyList'] should contain 3 elements: > 31 DEC 1999 > > How, in dtml, do I say "give me the value of the 1st element of MyList" or > the second or third. > > I've tried <dtml-var "REQUEST['MyList'][0]"> but I get this error: > > Error Type: TypeError > Error Value: argument 1: expected read-only character buffer, > Missing found > Now I don't know which part this error is refering to, but anyhow I want > this functionality. I expect that your "date" looks like a string but in fact is an object. In this case, your error does not result from the "MyList[0]" but from th "_.string.split(date,'-')". Use "_.string.split(_.str(date),'-')", instead. Dieter

1 0

Re: [Zope] getting queries of a database into variables?
by Dieter Maurer 06 Jul '00

06 Jul '00

Rajil Saraswat writes: > .... How do i put up queried data > into variables so i can conditionally check them? The result of an Z SQL method behaves like a list of row objects. Each row object behaves like an object with the columns as attributes. Thus you can use: <dtml-let query_result=Z_SQL_method <-- behaves like a list --> hits="_.len(query)" <-- number of hits--> > <dtml-if hits> <dtml-with "query[0]"> <-- opens direct access to columns of hit 1 --> <dtml-var column1> ..... </dtml-with> </dtml-if> </dtml-let> > Does there exist some readymade package for setting up cookie based > authorization. i could locate someting called LoginManager, but how do i > use it. Have a look at the Zope product GUF (Generic User Folder) --> zope.org; see also the respective HowTows. Dieter

1 0

Re: [Zope] Is Zope slow?
by Steve Alexander 06 Jul '00

06 Jul '00

Firestar wrote: > Check out Jakob Nielsen's website and you would know that speed of serving > webpages is one of the main usability factors. The bottleneck is not generally the speed of serving webpages, but rather, the speed of the client downloading the data from webpages, as the data has to go through N regions of the Internet between the server and client. Also, users tend to look at more than one webpage at a time, and so their incoming bandwidth per connection is reduced even further. The answer to this issue is to avoid large graphics and large pages, allow client-side caching, move the useful content of a site "forwards" towards its entrance, avoid banner adverts... -- Steve Alexander Software Engineer Cat-Box limited http://www.cat-box.net

1 0

Newbie: Build Object Names
by Terry Babbey 06 Jul '00

06 Jul '00

I am trying to build my object names and it is not working. Here is my code done in three ways and only one way works. #1 <dtml-var "ProgCode+'AR'"> #2 <dtml-var name="T043AR"> #3  <dtml-var booger>  #1 displays T043AR on the screen #2 displays the Text I entered into the object (This is what I want) #3 again only displays the T043AR Any suggestions? I am hoping I just need some basic information to accomplish this. Thanks, Terry -- __________________________________________________________________ Terry Babbey Technical Support Specialist Lambton College, Sarnia, Ontario, Canada __________________________________________________________________

1 0