Re: [Zope] Z SQL Method
maybe dtml-call "REQUEST.set('my_var', _['sql_example'])" works
On Tuesday 30 January 2001 12:22 pm, Martin Jundt wrote:
Hi there,
I have got a litte problem with a Z SQL Method "sql_example":
select count(*) as result from example_DB
I want to put the returned result in a variable:
dtml-in sql_example
dtml-call "REQUEST.set('my_var', result)"
/dtml-in
This works fine.But should something like
dtml-call "REQUEST.set('my_var', ['sql_example'])"
work, too?
Thanks
Martin
___
Zope maillist - [EMAIL PROTECTED]
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 )
--
Diego Rodrigo Neufert
Webmaster / Web Developer - Magic Web Design
---
[EMAIL PROTECTED]
www.magicwebdesign.com.br
Curitiba - PR - Brasil
___
Zope maillist - [EMAIL PROTECTED]
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 )
Re: [Zope] Dynamic ordering of DTML-IN?
You can use something like: dtml-if "orderby=='firstname'" dtml-in "sql_search(search='foo')" sort=firstname dtml-elif "orderby=='lastname'" dtml-in "sql_search(search='foo')" sort=lastname /dtml-if On Tuesday 23 January 2001 10:39 am, you wrote: Another one from the "my brain don't work" side of the tracks: I have a staff list that I want to be orderable by first or last name. So I have buttons for each that link thus: a href="staff?orderby=firstname" etc The idea is that that feeds over to the DTML-IN tag thus: dtml-in "sql_search(search='foo')" sort=orderby But this barfs, because it's expecting a field name "orderby" and there isn't one. How do I evaluate that? -- Andy Gates, Learning and Research Technology [EMAIL PROTECTED] - ICQ#74362415 http://www.ilrt.bristol.ac.uk ___ Zope maillist - [EMAIL PROTECTED] 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 ) -- Diego Rodrigo Neufert Webmaster / Web Developer - Magic Web Design --- [EMAIL PROTECTED] www.magicwebdesign.com.br Curitiba - PR - Brasil ___ Zope maillist - [EMAIL PROTECTED] 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 )
[Zope] Upload file and :int with :required and
When using :required with a file field I got this error: Error Type: AttributeError Error Value: 'string' object has no attribute 'read' How to make a file field required in dtml? and anyone know how to make something like :int:required works? I need a int field to be required thanks in advance... -- Diego Rodrigo Neufert Webmaster / Web Developer - Magic Web Design --- [EMAIL PROTECTED] www.magicwebdesign.com.br Curitiba - PR - Brasil ___ Zope maillist - [EMAIL PROTECTED] 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 )
[Zope] Zope.org is down?
Is it realy down? -- Diego Rodrigo Neufert Webmaster / Web Developer - Magic Web Design --- [EMAIL PROTECTED] www.magicwebdesign.com.br Curitiba - PR - Brasil ___ Zope maillist - [EMAIL PROTECTED] 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 )
[Zope] ZClass with images
Anyone know how to put some images in ZClass? I have done things like putting ZClass with base class OFS:Image but with it I can only assing one Image do the object... I need to assign two or tree images do the object. Thanks... -- Diego Rodrigo Neufert Webmaster / Web Developer - Magic Web Design --- [EMAIL PROTECTED] www.magicwebdesign.com.br Curitiba - PR - Brasil ___ Zope maillist - [EMAIL PROTECTED] 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 )
Re: [Zope] Another Zope E-Commerce Site Online
Transaction Error too Are you trying to do session management and/or database querys in two different frames? On Qua 06 Dez 2000 16:16, you wrote: Just announcing this new e-commerce zope based site. http://www.adirondackcraft.com Come buy something, but don't whack it too hard, this site is still a work in progress (aren't they all?) -- This site was "thrown together" in about 5 days for a disorganized customer, came online just 30 minutes before it's first sale. They had a big ad in the New York Times which pushed the deadline. - Zope 2.2.4 with Interbase, gvibDA and Wampum Generator running behind Apache with mod_proxy and mod_ssl, on RH Linux 7. I'm thinking of writing a white paper on this entire experience, from a consulting point of view and a programmer's viewpoint. Not sure how useful that would be to anyone. There were 2 graphics/layout designers and myself working directly with the customer to go from concept to completion in an extremely short timeframe. Brad Clements,[EMAIL PROTECTED] (315)268-1000 http://www.murkworks.com (315)268-9812 Fax netmeeting: ils://ils.murkworks.com AOL-IM: BKClements ___ Zope maillist - [EMAIL PROTECTED] 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 ) -- Diego Rodrigo Neufert Webmaster / Web Developer - Magic Web Design --- [EMAIL PROTECTED] www.magicwebdesign.com.br Curitiba - PR - Brasil ___ Zope maillist - [EMAIL PROTECTED] 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 )
[Zope] dtml-while
Why there isnt a dtml-while function in Zope? How to implement it with dtml? how to do a simple while x != y in dtml? Thanks in advance... -- --- Diego Rodrigo Neufert -webmaster --- (Magic Web Design) (email) ([EMAIL PROTECTED]) (curitiba) (pr) ___ Zope maillist - [EMAIL PROTECTED] 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 )
[Zope] dtml-in returning null
Hi... I want to do something like this... dtml-in InMethod input type=text name=Name value="dtml-var name null="Name Here"" /dtml-in But, if InMethod return nothing it display this input tag one time There's a way to do that?? Thanks -- ------- Diego Rodrigo Neufert -webmaster --- (Magic Web Design) (email) ([EMAIL PROTECTED]) (curitiba) (pr) ___ Zope maillist - [EMAIL PROTECTED] 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 )
[Zope] Fwd: Re: [Zope] Zope in Windows is faster than Linux ???
Are you using Zope behind apache under Linux? Or it's a direct request to ZServer? As I can see the files are not the same, try to bench exactly the same file... On Fri, 06 Oct 2000, you wrote: Hi, I have a problem with Zope speed. I've done benchmarking in two machines, with the same hardware. (K7 700 MHz, 128 MB, 20GB HD) Windows machine : W 2000 Professional with Zope for Windows Linux machine : Linux RedHat 6.1, with Apache Server 1.3.12 and Zope 2.2.1 Windows 2000--- Server Hostname:windows Server Port:80 Document Path: /index_html Document Length:486 bytes Concurrency Level: 25 Time taken for tests: 1.807 seconds Complete requests: 1000 Failed requests:137 (Connect: 0, Length: 137, Exceptions: 0) Non-2xx responses: 864 Total transferred: 660974 bytes HTML transferred: 473471 bytes Requests per second:553.40 Transfer rate: 365.79 kb/s received Connnection Times (ms) min avg max Connect:0 010 Processing:1142 356 Total: 1142 366 --- Linux--- Server Hostname:linux Server Port:8088 Document Path: /Contactos Document Length:396 bytes Concurrency Level: 25 Time taken for tests: 7.688 seconds Complete requests: 1000 Failed requests:0 Total transferred: 595000 bytes HTML transferred: 396000 bytes Requests per second:130.07 Transfer rate: 77.39 kb/s received Connnection Times (ms) min avg max Connect:0 8 224 Processing: 102 18154 Total:102 189 278 --- There's a big difference in the number of requests per second, four times more in the Windows machine. Anyone knows why? Does it mean that Zope running in Windows is better than in Linux? /_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Aitor Grajal Crespo Director General e-mail: [EMAIL PROTECTED] INETSYS, S.L. ETSI Informática Ctra. Colmenar, km. 15,500 28049 MADRID SPAIN Tfno : (34) 91 348 22 66 - Fax : (34) 91 348 22 66 http://www.inetsysonline.com /_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ -- --- Diego Rodrigo Neufert -webmaster --- (Magic Web Design) (email) ([EMAIL PROTECTED]) (curitiba) (pr) ___ Zope maillist - [EMAIL PROTECTED] 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 )
[Zope] Fwd: Re: [Zope] Urgent: acquisition and permissions question.
Just put an index_html under protected folder the user will get access denied... On Mon, 18 Sep 2000, you wrote: Hello everybody Maybe the answer is easy, but I can not find the solution:(and maybe I was completly wrong about permissions) I have a folder containing SQLs and methods: /project and a subfolder who has his access and view security setting disable for anonymous: /project/protected When anonymous access /project/index_html he see the page : that's good. 1)When anonymous access /project/protected/index_html he also see the page. Is it normal?? ( the index_html is of course only inside the /project ) 2)If anonymous access /project/protected/some_method_with_sql and the result is empty, he see the result page!That's strange. But if the result is not empty, he get the authentication box : that's good. It's zope2.2.1 So can someone explain me the rules when an unprotected object is acquired from a protected folder?? Thanks, Gilles ___ Zope maillist - [EMAIL PROTECTED] 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 ) -- --- Diego Rodrigo Neufert -webmaster --- (Magic Web Design) (email) ([EMAIL PROTECTED]) (curitiba) (pr) ___ Zope maillist - [EMAIL PROTECTED] 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 )
[Zope] 2.2.0b4 to 2.2.1
It's safe to update 2.2.0b4 to 2.2.1? Or I need to install 2.2.0final first? Thanks in advance... -- --- Diego Rodrigo Neufert -webmaster --- (Magic Web Design) (email) ([EMAIL PROTECTED]) (curitiba) (pr) ___ Zope maillist - [EMAIL PROTECTED] 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 )
[Zope] dtml-raise and standard_error_message
Hi.. I'm having problems to do dtml-raise show the error in standard_error_message. Here's what i'm doing: dtml-raise type="ErrType" err msg /dtml-raise I got an error screen but it's not the standard_error_message How to make dtml-raise show the error in standard_error_message? Thanks -- ------- Diego Rodrigo Neufert -webmaster --- (Magic Web Design) (email) ([EMAIL PROTECTED]) (curitiba) (pr) ___ Zope maillist - [EMAIL PROTECTED] 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 )
[Zope] Re: HappySession
Well, this problem just accours when I restart the server or I stay too much time idle and the session expires... The frame[0] (the first to be loaded) show a session not found message and in frame[1] I got this error: Error Type: KeyError Error Value: NDxCfgEr_89YtG So, if I refesh the page zope show me the transaction error and everything stops working I need to restart zope and my netscape (to clean all cookies) to get things working again Here's my session not found page but this error occours when I doesnt have one too... well, in the standard html header I call call a method that do a call in all my sessions I have two SESSION objects, one in the root of zope and other in the opt folder of zope look how I call the SESSIONS in standard_html_header dtml-call callSession The callSession method: dtml-call SESSION dtml-call opt.SESSION session_not_found_html: dtml-var standard_html_header font face=Arial size=2 O tempo maacute;ximo de duraccedil;atilde;o foi ultrapassado.br Os items existentes no seu carrinho foram apagados.brbr Continue suas compras normalmente agora... /font dtml-var standard_html_footer On Thu, 31 Aug 2000, you wrote: My conjecture now is that your error-handling HTML might be accessing attributes from Zope server. A more correct way of handling exceptions should have been using the dtml-try...dtml-except.../dtml-try block. But I kind of make a cheat sheet recipe recommendation, tweaking the standard_error_message, which was not a good idea. When Zope arrives to standard_error_message, the transaction has been aborted and if your session_not_found_html is not simple enough and uses more DTML features, I can see that it can cause transaction error. Can you send me your session_not_found_html? I think this was the problem. In the future I will remove the standard_error_message trick from the help file and instead tell people to use proper exception handling, which is the right way of doing things. But it will require people to structure their sites more carefully so they can catch the SessionNotFound exception. Basically, it is recommended that you have single (or few) index_html on your site, and place a dtml-try...dtml-except ../dtml-try block to capture all exceptions from Zope and deal with them. It's the right way of doing things, it's just that many people tend to have many index_html and it will make their site harder to catch exceptions and deal with them in a centralized way. In short, HappySession itself is probably not the cause of the transaction error. The problem probably comes from bad exception handling. If you want to use the standard_error_message trick, then please use a simple html page for session_not_found_html without additional Zope features. If I find out more, I'll let you know. regards, Hung Jung _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. -- --- Diego Rodrigo Neufert -webmaster --- (Magic Web Design) (email) ([EMAIL PROTECTED]) (curitiba) (pr) ___ Zope maillist - [EMAIL PROTECTED] 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 )
[Zope] HappySession
I'm making a site with frames with session management. I'm using HappySession to do it... I need to call SESSION['something'] in various frames at the same time, but when a SESSION expire I got a Transaction Error that blow up my Zserver... Anyone know how to solve this or another SESSION product that doesnt have that problem? Thanks in advance -- --- Diego Rodrigo Neufert -webmaster --- (Magic Web Design) (email) ([EMAIL PROTECTED]) (curitiba) (pr) ___ Zope maillist - [EMAIL PROTECTED] 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 )
[Zope] SSL and PGP
Hi... Anyone know how to send a pgp cryped email in zope? (using dtml-sendmail or anything else) and How to run a SSL server with ZServer? Thanks... -- --- Diego Rodrigo Neufert -webmaster --- (Magic Web Design) (email) ([EMAIL PROTECTED]) (curitiba) (pr) ___ Zope maillist - [EMAIL PROTECTED] 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 )
[Zope] Numeric Check
Hi..
What's the best way to check if self.REQUEST.form.get('int_field') just contains
numeric data in a external method?
Thanks...
--
---
Diego Rodrigo Neufert
-webmaster
---
(Magic Web Design)
(email) ([EMAIL PROTECTED])
(curitiba) (pr)
___
Zope maillist - [EMAIL PROTECTED]
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 )
[Zope] standard_error_message
Hi. Anyone know how to specify other error msg file? I want the standard_error_message to still be my default error msg file but for some dtml's I want to change it... Thanks -- --- Diego Rodrigo Neufert -webmaster --- (Magic Web Design) (email) ([EMAIL PROTECTED]) (curitiba) (pr) ___ Zope maillist - [EMAIL PROTECTED] 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 )
[Zope] Session
Hi, walking trought zope.org I found a lot o Session Managers products like HappySession and SQLSession. Anyone know what's the best Session product for a production site??? thanks... -- --- Diego Rodrigo Neufert -webmaster --- (Magic Web Design) (email) ([EMAIL PROTECTED]) (curitiba) (pr) ___ Zope maillist - [EMAIL PROTECTED] 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 )
[Zope] DA, MySQL and Unix socket
hi... There'a any DA around there that allow a unix socket connection to a MySQL server? And if it is, it will be fast than a TCP connection? I'm running zope and mysql on the same server Thanks -- --- Diego Rodrigo Neufert -webmaster --- (Magic Web Design) (email) ([EMAIL PROTECTED]) (curitiba) (pr) ___ Zope maillist - [EMAIL PROTECTED] 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 )
Re: [Zope] DA, MySQL and Unix socket
On Thu, 27 Jul 2000, you wrote: Diego Rodrigo Neufert wrote: There'a any DA around there that allow a unix socket connection to a MySQL server? There is, but I'm afraid there seems to be a bit of voodoo around WRT to which version to use and how to install it :S Can you just say the name of the adpter? I've found nothing about it in ZMySQLDA... I know we've got it up and running happily... If u tell me the URL to get it, or just the name I will try to run it happily too.. :) I wanna do some benchs btw a tcp and a unix socket connection... Thanks... Steve, a bit of advice perhaps? cheers, Chris -- --- Diego Rodrigo Neufert -webmaster --- (Magic Web Design) (email) ([EMAIL PROTECTED]) (curitiba) (pr) ___ Zope maillist - [EMAIL PROTECTED] 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 )
[Zope] sequence-item and
Hi ppl... Why I cant use dtml-var "sequence-item"?? Every time I try to access sequence-item under "" in a dtml-call dtml-var or anything else I got this error: Error Type: NameError Error Value: sequence Well, I found a solution: dtml-let si=sequence-item dtml-var "si" /dtml-let Now everything is ok... but I dont want to do this, I want to access the *@%$#@ sequence-item in "". Can anyone help me? --------- Diego Rodrigo Neufert -webmaster --- (Magic Web Design) (email) ([EMAIL PROTECTED]) (curitiba) (pr) ___ Zope maillist - [EMAIL PROTECTED] 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 )
