Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » decode string of a parameter value
decode string of a parameter value [message #1005325] Thu, 24 January 2013 16:32 Go to next message
Hugo Araujo is currently offline Hugo Araujo
Messages: 6
Registered: December 2012
Junior Member
I'm receiving a parameter that have been encoded in an external google script.
In my initialize script in birt, i have the following code:

var cliente = new String(params["Cliente"].value);
var aux = new String(decodeURIComponent(cliente));
params["Cliente"].value = aux;


I just want to decode the parameter and set a new value.
After several tries, i get this error all the time:

org.eclipse.birt.report.engine.api.EngineException: Cannot execute the statement. org.eclipse.birt.report.data.oda.jdbc.JDBCException: SQL statement does not return a ResultSet object. SQL error #1:[SQL0302] Erro de conversão na variável ou parâmetro *N. ; java.sql.SQLException: [SQL0302] Erro de conversão na variável ou parâmetro *N. (Element ID:591)

The portuguese part says: error convesion in variable or parameter *N.

What am i doing wrong? Any idea?

Thanks in advance.
Re: decode string of a parameter value [message #1005477 is a reply to message #1005325] Fri, 25 January 2013 10:38 Go to previous messageGo to next message
Michael Williams is currently offline Michael Williams
Messages: 1424
Registered: July 2009
Senior Member

Have you output the value of your conversion to the console, report design, or logs or something, so you know what the value looks like?

Michael
Actuate – The BIRT Company™

BIRT Developer Center
Check out the new, free BIRT Viewer Toolkit
Re: decode string of a parameter value [message #1005498 is a reply to message #1005477] Fri, 25 January 2013 12:08 Go to previous messageGo to next message
Hugo Araujo is currently offline Hugo Araujo
Messages: 6
Registered: December 2012
Junior Member
thank you for replying, but how do you output da value? i try messagebox, alert but nothing worked
Re: decode string of a parameter value [message #1005817 is a reply to message #1005498] Mon, 28 January 2013 15:29 Go to previous message
Michael Williams is currently offline Michael Williams
Messages: 1424
Registered: July 2009
Senior Member

You could do the conversion in a dynamic textbox in your design and show the value that way or you could write the value out to a text file using java.io. Those are a couple of options.

Michael
Actuate – The BIRT Company™

BIRT Developer Center
Check out the new, free BIRT Viewer Toolkit
Previous Topic:BIRT 3.7.1 and Java 7 support
Next Topic:Web Viewer Fails to Aggregate
Goto Forum:
  


Current Time: Wed Apr 16 18:55:05 EDT 2014

Powered by FUDForum. Page generated in 0.01761 seconds