Sorry the message was double posted..but good news!
Antoino, thanks for pushing me in that direction. I did not think the
modular DatabaseAddAction would handle unique keys, but it does (I had
to hunt through the source to find this out) I updated my descriptor
files to be compatible with
Hi,
Today morning I told you about the MODULAR Database Actions, also I
pointed you to:
http://wiki.cocoondev.org/Wiki.jsp?page=ModularDatabaseActions
There you can find ALL the info about how to do what you mean. Also I can
work with sequence (you told before you use PostgreSQL 7.2).
Sheraz Sh
and attempt to retreive the
key value before the insert. If it does not exist, it will insert it,
otherwise it will fail and I can notify the user of the error. Have I
been verbose enough? If no solution exists, I am thinking I can either
extend or rewrite the DatabaseAddAction class to do this
coon.
> 2. Cocoon processes form values.
> 3. Form values are ok, check the database to make sure primary keys and
> unique keys do not already exist
> 4. on success, insert values into database
> 5. on failure, return failure
>
> I am thinking that I need make some additio
: [EMAIL PROTECTED]
Subject: RE: DatabaseAddAction and unique or primary keys
I am using postgresql 7.2..
I am not sure what you mean. Are you talking about making the database
run a trigger before the insert happens? If so, I do not think that
will solve my problem. I want cocoon to realize
am thinking that I need make some additions to the DatabaseAddAction
class to make this happen.
Sheraz
On Fri, 2003-02-07 at 05:43, Kazmir, Jaroslav wrote:
> Which type of database you use? Isn't it easily to use before insert
> trigger?
>
> JayKay
>
> -Original Mess
Which type of database you use? Isn't it easily to use before insert
trigger?
JayKay
-Original Message-
From: Sheraz Sharif [mailto:[EMAIL PROTECTED]]
Sent: Freitag, 07. Februar 2003 12:19
To: [EMAIL PROTECTED]
Subject: DatabaseAddAction and unique or primary keys
Hello all,
Sor
the DatabaseAddAction class to do this. Or should I
abandon logicsheets all together and move to xforms? Thanks.
Sheraz
--
[EMAIL PROTECTED]
m3b Consulting
www.m3b.net
832.573.0937
-
Please check that your question has not
On 10.Dec.2002 -- 05:57 PM, Matthias Brunner wrote:
> On Tuesday 10 December 2002 17:19, Christian Haul wrote:
> > At least the one from the modular package does set the error
> > message as request attribute.
>
> Thanks for your reply. Do you know whether this is in 2.1 only? (I
> cannot grep "s
On Tuesday 10 December 2002 17:19, Christian Haul wrote:
> At least the one from the modular package does set the error
> message as request attribute.
Thanks for your reply. Do you know whether this is in 2.1 only? (I
cannot grep "setAttribute" in the source file but it could be hidden
in other
On 10.Dec.2002 -- 05:05 PM, Matthias Brunner wrote:
> Hello,
>
> is there any way to find out whether a DatabaseAddAction was
> successful / display the error message?
>
> I would like to do the following:
>
>
>
>
>
>
>
Hello,
is there any way to find out whether a DatabaseAddAction was
successful / display the error message?
I would like to do the following:
...
...
I do not want to have to different input sources dependent on whether
the
On 21.Jul.2002 -- 10:03 AM, Illia Auringer wrote:
> I have found a message from you in the Cocoon Mailing List where you
> put a solution how to accsess a manually generated key of a new
> table entry to insert it in a second table. I tried it like you said
> but it doesn´t work. Here is my proble
place where I installed
the Cocoon sources. If you don't have the Cocoon sources (thus, binaries
only), you must rely on the documentation of these Actions (...).
Hugo Burm
[EMAIL PROTECTED]
-Original Message-
From: Kenny Chow [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 21, 2002 9
I've read the tutorial but didn't see any "insert"
statement in the descriptor nor in the sitemap. The
descriptor file only maps parameter names to table
columns. So I am wondering how the insert was done.
Would someone point me to some related resources or
give a hint to mastering this action?
Title: RE: databaseaddaction...help me
Brilliant, thank you thank you thank you it works like a charm
jenny
-Original Message-
From: Christian Haul [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 05, 2002 9:51 AM
To: [EMAIL PROTECTED]
Subject: Re: databaseaddaction...help me
On 05.Apr.2002 -- 09:26 AM, Rolfe Jenny wrote:
> HttpProcessor[8080][3]/AbstractDatabaseAction: Setting column 2 named
> key:page:pageid with value null
>From this we can conclude that the value is not found. OK, the issue
is a bit complicated here. And you coudn't have known unless
inspecting th
Title: RE: databaseaddaction...help me
I've included the relevant section from the sitemap logs below. It looks as if the pageid is being saved as a sitemap parameter but it is not being picked up by 'key:page:pageid'. Now this database stuff is in the middle of a whole
On 04.Apr.2002 -- 04:31 PM, Rolfe Jenny wrote:
> Okay so what I want to do is use the default database add action to update
> two tables, in one I automatically generate an id then I want to also put
> this id into the second table. So here's what I do:
I think the modular database actions are st
Title: databaseaddaction...help me
Okay so what I want to do is use the default database add action to update two tables, in one I automatically generate an id then I want to also put this id into the second table. So here's what I do:
Title: Re: using MSQL's LAST_INSERT_ID() with DatabaseAddAction
I'm trying to do much the same thing as in the message beneath:
xcpt
What I want to do is automatically generate an id in one table and pick this
id up and put it in another table.
The
Title: Re: using MSQL's LAST_INSERT_ID() with DatabaseAddAction
I'm trying to do much the same thing as in the message beneath:
please forgive me if I've posted this twice!
xcpt
What I want to do is automatically generate an id in one table and pick
- Original Message -
From: "Christian Haul" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, March 01, 2002 3:38 PM
Subject: Re: using MSQL's LAST_INSERT_ID() with DatabaseAddAction
> On 01.Mar.2002 -- 03:34 PM, Giuseppe Di Pierri wrote:
> >
On 01.Mar.2002 -- 03:34 PM, Giuseppe Di Pierri wrote:
> Hi there,
>
> I have a problem using the DatabaseAddAction in MySQL.
>
> I would do two table insertions, one after an other like the following
> example:
The value is written to a request attribute (table.column) that
Hi there,
I have a problem using the DatabaseAddAction in MySQL.
I would do two table insertions, one after an other like the following
example:
INSERT INTO base (id,...) VALUES(NULL,...);
# id is defined as INT NOT NULL AUTO_INCREMENT
INSERT INTO derived (id,) VALUES(LAST_INSERT_ID
Hi all,
I'm trying to use the DatabaseAddAction to insert/update a record containing
a blob (an 'Image' in SQL Svr world) which content must be specified by a
file uploaded by the user (pretty common situation, right?). This is
obviously an image.
So I've had a look at th
26 matches
Mail list logo
