PreparedStatement with sql.eachRow()

[Chetan Parekh]

Following is a code snippet of current implementation:

xq.message[0] = new XmlFactory([ACT_NS], ACT_NS).build {
  	STUDENTDATA{
		STUDENTS{
	    sql.eachRow( query as String  ) {
	        row ->
	             STUDENT() {
					FIRSTNAME( row.FIRST_NAME )
					LASTNAME( row.LAST_NAME )
					DATEOFBIRTH( row.DATE_OF_BIRTH )
                }
  			}   
		} 
	}
}

We want to use PreparedStatement to prevent SQL injection. How to use PreparedStatement with sql.eachRow()?

[Gregg Bolinger]

According to the API, you can't.