Skip to main content



      Home
Home » Archived » 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
Eclipse UserFriend
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
Eclipse UserFriend
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?
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
Eclipse UserFriend
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
Eclipse UserFriend
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.
Previous Topic:BIRT 3.7.1 and Java 7 support
Next Topic:Web Viewer Fails to Aggregate
Goto Forum:
  


Current Time: Wed Mar 26 08:03:50 EDT 2025

Powered by FUDForum. Page generated in 0.05186 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top