Android Question Multiple insert into the table using httputils.download2 failing

[Juzer Hussain]

Hi Guys,

I am trying to insert multiple records using Download2 routine.When i pass just one record it inserts successfully, but when i pass multiple records like insrert into myTable(f1,f2) Values(.... . .....), (.... . .....)
it fails and gives Error
HTTP Error 403.0 - ModSecurity Action
I guess this is not B4x issue as i tried from browser also and it gives same error.
Can anyone help on this.
Juzer

 

[Erel]

This error means that ModSecurity which is a PHP plug-in rejected your request. Are you using a shared hosting?

 

[Juzer Hussain]

Yes Erel,

I am using Shared Hosting.
Now
I was updating one temporary table with long concatenated string.
I will put the data in the actual table from a stored procedure which i will call after insert.

This probably will work i am stuck at string type variable accepting only 254 length.
is it so ? Shall i use Stringbuilder instead ??

Juzer

 

[sorex]

you should only send over the data, not the entire insert query strings.

also make sure you POST and not use GET which is limited.

 

[Juzer Hussain]

Sorex,
Thanks
I m sending data only
Juzer

 

[Juzer Hussain]

Hi,

That wasn't any issue. String truncating at 254 size. Its actually that much only is "Displayed" out of the full string.
It is storing the full string.
I am using SQL Query Analyzer.

Thanks

Juzer