SELECT AES_DECRYPT(uPassword, 'myPassword') AS usrPassword
FROM tbluser
We are trying to use the mySQL database with Telerik Report, but, we are getting error when we using the SQL Statement as above.
But, in the report, it only show
"System.Byte[]" rather than the real value. Please advice.
2 Answers, 1 is accepted
0
Hi Ching-Yen,
Telerik Reporting does not connect to any database itself but depends on ADO.NET's DataSets and DataAdapters. So if you experience any error with your SQL statement you have to verify it against the specific database engine (MySQL in your case).
Regarding the TextBox - it renders the result of its Value expression as a string (result.ToString()). So if the value evaluates to System.Byte[] we do not know how to display it in a TextBox except converting it to string. You can change this behavior with a user defined function where you can convert your byte[] to the expected string.
All the best,
Svetoslav
the Telerik team
Instantly find answers to your questions at the new Telerik Support Center
Telerik Reporting does not connect to any database itself but depends on ADO.NET's DataSets and DataAdapters. So if you experience any error with your SQL statement you have to verify it against the specific database engine (MySQL in your case).
Regarding the TextBox - it renders the result of its Value expression as a string (result.ToString()). So if the value evaluates to System.Byte[] we do not know how to display it in a TextBox except converting it to string. You can change this behavior with a user defined function where you can convert your byte[] to the expected string.
All the best,
Svetoslav
the Telerik team
Instantly find answers to your questions at the new Telerik Support Center
0
Ching-Yen
Top achievements
Rank 1
Rank 1
answered on 17 Jan 2008, 10:16 AM
Thanks.