Android Question problem with Save blob with query

[azzam223]

Hi

I want To save blob with query command but I write the query to save the blob the problem is shown

note: I use mssqlserver example with asp file

Public Sub UploadImage(data() As Byte,Mrid As Int)
Try
Dim query As String=$"AddReportImages[${Mrid}],[${data}],[img${Mrid}],[.jpg],[Null]"$
job.Initialize("UploadImage",Me)
job.PostString(ServerUrl,query)
DoEvents
Catch
Log(LastException)
End Try
End Sub

Can Anyone help me?

 

[Erel]

Please use [code]code here...[/code] tags when posting code.

There is no need to call DoEvents here.

Are you using the PHP script from the MySQL tutorial? It doesn't support blobs. You should instead use RDC or jRDC which does support blobs.

 

[azzam223]

hello erle

I am sorry I forget Add code tags

i am use asp script from msSqlserver tutorial not mysql

buy about rdc my web site doesn't support java can i use RDC or not

 

[Erel]

The asp script doesn't support blobs as well. You can modify it with some asp.net knowledge. You will need to covert the blob to base64 string with StringUtils and then convert it back in the asp.net script.

RDC requires java. If you have SSH access then you will probably be able to run RDC on your server.

 

[azzam223]

hi erel

i have encode the blob with base64 but when i send it to my site happen problem

Message longer than Log limit (4000)

 

[DonManfred]

What is the error of your problem.
The log output is limited to 4000 characters; that´s not a bug.
Save the result to a file and then read this file.

Maybe you just dont recognized that the hole result is available. You just cannot LOG everything (limited to 4000 characters)....

 

[azzam223]

thanks DonManfred

I will save result to file