Retrieving LONG BLOB DATA from a remote database.

chubbinius027

New Member
I'm having a trouble in retrieving a long blob data from a remote database of a website(in my case i used a free web hosting site i created) where in I'm accessing it using WiFi Connection using the code from this http://www.b4x.com/forum/basic4andr...connect-android-mysql-database-tutorial.html thread of Admin Erel, I can successfully retrieve structured data such as Varchar data and Int data, but when i changed the query and select and retrieve these long blob data (which are unstructured data) I got an error. I could not retrieve the long blob data for me to store it in a variable after querying.

I tried using the StringUtils class and the DecodeBase64 method to remedy the error but again, it didn't worked.

Could i possibly manipulate it in the PHP script or in the Activity Module codes? How?

And after retrieving the long blob data how could i convert it in its original file type (e.g. sample.doc)?

Attached are the codes of my Activity Module accessing the PHP Script and the PHP Script itself.

Please help me. THANK YOU. PLEASE....
 

Attachments

  • ActivityModuleCode.txt
    3.1 KB · Views: 269
  • mysqlconnection_getfilesphp.txt
    674 bytes · Views: 274
Last edited:
Top