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 21:32 Go to next message
Hugo Araujo is currently offline Hugo AraujoFriend
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 15:38 Go to previous messageGo to next message
Michael Williams is currently offline Michael WilliamsFriend
Messages: 1925
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?
Re: decode string of a parameter value [message #1005498 is a reply to message #1005477] Fri, 25 January 2013 17:08 Go to previous messageGo to next message
Hugo Araujo is currently offline Hugo AraujoFriend
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 20:29 Go to previous message
Michael Williams is currently offline Michael WilliamsFriend
Messages: 1925
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.
Previous Topic:BIRT 3.7.1 and Java 7 support
Next Topic:Web Viewer Fails to Aggregate
Goto Forum:
  


Current Time: Mon Sep 26 01:58:38 GMT 2016

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

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