Dieters assumption was right.
LAST_INSERTED_ID() returns a numeric value and
that seems to be the problem. So if I change the statement as this:
SELECT CONV(LAST_INSERT_ID(),10,10)
it works (CONV returns a string!)
P.S. Soren, maybe you can update your HowTo with a short note. Another
Steve Alexander wrote:
Is anyone regularly building Zope from CVS for Windows?
I want to try something out on a Zope 2.3 build on windows, but I don't
have easy access to windows development tools.
Is there a How-To on this? I'd love to run off CVS Zope at least some of
the time, but I
Dieter Maurer wrote:
You can control for an explicit acquiring object that some
attributes are acquired implicitly
Ooo... cool :-)
Where can I find out about it?
Guess! ... in the Acquisition documentation.
Each Zope installation has one (though on a place where
Michael Bernstein wrote:
that's definitely a 'bad' thing :-(
Why is that bad? A custom object management UI ('Postings'
and 'Moderation' tabs) seems appropriate for Squishdot. I
wouldn't want to manage postings from the standard
management interface.
Hmmm... it does mean you can't cut,
Dieter Maurer wrote:
Chris Withers writes:
And I suppose the other part of my wishlist:
class MyClass(Acquisition.Implicit):
# your_attribute will be acquied
# index_html won't
index_html = None
No, that is not enough!
As a side effect to turn off
Where is/are the most accurate and up-to-date documentation source(s)
for ZCatalog in terms of search syntax and the different indexing types?
cheers,
Chris
___
Zope-Dev maillist - [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope-dev
On Mon, Jan 08, 2001 at 10:10:34AM +, Chris Withers wrote:
Dieter Maurer wrote:
Chris Withers writes:
And I suppose the other part of my wishlist:
class MyClass(Acquisition.Implicit):
# your_attribute will be acquied
# index_html won't
On Sun, 07 Jan 2001 10:39:45 +, Steve Alexander
[EMAIL PROTECTED] wrote:
Is anyone regularly building Zope from CVS for Windows?
I want to try something out on a Zope 2.3 build on windows, but I don't
have easy access to windows development tools.
I think you may be out of luck, unless
Toby Dickenson wrote:
On Sun, 07 Jan 2001 10:39:45 +, Steve Alexander
[EMAIL PROTECTED] wrote:
Is anyone regularly building Zope from CVS for Windows?
I want to try something out on a Zope 2.3 build on windows, but I don't
have easy access to windows development tools.
I think
hi there,
some information on zope.org says that in the early future ftp access
should be possible not only to dtml-methods, -documents but also to
Zsql-methods.
to be future proof (and windows software proof) we'd like to have .xxx
extensions for all our methods (fac_browse_method.sql that
Chris Withers wrote:
Michael Bernstein wrote:
No, I'm creating two different applications, an image
archive and a book catalog. Both need to handle large
numbers of items. The standard management interface does not
scale to the number of objects involved from a usability
Tres:
Okay, I uploaded it to my member folder.
http://www.zope.org/Members/jspisak/Splitter/
I wasn't usinga sandbox for this, I just downloaded the source for 2.2.4
Here's the diff -u though:
--- Zope-2.2.4-src/lib/python/SearchIndex/Splitter.cThu Jan 4 10:41:15
2001
+++
Hello
I am cross poisting this becaese I beleie it merits responee fom both
lists..
The need to improve the manage interface has grown urgently clear to me
while using Zope myself, designing for all sorts of community and
collaborative Zope-based projects, demos for a number of innocent
Hello ,
I am trying to pull text from a Mysql DB into a page inside zope.
I have the ZMYSQL connection setup and tested .
for example :
select renderText From Phrases where phrase_id = 3 and lang =1
I have also gotten the ZSQL method tested and working
example :
Arguments
Jason Cunliffe wrote:
The need to improve the manage interface has grown urgently clear to me
while using Zope myself, designing for all sorts of community and
collaborative Zope-based projects, demos for a number of innocent
bystanders, interested parties and potential clients.
Zope
[EMAIL PROTECTED] wrote:
I believe that this is close
dtml-call "REQUEST.set('phrase_id', foo)"
dtml-in expr="langtest()"
dtml-var expr="_['sequence-item'].renderText"
/dtml-in
but is foo supposed to be my var of whatever I want passed ?
how
Are you planning a manage_install for products?
The ability for superusers to install complelte products directly through
the management interface, no need for ftp.
similar to import/export feature
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Jason
For example some headings I see a real need for:
NAME [default now], DATE[created, last modified] SIZE, TYPE[meta-type],
USER[default=owner], DEPTH, COUNT, CHANGES, PROPERTY, DISPLAY
This is just more dtml, since most of the mangement interface is done using
dtml-in over a simple set of
I recently released 'zopectl', a python script that acts as a configurable
front end to the z2.py script, implementing the defacto standard unix process
control commands: zopectl start, zopectl stop, zopectl restart. I wrote
it to simplify management of a server that runs several zope instances,
Jason Cunliffe wrote:
Shane Hathaway [EMAIL PROTECTED] wrote:
Now BerkeleyStorage is on its way and once that's ready,
PartitionedFileStorage will have such a small audience that it won't be
worth the trouble. Oh well, it was a fun experiment.
Can you pleae expand on this.. what
Martijn Pieters writes:
On Mon, Jan 08, 2001 at 10:10:34AM +, Chris Withers wrote:
You wouldn't need to have index_html = None if it is inherited, since
the inherited idnex_html would be used before one is acquired, surely?
Yup. If you don't want to have any index_html *at all*,
Chris Withers writes:
Dieter Maurer wrote:
Chris Withers writes:
And I suppose the other part of my wishlist:
class MyClass(Acquisition.Implicit):
# your_attribute will be acquied
# index_html won't
index_html = None
No, that is not
Here's the beef:
Want to use ZWiki but have a slightly different version of what you want a
wikiname to be? In my case I wanted to include TLAs as wikinames as my
industry is full of them and its really handy to have to automatically
hyperlinked so anyone can give the definition and references
Olaf Zanger writes:
Dies ist eine mehrteilige Nachricht im MIME-Format.
--865D189079029FB9A426EFA9
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Please do not post MIME messages!
expr="fac_browse_method.sql(id=10)" zope gernerates an error.
Zope mailing lists wrote:
I recently released 'zopectl', a python script that acts as a configurable
front end to the z2.py script, implementing the defacto standard unix process
There exists in CVS (and perhaps 2.3.whateveralphaversionitis?) a
zctl.py that also includes zeo controls, you
GET YOUR OWN 100 MEG WEBSITE FOR ONLY $11.95 PER MONTH TODAY!
STOP PAYING $19.95 or more TODAY for your web site, WHEN YOU CAN
GET ONE FOR ONLY $11.95 PER MONTH!
DO YOU ALREADY HAVE A WEBSITE? ALL YOU HAVE TO DO IS TRANSFER THE
DOMAIN TO OUR SERVERS AND UPLOAD YOUR DATA AND YOU ARE READY TO
I was wondering to what extent people using ZPatterns find the Views one can
set up for a ZClass tolerant of the Role-centric approach followed by
ZPatterns. For example:
I have two Specialists, DocumentedProducts and Products. The Products
specialist manages ZClasses of type
dtml-call "REQUEST.set('a', '\"b\"')" won't work! Please help.
Dirksen
__
Do You Yahoo!?
Yahoo! Photos - Share your holiday photos online!
http://photos.yahoo.com/
___
Zope maillist - [EMAIL
dtml-call "REQUEST.set('a', 'a\"b')"
__
Do You Yahoo!?
Yahoo! Photos - Share your holiday photos online!
http://photos.yahoo.com/
___
Zope maillist - [EMAIL PROTECTED]
- Original Message -
From: "Bowyer, Alex" [EMAIL PROTECTED]
A simple question, but I can't seem to find a simple answer in any of the
documentation...
How do you do a SELECT AS statement in a ZSQL method?
For example
SELECT FirstName + " " + LastName AS FullName
hmm... shouldn't
The following is my sql method, it can return
result even i only enter one alphabet in custname but it can't work when i enter
data into the custid.
select *from
customerwherecustid='dtml-var custid'ORcustname LIKE
"%dtml-var custname%"
P/s let me know where is my
error.TQ
Am Montag, 8. Januar 2001 04:11 schrieben Sie:
On 7 Jan 2001 17:51:24 -0800 LARRY CHUON [EMAIL PROTECTED] wrote:
Hi Zopistas,
Happy New Year!
--snipp--
Or do what you did before:
SCRIPT LANGUAGE="JavaScript" SRC="dtml-var
expr="openMe_js.absolute_url()""/SCRIPT
This will also
For any London-based readers who might be free next
Monday evening (especially if you know the answer
to the question posed in the seminar title!).
Please contact Robert if you plan to come.
Paul
Date:Tue, 19 Dec 2000 11:29:08 +
From:Robert Bristow [EMAIL PROTECTED]
Subject:
Dieter Maurer wrote:
Shai Berger writes:
... excess Oracle processes and zombies ...
I have checked our installation and can confirm that
both problems have gone.
We do not yet know what caused the excess Oracle processes.
After an increase of Zope's ZODB cache and an upgrade
to
Be careful with last_insert_id() and similar sql functions and Zope and more than one
simultanous user:
since all requests run over the same physical database connection, it is not guaranteed
that your call last_insert_id() returns YOUR last inserted record ID. if another user
performs an
Hallo,
gibt es eigentlich eine (einfache) Mglichkeit, Daten (-strukturen) in
Zope persistent zu halten?
1. Um einen schnellen Zugriff auf Daten zu haben (Die Daten werden z.B.
in Hashes vorgehalten)
2. Um Transaktionen durchfhren zu knnen (Wiedererkennen des Anwenders
z.B. ber cookies)
Der
I try to use zclassReverse 1.1.1, but when I am asked for details of the
Zclass this error (below) occurs almost instantly. This happens with all
ZClasses I have tried.
Zope 2.2.2 on WinNT.
Ideas? I have not been able to see any diagrams yet.
Regards, Peter
From the JPython (1.0.3) command line
Andy,
Follow the instructions as J said and you won't go far wrong, *but* be aware
that if you have any external methods these are not exactly subject to the
versioning.
The problem happens when you restart Zope and the new code is read into both
the versioned and original 'External Method'.
hi there,
some information on zope.org says that in the early future ftp access
should be possible not only to dtml-methods, -documents but also to
Zsql-methods.
to be future proof (and windows software proof) we'd like to have .xxx
extensions for all our methods (fac_browse_method.sql that
I am finally starting to make some decent progress with Zope now... more and
more I think to myself ... "I wonder if" and most of the time I am
pleasantly suprised when it works!
A couple of quick questions:
- How would I display the value at a variable whose name is stored in
another
hi everybody,
after a long weekend i still searching
ExtensionClass.h
where is it supposed to be, it is called by cPersistence.h
when compiling zpatterns
does it come with zope, zpattern or python?
where do i get the Makefile.pre.in from?
can i copy it from MySQLDB-1.2.0?
thanks for help
hi everybody,
my changes in the
sql parts of the python files of the zbabel product
do not show changed behaviour in the product after restart of zope.
what could be the reason?
do i have to do anything with python too?
setup is
Zbabel 0-0-3, ZMySQLDA 1-2-0, MySQLdb 0-1-2 and zope 2-2-4
Solved my first query using dtml-with ... hmm!
Any less verbose ways?
- Original Message -
From: Alex Reid [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, January 08, 2001 2:32 PM
Subject: [Zope] Newbie Questions
I am finally starting to make some decent progress with Zope
Michal,
Please use the Zope list to ask questions, thanks.
The answer is somewhat silly.
When you call this method, and you enter authentication credentials, Zope
tries to render the method. Rendering the method raises an unauthorized.
Then you enter your credentials again. And it raises
Message-ID: [EMAIL PROTECTED]
Priority: NORMAL
X-Mailer: Execmail for Win32 5.1 Build (9)
MIME-Version: 1.0
Content-Type: Text/Plain; charset="us-ascii"
Thanks, folks. That works a treat :)
AndyG
___
Zope maillist - [EMAIL PROTECTED]
At 1/8/01 02:32 PM, Alex Reid wrote:
- I am creating a 'form' method so I don't have to create separate forms for
INSERT and UPDATE actions. This works, only how do I tell Zope to ignore the
fact that dtml-var company_id doesn't exist when in INSERT mode? It is
there in the value="" parameter for
I need to use LoginManager, which doesn't seem to work with 2.3, and I need
to use Python Scripts, which are not available (?) for 2.2.x - any ideas?
Regards,
Phil
+--+
| Phil Mayers, Network Support |
| Centre for Computing Services|
| Imperial College
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Alex
Reid
Sent: maandag 8 januari 2001 15:33
To: [EMAIL PROTECTED]
Subject: [Zope] Newbie Questions
- How would I display the value at a variable whose name is stored in
another variable?
In Perl
Untested:
dtml-in "_['fac_browse_method.sql'](id=10)"
Does it work?
-Message d'origine-
De : Olaf Zanger [mailto:[EMAIL PROTECTED]]
Envoy : lundi 8 janvier 2001 08:41
: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Objet : [Zope] filename extension
hi there,
some information on zope.org
Hi all,
Thank you John for your quick reply to my previous email. I've tried out both of your
suggestions below. It still does work. I might have done something incorrectly as I
am very new to these stuffs. Here are the steps that I've taken:
1) I create a file called openMe_js with
I get back exactly nothing, no 'Not Found', no classes/attributes. I
believe that I've installed correctly. When I ask for a product that
doesn't exist, I get a traceback that starts in Extensions/zclassInfo.py.
I've tried in on Membership, LoginManager, ZPatterns, Poll, Etailer, and
zCommerce.
Hello
I am cross poisting this becaese I beleie it merits responee fom both
lists..
The need to improve the manage interface has grown urgently clear to me
while using Zope myself, designing for all sorts of community and
collaborative Zope-based projects, demos for a number of innocent
Aaron Payne [EMAIL PROTECTED] writes:
I am following Dan Pierson's How-To SQL LoginManager with SQL and
Skinscript. I am not able to add properties.
You may have noticed my silence on property sheets... At first, I
didn't expect to use them, because I expected only members to edit
their
hi there,
thanks for the answer, but ...
[EMAIL PROTECTED] schrieb:
Untested:
dtml-in "_['fac_browse_method.sql'](id=10)"
Does it work?
nope
dtml-in "_['adr_select_method.sql'](id=man_adr_id)"
Error Type: Bad Request
Error Value: ['id']
this (with the renamed file) works though:
Perhaps I am wrong here, but couldn't one just use indirect variable lookup
within the expression to access the method. There has got to be a way to
use _.getitem for this purpose inside the dtml-in, since by default, it
doesn't automatically render the method, but I'm not sure how one would
Steve wonders:
Is there anything like a Zope 'Best Practices' document or
Wiki? One that would encourage use of certain practices, DTML
idioms or products, and warn of practices, idioms or products
that are known to cause problems down the line or are slated
for extinction?
I ask
Has anyone tried get the LoginManager to work with Zope 2.3a1? When I
try the LoginManager product is broken with error message:
LoginManager Import Traceback
Traceback (innermost last):
File "/usr/lib/Zope-2.3.0a1-src/lib/python/OFS/Application.py", line
405, in import_products
Is there a product / some code for maintaining free Zope sites where members
log in get a some space etc. For example Zope.org or nipltd.com? Theres
plenty of advanced login products (Login Manager, Membership etc), but it
would be nice to download one without having to add to it?
Cheers.
--
Hello all,
Zope 2.2.5 has been released - you can download it from
Zope.org:
http://www.zope.org/Products/Zope/2.2.5/
This release contains a number of bug fixes, and includes all Hotfixes
to date. It includes the fix for a memory leak that could occur when
accessing SQL data
I try to intercept exceptions in a Python Method without success.
The following code works well:
try:
a = int('a')
except:
return 'exception.'
but the next doesn't work:
try:
a = int('a')
except ValueError:
return 'exception'
How can I intercept a concrete exception?
Are you planning a manage_install for products?
The ability for superusers to install complelte products directly through
the management interface, no need for ftp.
similar to import/export feature
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Jason
For example some headings I see a real need for:
NAME [default now], DATE[created, last modified] SIZE, TYPE[meta-type],
USER[default=owner], DEPTH, COUNT, CHANGES, PROPERTY, DISPLAY
This is just more dtml, since most of the mangement interface is done using
dtml-in over a simple set of
I'm running PythonScripts with 2.2.4 and, with one exception, they seem to
be working just fine. The exception is that DTML namespace binding does not
work under 2.2. You can, however, pass the namespace explicitly to get the
same effect. Here is what you need to do to get it working. Note
Austin Mayberry wrote:
Has anyone tried get the LoginManager to work with Zope 2.3a1? When I
try the LoginManager product is broken with error message:
LoginManager 0.8.6 seems to work fine. 0.8.8b1 tries to use a class in
User.py that no longer exists. In fact, it does things that are
Jason mentioned :
The need to improve the manage interface has grown urgently
clear to me while using Zope myself, designing for all sorts
of community and collaborative Zope-based projects, demos for
a number of innocent bystanders, interested parties and
potential clients. Zope
Since I posted this this morning I have since figured out a way to fix
it. The LoginManager was referencing a class in AccessControl/Users.py
called Super, but in Zope 2.3 this class is called UnrestrictedUser.
This introduced a new error which tracedback to HTTPRequest.py. I know
it is
in python you can do:
str(int)
and in zope you do it like
_.str(int)
You can also use the short form in both Zope and Python:
`int`
Two of those funny `` characters surrounding what you want converted to a
string.
The backtick notation `` is actually the shorthand for repr(), not
I have a question, for anyone experienced in working with Zope and caching
proxies:
I'm setting up a load-balanced server farm that has nodes that will run
Apache and proxy (via mod_proxy) to ZEO clients running ZServer. This farm
is routed (both ways) through a layer 4 load-balancing
[EMAIL PROTECTED] wrote:
I have a question, for anyone experienced in working with Zope and caching
proxies:
I'm setting up a load-balanced server farm that has nodes that will run
Apache and proxy (via mod_proxy) to ZEO clients running ZServer. This farm
is routed (both ways) through a
Perhaps I'm missing something fundamental, but I can't seem to figure out
how to add products to EMarket 0.1.04b1 running on Zope 2.2.2
Everything installed just fine and I can add an EMarket object, but I don't
see where, or how I go about adding things to sell. I don't care about the
auction
Sorry.. it's my fault for not providing better docs.. sadly
it's not been something I've had time for... esp since all the
ZPatterns changes were added.
1) Create ZClasses for your MarketItems, Baskets, BasketItems and Shoppers
(be sure to subclass from ZPatterns:DataSkin)
2) In the Racks
Dirksen writes:
dtml-call "REQUEST.set('a', '\"b\"')" won't work! Please help.
You can use the "octal escape sequence" for any character.
For " it is \042.
Thus,
dtml-call "REQUEST.set('a', '\042b\042')"
will work.
Dieter
___
Zope maillist -
Hmm. That's been my thought on squid as well, given its ground-up design
for caching in the first place. My worry, though, is that with squid I lose
support for virtual hosts on seperate boxes, because I need to support Zope,
static content, and some legacy stuff running ColdFusion on an NT
On 8 Jan 2001 08:22:15 -0800 LARRY CHUON [EMAIL PROTECTED] wrote:
Hi all,
Thank you John for your quick reply to my previous email. I've tried
out both of your suggestions below. It still does work. I might have
done something incorrectly as I am very new to these stuffs. Here are
the
Olaf Zanger writes:
Dies ist eine mehrteilige Nachricht im MIME-Format.
--865D189079029FB9A426EFA9
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Please do not post MIME messages!
expr="fac_browse_method.sql(id=10)" zope gernerates an error.
Hi!
it seems that you have problems to access the server-sided part of ZClassReverse (I
know I have to refine the error messages)
Check out if you can correctly access the server-sided part of ZclassReverse, point
your
browser to the following (of course fill in your specific host,port and
[Note: I assume posts can't be made using the egroups web post form?
I see the note that it is a remote list, but if posts never work
maybe a note specifically stating it is an archive only should be
displayed?]
Hi,
Yesterday I saw a demo of an Intranet package a company wants the company
I
dtml-call "myMethod.manage_proxy('Manager')" only ends in this error:
You are not authorized to change myMethod because you do not have proxy roles.
even though I'm calling the above statement in Manager role. Is it possible to do that?
Dirksen
Do I need to have ZPatterns installed to use Emarket 0.1.04b1? I thought
Zpatterns was only needed for EMarket 0.2.
Jamey
-Original Message-
From: Steve Spicklemire
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: 1/8/2001 4:25 PM
Subject: [Zope] Re: EMarket
Hi Jamey,
Sorry.. you're right. I haven't used 0.1.x in quite a while.
Have you tried just using the administrative interface
to add a MarketItem in the marketItems folder?
-steve
"James" == James Sintz [EMAIL PROTECTED] writes:
James Do I need to have ZPatterns installed to use
The following is my selection list, where should i
put the dtml-var custcountry in order to display the selected
result.
select name="custcountry" size="1" tabindex="9"
style="HEIGHT: 22px; WIDTH:
293px"
option value="."selectedPlease select a
country/option
option
On Tuesday 09 January 2001 16:01, Angietel wrote:
The following is my selection list, where should i put the dtml-var
custcountry in order to display the selected result.
Ooh... this one hurts.. (o8
You have to put "SELECTED" on the 'option' tag you want to be default.
This means iterating
GET YOUR OWN 100 MEG WEBSITE FOR ONLY $11.95 PER MONTH TODAY!
STOP PAYING $19.95 or more TODAY for your web site, WHEN YOU CAN
GET ONE FOR ONLY $11.95 PER MONTH!
DO YOU ALREADY HAVE A WEBSITE? ALL YOU HAVE TO DO IS TRANSFER THE
DOMAIN TO OUR SERVERS AND UPLOAD YOUR DATA AND YOU ARE READY TO
At 13:01 9-1-01 +0800, Angietel wrote:
The following is my selection list, where should i put the dtml-var
custcountry in order to display the selected result.
You don't have to, as soon as one option is selected you're variable
custcountry gets the value from option value="Canada" and the
hi there
Smith Ray schrieb:
* Runs on Windows NT/2000 only. (Zope can + many others)
yes
* Uses MS IIS only (I believe Zope can use IIS + built in web server +
others)
apache, zserver, iis
* Uses MS SQL Server (I believe Zope can + built in DB + others)
zope with mysql, postgresql,
85 matches
Mail list logo