Archive for July, 2017
Converting a JavaScript date to the short format (US)
Posted by scottstoecker in JavaScript, jQuery on July 19, 2017
Messing around with JavaScript / jQuery, the date object I was getting back was the Ajax call was being returned in the format Year-Month-Day (2017-06-02). I wanted it Month-Day-Year (06/02/2017). So I created a JS Date object from the string returned, then call the “toLocaleDateString” method call. In this example, “d” is the variable returned from the Ajax call
... success: function(d) { if (d != null) { var date = new Date(d.Date); $("#Date").val(date.toLocaleDateString()); } }
Calling a .NET web service using jQuery
Posted by scottstoecker in .NET, C#, Error, jQuery on July 13, 2017
I was attempting to call a .NET web service using jQuery, but was getting this error message:
An attempt was made to call the method \u0027GetCoasters\u0027 using a GET request, which is not allowed
The key to fixing this was to attach the “ScriptMethod” attribute to the web service and setting the “UseHttpGet” property to “true”, which I show below:
[System.Web.Script.Services.ScriptService] public class OdometerService : System.Web.Services.WebService { [System.Web.Script.Services.ScriptMethod(UseHttpGet = true, ResponseFormat = System.Web.Script.Services.ResponseFormat.Json)] [WebMethod] public string GetCoasters() { return "Hello World"; } }
And here is me calling the web service – try to contain your excitement:
$.ajax({ type: "GET", url: "http://localhost:12345/CoasterService.asmx/GetCoasters", contentType: "application/json; charset=utf-8", dataType: "json", success: function (msg) { alert('Woohoo!'); }, error: function (e) { alert('Bad stuff - ' + e.responseText); } });
Passing a list of numbers into an Oracle procedure
I wanted to pass in a list of numbers to an Oracle procedure for use in an “IN” statement, called from C# code. First, the C# code:
string list = "1,2,3"; using (OracleCommand comm= new OracleCommand("MyProcedure", connection)) { comm.CommandType = CommandType.StoredProcedure; comm.Parameters.Add(":pList", OracleDbType.Varchar2, 50).Value = list; comm.Parameters.Add(":p_cursor", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
My Oracle procedure was equally awesome:
PROCEDURE MyProcedure(pList IN VARCHAR2, p_cursor OUT sys_refcursor) IS BEGIN OPEN p_cursor FOR SELECT name FROM coasters WHERE id IN (SELECT TO_NUMBER(column_value) AS IDs FROM XMLTABLE(pList)); END;
You can see the “FROM XMLTABLE” statement is doing all the good stuff of splitting the list into the appropriate format. Good times.
Recent Comments