C chubbinius027 New Member Jan 12, 2013 #1 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 ActivityModuleCode.txt 3.1 KB · Views: 360 mysqlconnection_getfilesphp.txt mysqlconnection_getfilesphp.txt 674 bytes · Views: 344 Last edited: Jan 13, 2013
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....
Erel B4X founder Staff member Licensed User Longtime User Jan 13, 2013 #3 For some reason you appear as an unlicensed user in the forum. Please contact [email protected] in order to fix it. Upvote 0
For some reason you appear as an unlicensed user in the forum. Please contact [email protected] in order to fix it.
