Miary A
|
| Posted: 10/05/2002, 6:36 PM |
|
How do you populate a second table using the After Insert event in JSP?
I tried this:
PoolJDBCConnection ds = new PoolJDBCConnection("mysql_quotes");
SqlCommand c = new SqlCommand( ds );
StringBuffer sql = new StringBuffer( "INSERT INTO teamquote (q_id, t_id)
"
+ "VALUES (10 , 5)" );
c.setSql( sql );
c.executeUpdate();
ds.closeConnection();
It compiles fine, no error, but it does not insert the data.
Anyone?
|
|
|
 |
Ignat Skoryh
|
| Posted: 10/08/2002, 2:36 AM |
|
Hi!
Check if RecordListener was added to listeners Collection (at the head
of jsp). And check if fireAfterInsert() method is called in insert()
method of PageController class. Seems that your custom code just was not
called.
Miary A wrote:
> How do you populate a second table using the After Insert event in JSP?
>
> I tried this:
> PoolJDBCConnection ds = new PoolJDBCConnection("mysql_quotes");
> SqlCommand c = new SqlCommand( ds );
> StringBuffer sql = new StringBuffer( "INSERT INTO teamquote (q_id, t_id)
> "
> + "VALUES (10 , 5)" );
> c.setSql( sql );
> c.executeUpdate();
> ds.closeConnection();
>
> It compiles fine, no error, but it does not insert the data.
>
> Anyone?
|
|
|
|
|
