SELECT AES_DECRYPT(uPassword, 'myPassword') AS usrPassword
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
answered on 16 Jan 2008, 08:34 AM
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.