Suppose, you have a database, items, that has fields product and scheme.
You are processing a form that has field old_product and new_product.
You have a ZSQL method, get_scheme, with parameter old_product and body
select * from items where product = .
You also have a ZSQL method, new_scheme,
On Mon, Jun 19, 2000 at 08:50:14AM -0500, Jim Sanford wrote:
> For the most part all a ZSQL method does is used some specialized DTML
> syntax to contruct a string that is your SQL query. You can create a ZQL
> method, say "GenericSQL", that has 1 parameter, let's call it
> "SQLStatement", whose s
On Tue, Jun 27, 2000 at 12:05:56PM +1000, Andrew Kenneth Milton wrote:
> +[ Dieter Maurer ]-
> | Andrew Kenneth Milton writes:
> | >
> | > So...
> | >
> | Alternatively, you could place the values from "abc_sql_statement"
> | into the "REQUEST"
On Wed, Jul 05, 2000 at 01:31:56PM -0800, [EMAIL PROTECTED] wrote:
> I am a new user to Zope and I'm trying to pass data that has been
> entered into a form (either through GET or POST) into another
> object. This object calls a z sql method to insert the form data into
> the database. So far
On Mon, Jul 10, 2000 at 01:42:48PM -0500, Nitesh Dhanjani wrote:
>
>
>
>
> On Mon, 10 Jul 2000, Sebastien Douche wrote:
>
> > Le Mon, Jul 10, 2000 at 10:49:27AM -0500, Nitesh Dhanjani à écrit:
> > # Im trying to access a postres database from within zope. I have
> > # ZPoPyDA-0.5.tar.gz insta
On Mon, Jul 10, 2000 at 05:39:27PM -0500, Nitesh Dhanjani wrote:
>
>
> On Mon, 10 Jul 2000 [EMAIL PROTECTED] wrote:
>
> > On Mon, Jul 10, 2000 at 01:42:48PM -0500, Nitesh Dhanjani wrote:
> > >
> > >
> > >
> > >
> > > On Mon, 10 Jul 2000, Sebastien Douche wrote:
> > >
> > > > Le Mon, Jul 10
On Thu, Jul 20, 2000 at 11:38:23AM -0400, Chris McDonough wrote:
> No, unfortunately, you need to stop and restart the browser.
Well, netscape 4.73 at least identifies http://server:8080 and
http://server.whatever.com:8080 as separate authentication
domains. So, you can use one as your administr
On Thu, Jul 20, 2000 at 12:27:01PM -0500, Theodore Patrick wrote:
> What is the DTML syntax for nested in statements. Here is an example.
>
>
> EXAMPLE 1: NO VARIABLE PASSING
>
> GOAL: loop 4 times and with each loop run the category_method and print out
On Thu, Jul 20, 2000 at 10:06:33AM +0100, Chris Withers wrote:
> Kapil Thangavelu wrote:
> > what i am trying to do
> >
I would like to construct a pull down of the users defined in
an acl_users of a particular location.
Say in particular, that /protected/acl_users exists. How do
I find (in dtml or in python), the list of names defined in that
particular acl_users.
To slightly generalize, how would one tree
On Thu, Aug 24, 2000 at 10:05:18AM +1000, Curtis Maloney wrote:
> On Thu, 24 Aug 2000, [EMAIL PROTECTED] wrote:
> > I would like to construct a pull down of the users defined in
> > an acl_users of a particular location.
> >
> I am doing this soon, also, so I've put in a little thought on the prob
On Wed, Aug 09, 2000 at 04:48:07PM +0100, Seb Bacon wrote:
> yup, this is how i work too.
>
> how about adding some javascript to the manage_* methods that reload the
> related window (if it's open) whenever the source changes, too? a problem
> with this might be ending up with a mass of windo
On Wed, Sep 13, 2000 at 11:29:23PM +0200, Nils Kassube wrote:
> I'm only pointing out what I think is a problem with using a
> GPL'ed component in a Zope site.
>
> My Zope-specific problem is: If I use a GPL'ed component in a complex
> object oriented environment like Zope, does this mean that t
On Tue, Sep 19, 2000 at 02:10:26PM -0500, Spicklemire, Jerry wrote:
> -Original Message-
> From: Richard Moon [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, September 19, 2000 11:43 AM
> To: Spicklemire, Jerry; [EMAIL PROTECTED]
> Subject: Re: Looking for Zope vs. Others at-a-glance compariso
Let me ask a more precise question.
Zope is not released under GPL.
Joe repleases a component which can be used with Zope under GPL license.
Zope.org makes it available for download, but in no way incorporates
it into their base system. (I.e., it is available for integration
by an end user).
J
On Wed, Sep 20, 2000 at 08:27:47PM +0200, Erik Enge wrote:
> [[EMAIL PROTECTED]]
>
> | Can she distribute Zope, Joe's product, and her own product, as long
> | as they are packaged separately?
>
> What is defined as "package separately". Different .rpms/.tgz,
> different CDs, or what?
I Don't
Is ther an easy way to allow a user defined in an acl_users to change
their own password? Or to put it another way, suppose I wanted a form
like:
User ID:
Current Password:
New Password:
New Password (2nd time):
How would I arrange to have the new password stored in a given instance
of acl_use
On Thu, Sep 28, 2000 at 11:17:03PM -0400, [EMAIL PROTECTED] wrote:
> Hi,
>
> I am writing a dtml method that deletes data from a database, and I found
> myself unable to do this. It seems that ZSQL is used to insert, update
> and query a database. but can not use
> "delete from table where var="
On Fri, Sep 29, 2000 at 06:19:35PM +0300, Erno Kuusela wrote:
> Hello,
>
> i'm obviously missing something obvious, but how does one
> execute arbitrary sql statements from an external method?
Look at
http://www.zope.org/Members/jpenny/Accessing_a_ZSQL_Method_from_an_External_
On Wed, Nov 08, 2000 at 05:08:13PM +0100, Oliver Bleutgen wrote:
> > Hamish Lawson <[EMAIL PROTECTED]> wrote
>
> > Python Zope Method
> > Perl Zope Method
> > SQL Zope Method
> > DTML Zope Method
> > Rebol Zope Method
> > Java Zope Method
> > VB Zope Method
> > Custom Zope Mthod
> > etc..
>
> an
On Wed, Nov 08, 2000 at 01:12:12PM -0500, Evan Simpson wrote:
> From: Chris Withers <[EMAIL PROTECTED]>
> > [EMAIL PROTECTED] wrote:
> > >
> > > Now, how about internal/external?
> >
> > Safe and Flexible are probably more meaningful words there ;-)
> >
> > ZMethod is growing though ;-)
>
> We've
On Wed, Nov 08, 2000 at 05:48:22PM -0500, Jason Cunliffe wrote:
> Evan Simpson <[EMAIL PROTECTED]> wrote
> > > Safe and Flexible are probably more meaningful words there ;-)
> > >
> > > ZMethod is growing though ;-)
> >
> > We've pretty much settled on restricted/unrestricted here. In honor of
>
On Wed, Nov 08, 2000 at 06:13:54PM -0500, Evan Simpson wrote:
> From: Jason Cunliffe <[EMAIL PROTECTED]>
> > Good news: 'ZMethod' is nice and 'sounds' good, however one says it.
>
> I agree, but then everyone around here thought that Zopelet was fairly
> unobjectionable, even though nobody real
> >Ah. Well, my opinion is that it'd be fairly dangerous to make the
> assertion
> >that (as great as they both are) Zope and the Zope community can "make
> up
> >for" the other half of the capital they need to develop the software
> they
> >want. So what's the decision they're t
On Mon, Dec 04, 2000 at 03:27:23PM -0500, Evan Simpson wrote:
> From: Chris Gray <[EMAIL PROTECTED]>
> > I notice that the CVS tree for Zope2 has incorporated
> (internal)
> > PythonScripts and gotten rid of (external) PythonScripts.
> This leaves the
> > old ExternalMethods but without the Bindin
On Thu, Dec 14, 2000 at 04:56:15PM +, Hamish Lawson wrote:
> I see that the latest version of the O'Reilly Zope book now talks about
> Python and Perl *Scripts*, but refers still to DTML and ZSQL *Methods*.
> Does this reflect some actual conceptual difference between a Script
> and a Method,
This is for Jos:
I ran into the same problem today. I had previously used this method,
and it works better than LocalFS for my purposes. Anyway, be absolutly
sure that your form says:
...
Then you should be able to access REQUEST.form['attachment'].filename
and REQUEST.form['attachment'].re
On Fri, Dec 15, 2000 at 04:59:07PM -0800, Jonothan Farr wrote:
> What sort of problems were you seeing with LocalFS? Maybe I can fix them.
>
> Thanks,
> --jfarr
>
> - Original Message -
> From: <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Friday, December 15, 2000 4:22 PM
> Sub
On Mon, Dec 18, 2000 at 09:10:54PM -0500, Ausum wrote:
> Hello Andy, thanks for the advice.
> It didn't work. Maybe I'm wrong at any point, so please tell me whether
> it worked for you.
>
> I'm aware that this problem has been discussed here before, that it
> happens because of Python's object n
On Thu, Dec 21, 2000 at 11:03:21PM +0100, Milos Prudek wrote:
> Regarding the upcoming Zope Book:
>
> There are some examples for UniqueValuesFor method and "_usage" syntax
> (it looks that only values "range:min", "range:max" and "range:min:max"
> are possible), but these are not mentioned in th
On Tue, Jan 16, 2001 at 11:40:21PM -, alankirk wrote:
> Hi there, i am new to zope and i'm in need of some help. I'm using zope as part of
>my final year project for university. I am using zope with a database i've
>constructed using MySQL. I've been having trouble sending queries to MySQL
On Wed, Jan 17, 2001 at 04:36:29PM -0800, Andy McKay wrote:
> Ive looked through the docs and Im sure I saw once (but cant see it now),
> some sort of delimiter between SQL statements allowing me to put multiple
> SQL statements in one SQLMethod. Was I imagining that?
> --
> Andy McKay.
No inde
On Mon, Jan 22, 2001 at 12:11:31PM -0800, J B Bell wrote:
> Dear comrades in zopeness:
>
> For some time now I have been struggling trying to get Zope to talk to
> Postgres. I am now nearly successful and hope that the revolutionary
> spirit of fellow zopatistas will carry the day.
>
> Backgro
On Tue, Jan 23, 2001 at 07:41:45AM +0100, Axel Missbach wrote:
> [EMAIL PROTECTED] wrote:
> >
> > On Sun, Jan 21, 2001 at 11:27:30AM +0100, Axel Missbach wrote:
> > > Hey to all,
> > > having installed the PoPy-Modul-2.01. The ZPoPyDa-1.01-pre2 doesnt find
> > > it.
> > > calling "import PoPy" in
On Mon, Jan 22, 2001 at 07:55:28PM +0100, Dieter Maurer wrote:
> Oliver Vecernik writes:
> > I'm designing an application gathering data with forms. Navigation
> > should be done with Prev and Next buttons. As long as I'm not leaving
> > the form data should be entered, processed and the *same*
On Tue, Jan 23, 2001 at 11:17:32PM -, alankirk wrote:
> Hi there,
> i sent an email the other week regarding problems i've been experiencing with zope
>and MySQL. I've set up a database connection for zope and mysql and it sort of works.
>I can send queries to add data to my database ok but
On Wed, Jan 24, 2001 at 08:36:00AM +0530, K H Subrahmanyan wrote:
> but where can I get Popy and how to install it.
> kindly give the links.
> thanks
>
PoPy is available from www.sourceforge.net/projects/popy
zpopyda is available from www.sourceforge.net/projects/zpopyda
installation of popy is
tablename.
should work. Be sure that you check that species is valid
before this call. sql_quote should protect you from SQL injection,
but it is better to be safe.
jim
[EMAIL PROTECTED] wrote on 02/20/2006 05:46:49 PM:
> Hi,
>
> In a ZSQL Method, I have tablename.
> and I get tablename.'sp
I am perhaps being too lazy here. What is the minimal CMF
stuff to install to get the CMFCore/FS... objcts installed?
[EMAIL PROTECTED] wrote on 03/16/2006 03:05:45 PM:
> On Thu, Mar 16, 2006 at 12:59:04PM -0500, Chris Kratz wrote:
> > Hello Paul,
> >
> > How does the refresh interval work for
Great idea. Not to be recommended in general.
This works because every field is textual, and you are
sql-quoting by using type=string.
Here are the problems:
1) if someone reads this and does not use the type=string
tag, or equivalent, they will be wide open to sql injection.
2) OR, they can p
I think that your problem is in the fact that you have fed them all in
one long string (and may have autocommit on.)
If they were separate ZSQL methods, they would, in my experience,
roll back.
I recommend separating them into separate methods, with one insert
per method.
jim penny
[EMAIL PROT
http://mail.zope.org/pipermail/zope-dev/1999-September/001414.html
The only auxiliary structure I ever use is names, i.e.
n2i = {}
res = container.foo_zsql()
nms = res.names()
for i in range(len(nms)):
n2i[nms[i]] = i
Then I can address by name as in
res[i][n2i['column_name']]
jim
> Hello,
>
Suppose I have a variable foo that has value "request/name|nothing".
Is it possible from a Python Script to have this evaluated as a TAL
expression?
Alternatives?
Thanks
jim
___
Zope maillist - Zope@zope.org
http://mail.zope.org/mailman/listinfo/zope
Thanks, the external method appears to work fine. I thought about the
silly Page Template, but forgot the path: modifier exists! But the EM
should be far faster, anyway.
Thanks again.
jim
[EMAIL PROTECTED] wrote on 06/21/2006 04:04:31 PM:
> En/na [EMAIL PROTECTED] ha escrit:
> > Suppose I ha
[EMAIL PROTECTED] wrote on 08/10/2006
02:02:28 PM:
> Vangelis Mihalopoulos wrote at 2006-8-10 10:58 +0300:
> >I have a zope app in a folder and have an exUserFolder in there to
> >authenticate the app's users. The app is working fine and i get
> >authenticated by the exUserFolder and everything
[EMAIL PROTECTED] wrote on 01/08/2007 01:01:26 PM:
> """Why (the hell) are you (still) using DTML (as newbie). You are
strongly
> encouraged to use ZPT."""
>
> My sense is that ZPT solves a problem which for most of us does not
> exist. If you wish to have designers work directly on markup in a
[EMAIL PROTECTED] wrote on 01/11/2007 12:07:37 PM:
> Hi,
>
> I am writing a thesis about the security of Zope and have these
> questions. I am wondering if this is the right place to ask.
>
> Is Zope behind Apache the only solution to provide SSL connection to
Zope?
No, but it is the most comm
[EMAIL PROTECTED] wrote on 06/19/2007 08:20:44 PM:
> Hi, thank you for taking the time to read this.
>
> 1. I'm trying to learn to write a website using zope, the progress
> is good but i need to understand how can i call an zope object (ZPT
> or SQL or Script) from a script in this setup:
>
Zope itself should not be running as root. The external method will run
as
whatever user zope is running as.
If you insist on doing this kind of thing, which is a pretty bad idea,
then
use os.system(...) or one of the popen(...) commands to call another
program
that you have permitted root acc
[EMAIL PROTECTED] wrote on 09/05/2008 04:05:23 PM:
> I would like to test the value of a field entered on a form in a
> zpt, but I'm don't know the syntax
>
> basically I would like to do something like this
>
> do this
>
>
...
tal has no expression language.
>
> but this doesn'
50 matches
Mail list logo