On my database with the following table:
test(id, name, rt) containing one row: ('1', 'a11', 'ddfsdf') the
following query:
select CAST((SELECT name from test LIMIT 0,1) as CHAR);
returns 'a11' as its supposed to, but in SqlMap the query returns nothing.
The query:
select CAST((SELECT NOW()) as CHAR);
works in SqlMap, if that helps find the bug.
Regards,
Ole
|