Thanks,
It would be nice to add this to the DIH FAQ
On Wed, Nov 4, 2009 at 8:27 PM, Jonathan Hendler
wrote:
> Thanks Chantal for the explanation of the issue.
> Avlesh - worked great. Thank you!
>
>
> On Nov 4, 2009, at 9:44 AM, Avlesh Singh wrote:
>
>> Try cast(concat(...) as char) ...
>>
>> Che
Thanks Chantal for the explanation of the issue.
Avlesh - worked great. Thank you!
On Nov 4, 2009, at 9:44 AM, Avlesh Singh wrote:
Try cast(concat(...) as char) ...
Cheers
Avlesh
On Wed, Nov 4, 2009 at 7:36 PM, Jonathan Hendler
wrote:
Hi All,
I have an SQL query that begins with "SELECT
Try cast(concat(...) as char) ...
Cheers
Avlesh
On Wed, Nov 4, 2009 at 7:36 PM, Jonathan Hendler wrote:
> Hi All,
>
> I have an SQL query that begins with "SELECT CONCAT ( 'ID', Subject.id ,
> ':' , Subject.name , ':L', Subject.level) as subject_name" and the query
> runs great against MySQL
Hi Jonathan,
the concatenation seems to return a byte array because those are
rendered into a string starting with "[B" when calling toString() on them.
I have no suggestion on how to get a different return value from that
sql query.
To concatenate you could also use a transformer. Simply r
Hi All,
I have an SQL query that begins with "SELECT CONCAT ( 'ID',
Subject.id , ':' , Subject.name , ':L', Subject.level) as
subject_name" and the query runs great against MySQL from the command
line.
Since this is a nested entity, the schema.xml contains "name="subject_name" type="strin
