|
Subject:
|
Invalid procedure call or argument: 'AscB'
|
|
Posted By:
|
harish3699
|
Post Date:
|
12/10/2003 12:21:01 PM
|
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
|
|
Reply By:
|
bmains
|
Reply Date:
|
1/28/2004 12:29:29 PM
|
Try:
'Subtract one from length value
for I = 1 to LenB(stats.Value) - 1
S = S & ...
next
I believe the ascB function may be trying to access data that isn't there.
Brian
|
