[Zope] ZSql Strange Error

Hi! I'm trying to emulate an outter join in a Z SQL, but Zope crashes every time I try the query. The query is defined as: -*-*- parameters: username query definition: select codigo, nome, 'T' as select from cad_exportacao where codigo in ( select codigo from user_codigo

Re: [Zope] ZSql Strange Error

I'm not sure why this should *crash* zope, but you can do it with a much simpler query and a little DTML coding. The following should work (UNTESTED): It cannot help me. I have two tables. One called cad_exportacao, and the other is called user_codigo. The table user_codigo maps every

Re: [Zope] ZSql Strange Error

Casey Duncan wrote: Duh, maybe I should learn to read. :-) Let me know if this is any better, It worked! Thanks. []s -- César A. K. Grossmann http://members.xoom.com/ckant/ ___ Zope maillist - [EMAIL PROTECTED]

[Zope] Filling Multiple Select Problem

Hi! I'm using the example at the "Filling MULTIPLE SELECT OPTION's with database lists", and a little step doesn't works. I heve the following in the DTML Method that fills two SELECT in a Web Form: (...) dtml-call "REQUEST.set('cadExportacao', [])" dtml-call "REQUEST.set('cadImportacao', [])"

[Zope] GUF error: Unauthorized...

Hi! I have created a GUFTest folder. It runs perfectly with the user 'jorge', provided with the GUF. After I have changed the acl to use a SQL connection, I'm getting the error bellow (in the log of the system): GUF[7909]: http://localhost.localdomain:8080/GUFTest/acl_users/userAuthenticate

[Zope] Passing parameters to methods - how to?

Hi! I'm making my own user managements methods, and I'm stucked with a (simple) problem: How do I call another DHTML method, passing parameters to it, in HTML? I'm using a DTML Method that gives me a list of usernames. I want to click on the username and get the properties for that username. I

Re: [Zope] Cookie pointer.

TMGB wrote: Since cookies have been brought up, I tried the following code (Using Steve's example): I cannot use this code in a GUF/docLogin. I get the error: "Unauthorized You are not authorized to access ZopeTime. " What can I do to this code works? []s -- César A. K. Grossmann [EMAIL

Re: [Zope] Cookie pointer.

Steve Drees wrote: What can I do to this code works? Can you cut and paste the offending code? Exactly the same of the message of Thomas: dtml-if expr="RESPONSE.setCookie('name', 'value', path='/', expires=(ZopeTime() + (1.0/102.0))" "You have cookies enabled" dtml-else "Your

[Zope] Zope to PostgreSQL Connection?

Hi I'm with some troubles to connect a freshly installed Zope 2.2.1 on a Conectiva Linux 5.0 (glibc-2.1.2, the rest is the same as Red Hat 6.x) to a PostgreSQL 7.0.2 database. The ZPyGreSQLDA (http://www.zope.org/Members/reedstrm/ZPyGreSQLDA-rjr) "is broken". I tried to get the PoPyDA working,

Re: [Zope] From a Folder to a Product

"R. David Murray" wrote: If you put everthing at the top level except the DB connection, and put the appropriate one of those in each user's folder, I should think they could access the report via acquisition. You mean, put all sql-queries, dtml-docs and dtml-methods spread in the root

[Zope] From a Folder to a Product

Hi! I'm pretty satisfied with a group of reports I have done in Zope, and want to put a copy of it in every customer's folder I have in the Zope Server. Are there a document/tutorial I can use as a guide or tutorial to do this? If someone wants to point some general guidelines, the folder

[Zope] dtml-in 'one record per page' problem

Hi! I'm using a report that must return one instance by page, but it's not working very well... If the query returns more than one result, Zope presents only two pages. I'm using Zope 2.1.6 in a Linux box. Here are a excerpt of the dtml code used: dtml-in sqlQuery size=1

[Zope] GUF + SQL connection problem

I'm trying to add a SQL connection to GUF, and getting an error when trying step 8 of the How To ("HOWTO Use GenericUserFolder with an SQL Database"): "You are not authorized to change change_password_report because you do not have proxy roles. " The step 8 says

Re: [Zope] GUF Problem

Richard Moon wrote: I don't think GUF works in its current release, or maybe the set-up instructions are incomplete. I used it before and it was ok but I tried the latest release and had the same problem as you. I reported it to GUF's author but didn't get a reply. I just added a SQL user

[Zope] [Fwd: [Zope] GUF Problem]

One reply I get from Mario: Mario Premke wrote: I remember I had the same problem. In GUF's acl_user folder I gave the special_role the same permissions as the anonymus role. As far as I remember that did it ... -- César A. K. Grossmann [EMAIL PROTECTED] http://members.xoom.com/ckant/

Re: [Zope] LoginManager HOWTO?

Stuart 'Zen' Bishop wrote: But do you want advanced? If you just want to store your authentication information, UserDB is just fine - moving to GenericUserFolder in this case may just cause you troubles, as more advanced also means more complicated. I need to provide a logon screen more

[Zope] LoginManager HOWTO?

Hi! I'm trying to produce a web site with user authentication, and was looking for something more customizable than the standard user authentication mechanism provided by Zope. My first step was look in the Zope page, making a search on the term 'authentication'. I found three products: UserDB,