This is a migrated thread and some comments may be shown as answers.

mySQL AES Issue

2 Answers 35 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Ching-Yen
Top achievements
Rank 1
Ching-Yen asked on 16 Jan 2008, 06:56 AM
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

Sort by
0
Svetoslav
Telerik team
answered on 16 Jan 2008, 08:34 AM
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
0
Ching-Yen
Top achievements
Rank 1
answered on 17 Jan 2008, 10:16 AM
Thanks.
Tags
General Discussions
Asked by
Ching-Yen
Top achievements
Rank 1
Answers by
Svetoslav
Telerik team
Ching-Yen
Top achievements
Rank 1
Share this question
or