HOw write sql sentence to get data from web service

Question

I am trying to get some data from a web service:

 $.ajax({
        type: 'POST',
        contentType: 'application/json;', 
        url: 'http://***.asmx/GetJSONString',
        data: "Select * from con",
        crossDomain:true,
        dataType: 'json',
        success: function(response) { 
            alert(response); 
        },
        error: function(XMLHttpRequest, textStatus, error) {
            alert("Error");
        }            
    });

where/how i have to write sql? in data?

It's not secure way to do queries like that. You should send some variables to file and then do your sql — vinculis, May 24 '12 at 10:12

score 1 · Answer 1 · answered May 24 '12 at 10:08

1

Yes but you forgot to pass a POST param name

It can be object:

data: { sqlQuery: "Select * from con" }

Or string:

data: "sqlQuery=Select * from con"

Now in your server side you will get POST variable sqlQuery with your SQL string.

Read more about $.ajax.

answered May 24 '12 at 10:08

antyrat

27,479
9
75
76

thanks for your answer but it still not workingt the error says : Origin null is not allowed by Access-Control-Allow-Origin. – Mikelon85 May 24 '12 at 10:16
thaks! but still not working. I´m starting to thin that is web-service problem. – Mikelon85 May 24 '12 at 10:26

score 1 · Answer 2 · answered May 24 '12 at 10:21

1

you have to pass this paramater as json string .. you can do this as

d={ sqlQuery: "Select * from con" }
$.ajax({
    type: 'POST',
    contentType: 'application/json;', 
    url: 'your url',
    data: JSON.stringify(d),
    crossDomain:true,
    dataType: 'json',
    success: function(response) { 
        alert(response); 
    },
    error: function(XMLHttpRequest, textStatus, error) {
        alert("Error");
    }            
});

answered May 24 '12 at 10:21

gsagrawal

2,900
4
27
27

thaks! but still not working. I´m starting to thin that is web-service problem. – Mikelon85 May 24 '12 at 10:26
what error are you getting ?? ..it will not work unless your service has string parameter sqlQuery – gsagrawal May 24 '12 at 10:27
XMLHttpRequest cannot load http://*** Origin null is not allowed by Access-Control-Allow-Origin. – Mikelon85 May 24 '12 at 10:29
check this .. http://stackoverflow.com/questions/3595515/xmlhttprequest-error-origin-null-is-not-allowed-by-access-control-allow-origin – gsagrawal May 24 '12 at 10:32

HOw write sql sentence to get data from web service

2 Answers2