I cannot send query string to the servlet

[raghda]

hi every body,
i have a midlet that connect to a servlet to get data from sql database.
every thing works fine when i write the query string in the servlet;

String query ="SELECT col1,col2 From tb1";
and then excute the query in the servlet .

The problem that i need to send the query string as a parameter with the connection.
I tried this :
HttpConnection c = (HttpConnection) Connector.open(url+"?query="+query);

but i got this error : java.lang.IllegaArgumentException:Space character in URL

i understood from the error that i cannot send parameter that contain spaces but i donot know how to send the query in any different way.

plz guys i need urgent help

Thanks

[axs]

Try to convert spaces into the "%20" chars (the standard space replacement for the URL). That probably will require some parsing functionality on the servlet's side, but that's may be the simplest solution to your problem. Also note, that if you may use HTTP POSTs instead of GETs, then try to send SQL queries as the HTTP request parameter, rather then a part of URL.