Re: [SUMMARY] DatabaseAddAction and unique or primary keys

2003-02-08 Thread Sheraz Sharif
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

DatabaseAddAction and unique or primary keys

2003-02-07 Thread Sheraz Sharif
Hello all, Sorry if this gets double-posted... I have been working on a website for a while. Here is my problem - I can easily verify user input through forms and return any error messages through the xsp-formval tags. After validation, the input is passed to the database. However, I get an

RE: DatabaseAddAction and unique or primary keys

2003-02-07 Thread Kazmir, Jaroslav
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, Sorry

RE: DatabaseAddAction and unique or primary keys

2003-02-07 Thread Sheraz Sharif
[mailto:[EMAIL PROTECTED]] Sent: Freitag, 07. Februar 2003 12:19 To: [EMAIL PROTECTED] Subject: DatabaseAddAction and unique or primary keys Hello all, Sorry if this gets double-posted... I have been working on a website for a while. Here is my problem - I can easily verify user

RE: DatabaseAddAction and unique or primary keys

2003-02-07 Thread Kazmir, Jaroslav
- 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, Sorry if this gets double-posted... I have been working on a website for a while. Here is my problem - I can

RE: DatabaseAddAction and unique or primary keys

2003-02-07 Thread Antonio Gallardo
: DatabaseAddAction and unique or primary keys Hello all, Sorry if this gets double-posted... I have been working on a website for a while. Here is my problem - I can easily verify user input through forms and return any error messages through the xsp-formval tags. After validation, the input

DatabaseAddAction and unique or primary keys

2003-02-07 Thread Sheraz Sharif
Hello all, I have been working on a website for a while. Here is my problem - I can easily verify user input through forms and return any error messages through the xsp-formval tags. After validation, the input is passed to the database. However, I get an SQL exception : ProcessingException:

Re: DatabaseAddAction and unique or primary keys

2003-02-07 Thread Antonio Gallardo
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