J junaidahmed Well-Known Member Licensed User Longtime User Mar 31, 2012 #1 As I am passing a sql string thru my querystring for the next page to capture in asp. example: www.xxxxxxxx.com/index.asp?str=select * from table where name like '%doe%' .Passing a basic string works fine in browser because its automatically Encode Example : For Space it EndCode as %20 etc.. But When I Execute from Basic4Android using Http Library it shows an error message Dim request1 As HttpRequest URL1 = www.xxxxxxxx.com/index.asp?str=select * from table where name like '%doe%' request1.InitializeGet(URL1) request1.Timeout = 10000 'set timeout to 10 seconds If HttpClient1.Execute(request1, TaskId) = False Then Return From the above code I Would like to know how to Encode Space and %.
As I am passing a sql string thru my querystring for the next page to capture in asp. example: www.xxxxxxxx.com/index.asp?str=select * from table where name like '%doe%' .Passing a basic string works fine in browser because its automatically Encode Example : For Space it EndCode as %20 etc.. But When I Execute from Basic4Android using Http Library it shows an error message Dim request1 As HttpRequest URL1 = www.xxxxxxxx.com/index.asp?str=select * from table where name like '%doe%' request1.InitializeGet(URL1) request1.Timeout = 10000 'set timeout to 10 seconds If HttpClient1.Execute(request1, TaskId) = False Then Return From the above code I Would like to know how to Encode Space and %.
vb1992 Well-Known Member Licensed User Longtime User Mar 31, 2012 #2 This library might help http://www.b4x.com/forum/additional...s/7029-new-stringutils-library.html#post40407 Upvote 0
This library might help http://www.b4x.com/forum/additional...s/7029-new-stringutils-library.html#post40407