Invalid procedure call or argument: 'AscB'
Hi,
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
statsanswered.Open()
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)))
Next
response.write(S)
Next
statsanswered.MoveNext
Loop
Thanks,
Harish
|