action execute in pages.xml

gvorsterman Oct 30, 2009 10:35 AM

In my page.xml

this code works, I get the id param in my method:

 <action execute="#{dbUtils.deleteULD(param.id)}"/>

but I want it like this, but it does not work:

<action execute="#{dbUtils.executeUpdate('update uld set uld_f_intake=false where id='+param.id)}"/>

Is it possible to do this?

1. Re: action execute in pages.xml

kapitanpetko Oct 30, 2009 11:44 AM (in response to gvorsterman)
guus vorsterman wrote on Oct 30, 2009 10:35:

<action execute="#{dbUtils.executeUpdate('update uld set uld_f_intake=false where id='+param.id)}"/>

Is it possible to do this?

Probably yes, but it is a very bad idea. Reasons:

that's SQL injection waiting to happen.

pages.xml is not where you want your SQL code to live

deleting something as a side effect of navigation is not a good idea either

Better rethink your design first. What are trying to achieve?
Actions