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 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 15:38 Go to previous messageGo to next message
Michael Williams is currently offline Michael Williams
Messages: 1639
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

Add interactivity, scheduling, sharing, live Excel export, and JS integration to your BIRT app with the new, free BIRT server, BIRT iHub F-Type.
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 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 20:29 Go to previous message
Michael Williams is currently offline Michael Williams
Messages: 1639
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

Add interactivity, scheduling, sharing, live Excel export, and JS integration to your BIRT app with the new, free BIRT server, BIRT iHub F-Type.
Previous Topic:BIRT 3.7.1 and Java 7 support
Next Topic:Web Viewer Fails to Aggregate
Goto Forum:
  


Current Time: Thu Oct 23 05:23:23 GMT 2014

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

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