Database connection, SQL and BLOB

[Christian Lempereur]

I receive 'BLOB' as a result of a 'count(status)' in my SQL select statement.
TextPipe's Help says to try to use a subfilter with 'mime base64 encoding', I tried many of the possible encoding choices finally I got my result just using 'SUBSTRING(count(status),1,100)' instead of the 'count(status)'.

Data Base used was MySQL.

Thought it could be usefull for other members, as it is easy to implement.

best regards,
christian