xsl-list
[Top] [All Lists]

Breaking from the for-each loop in transformer

2005-08-11 21:32:22
Hi,

I am trying to fix bug in Cocoon [2.0.4] app and XSL1.0.
XSSF transformer reads Excel XLS file and then we insert the data into
the database
table using SQLTransformer.
This particular date column is NOT nullable, so now it now populates
it with trunc(sysdate)
if the data in XSL is in wrong format or the cell is not of DATE type.

But that Data is extremely important to business, so what I am trying to do is
to break out of creating insert and show the user an error message to
fix XLS file.

I am inside the for-each loop (going through cells in row) in SQL transformer.
That row processing is triggered by apply-template.
I am trying to break out of the loop like:
using redirect to "my_url?error=1", and on that form I try to handle that error
but for some reason it's not redirecting.

Also tried to populate that DB column with null to create SQL exception
and than put xsl handle-error block in the pipeline in XMAP, 
but that still doesn't resirect to an error page.

Any suggestions ?

Thank you in advance,
Oleg.

--~------------------------------------------------------------------
XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--



<Prev in Thread] Current Thread [Next in Thread>
  • Breaking from the for-each loop in transformer, Oleg Konovalov <=