Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » 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.

Report message to a moderator

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?

Michael

Developer Evangelist, Silanis

Report message to a moderator

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

Report message to a moderator

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.

Michael

Developer Evangelist, Silanis

Report message to a moderator

Previous Topic:BIRT 3.7.1 and Java 7 support
Next Topic:Web Viewer Fails to Aggregate
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Feb 01 13:32:38 GMT 2023

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

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

Back to the top

Sign up to our Newsletter

A fresh new issue delivered monthly