Checkbox and Optional Field Submit Processing
237315Dec 1 2004 — edited Oct 11 2006 I have a PL/SQL function Returning a SQL Query. A couple of the columns seem to be causing problems on Submit Processing.
1) I have a checkbox - htmldb_item.CHECKBOX(3,answer,decode(answer,''Y'',''CHECKED'',''N'')) "ANSWER",
2) Optional Field DECODE(Q.NOTES_ALLOWED,''N'',A.NOTES,htmldb_item.text(5,A.NOTES,50,4000)) "NOTES"
The Submit Processing only seems to work if the checkbox and notes are populated. Anything else like NVL(htmldb_application.g_f03(i),'X') = 'X' seems to be totally ignored and I get a ORA-01403: no data found.
So after all that my question is how do I handle the unchecked checkbox (set the value to 'N') and the filed with no notes ?
Thanks
Paul