This is how it works for MySQL:
insert into org (org_name, org_phone) values ('x', 'y')
dtml-var sql_delimiter
select LAST_INSERT_ID() as org_id
You have to have the select LAST_INSERT_ID call in the same query as the
insert, and you have to have the sql_delimiter.
I assume you know that the
What if you have 1,000,000 requests/sec?
What if between the INSERT and the LAST_INSERT_ID() another INSERT is made?
I use PostgreSQL and with postgres you can always ask the sequence what
the next id is going to be. It goes something like this::
next_id = context.GetNextId()[0].next_id
Peter Bengtsson wrote:
What if you have 1,000,000 requests/sec?
What if between the INSERT and the LAST_INSERT_ID() another INSERT is made?
I use PostgreSQL and with postgres you can always ask the sequence what
the next id is going to be. It goes something like this::
next_id =
Aloha,
Is this even easier solution only for postgreSQL, or is it for MySQL?
I am going to have to start working with integrating MySQL into
zope-based stuff soon so I'm trying to get a head start... :-)
thanks,
John S.
Tino Wildenhain wrote:
Peter Bengtsson wrote:
What if you have
Comment on Peter's suggestion: I am no expert on these things, but it is
my understanding that for MySQL LAST_INSERT_ID() fetches the last
autoincrement value made by the current insert, so the outcome is not
affected by virtually simultaneous requests. And I don't think MySQL
accepts a value
Hi all!
Is possible to create an object (for example a Page Template) and make
it catalog aware?
I wonder why the objects aren't catalogable by default (I need all my
object catalogables)
Any Idea?
--
Mis Cosas
http://blogs.sistes.net/Garito
--On 18. Juli 2006 15:14:54 +0200 Garito [EMAIL PROTECTED] wrote:
Hi all!
Is possible to create an object (for example a Page Template) and make it
catalog aware?
Look at the CatalogAware mixin class.
I wonder why the objects aren't catalogable by default (I need all my
object
Hi!
I am trying to run a external python script. Now I am facing a problem
that occurs only when I run the script via Zope.
...
import os,tarfile
...
tar = tarfile.open(oname,r:gz)
for itar in tar:
tar.extract(itar.name,jobdir)
gives me:
Site Error
An error was encountered while
--On 18. Juli 2006 16:12:18 +0100 Alan [EMAIL PROTECTED] wrote:
Error Type: IOError
Error Value: CRC check failed
This is unlikely a Zope issue. Either your tar file is broken or the
tarfile module is broken. Check if your code runs without Zope as a
simple PythonScript..there is nothing
Dear Exalted Sirs and Madams,
I'm a Zope newbie, so be gentle.
I'm using DTML on Zope (yes I know Plone and Tal is now the norm) and
I was wondering if regularly using the REQUEST(set and get) object is
bad practice.
I'm mostly a C++ programmer and I know of the horrors of global
variables,
--On 18. Juli 2006 13:33:59 -0400 Muk Yan [EMAIL PROTECTED] wrote:
Dear Exalted Sirs and Madams,
I'm a Zope newbie, so be gentle.
I'm using DTML on Zope (yes I know Plone and Tal is now the norm) and
I was wondering if regularly using the REQUEST(set and get) object is
bad practice.
It's
Getting this error when trying to install any Products in Plone site.Doesn't happen on newly created Plone site in same Zope Instance.Zope 2.8.5 Python 2.4.2 Plone 2.1.2Any help would be great.
Thanks
___
Zope maillist - Zope@zope.org
Muk Yan wrote:
Dear Exalted Sirs and Madams,
I'm a Zope newbie, so be gentle.
I'm using DTML on Zope (yes I know Plone and Tal is now the norm) and
No, Plone has nothing to do with TAL (although it uses it too)
But nobody forces you to DTML either. You can use python scripts
and ZPT (TAL)
I'm trying to get a handle on Zope and don't understand the rational behind the
manage_changeProperties() method.
Why, given an object called myObject with a title property, can I not change
the title by saying simply:
myObject.title='The new title'
On 18 Jul 2006 19:12:54 -, [EMAIL PROTECTED]
[EMAIL PROTECTED] wrote:
Why, given an object called myObject with a title property, can I not change
the title by saying simply:
myObject.title='The new title'
You can. Property sheets are aimed at ease of changing through the
web; it is a
Hi,
Id like to log certain parts of
each request into a database table for every request to provide an audit trail.
I thought of inserting a
dtml-call xxx into the standard_html_header, but when there is a
RESPONSE.redirect, it will not be the original request that gets logged.
Joshua Burvill wrote:
Hi,
I’d like to log
certain parts of
each request into a database table for every request to provide an
audit trail.
I thought of
inserting a
dtml-call xxx into the standard_html_header, but when there is
a
RESPONSE.redirect, it will not be the
zope-2.8.8
freebsd-4.11
okay I've followed the directions on the zope website, in the PDF, and
the Zope/doc docs. Could not really find the proper cure.
Then I made an instance and placed it in /usr/local/www/Zope
Started zope and the username and password does not work.
there is an
Noah wrote:
zope-2.8.8
freebsd-4.11
okay I've followed the directions on the zope website, in the PDF, and
the Zope/doc docs. Could not really find the proper cure.
Then I made an instance and placed it in /usr/local/www/Zope
Started zope and the username and password does not
Log message for revision 41497:
Added url summary statistics.
Added HTML output that makes it easy to jump from a URL shown in a
minute detail to the statistics for that URL.
Changed:
U Zope/trunk/utilities/tracelog.py
-=-
Modified: Zope/trunk/utilities/tracelog.py
Log message for revision 69089:
* returning the correct old value for LOG
Changed:
U Zope/branches/2.9/lib/python/Products/ZCatalog/ZCatalog.py
-=-
Modified: Zope/branches/2.9/lib/python/Products/ZCatalog/ZCatalog.py
===
21 matches
Mail list logo
