I have a BLOB data field in a mySQL table. The field name is IVRResponses. When I try to convert this binary data into string i get the following error:-
Invalid procedure call or argument: 'AscB'
The following is my code
Set statsanswered = Server.CreateObject("ADODB.Recordset")
statsanswered.ActiveConnection = MM_dsn1_STRING
statsanswered.Source = "SELECT IVRResponses FROM mortgage_ldstats WHERE result = 'answered';"
statsanswered.CursorType = 0
statsanswered.CursorLocation = 2
statsanswered.LockType = 1
Do While Not statsanswered.EOF
For Each stats In statsanswered.Fields
For I = 1 To LenB(stats.value)
S = S & Chr(AscB(MidB(stats.value, I, 1)))