Hello When using sql filter, the ' are replace with '' .
But there is little problem, when using "&" in the field. Perhaps it's not a bug. Nevertheless, when you add a sqlMyField "-- youger & older people", the & is considerer a prompt for a value. We can says that's the problem come from sqlplus, but as it widely use, perhaps il should be filtered too ? eventhandler.referenceinsertion.class = org.apache.velocity.app.event.implement.EscapeSqlReference eventhandler.escape.sql.match = /sql.*/ André.
