ASP Classic and updaterow

[RedantJParticipant]

I feel like I’m close. What I want to do is POST to a new page, so that I can do a server SQL request:

In my main page:

                updaterow: function (rowid, newdata, commit) {
                    // synchronize with the server - send update command
                    // call commit with parameter true if the synchronization with the server is successful 
                    // and with parameter false if the synchronization failed.
					
					$.ajax({
						dataType: 'json',
						url: "update.asp",
						data: newdata,
						type: "POST",
					});
					
                    commit(true);
                }

In my update.asp page:

<%dim strbarCode, strID

strID = Request("ID")
strbarCode = Request("barCode")

sql =  "UPDATE tblHoldingBin SET Bar_Code = " & strbarCode & " WHERE OrderID = " & strID 
set rs = conn.Execute(sql)%>

Any ideas how I can make this work?

[DimitarParticipant]

Hello RedantJ,

Unfortunately, we do not have any examples of integration between jQWidgets and ASP Classic. This does not mean they cannot be integrated, though.

Best Regards,
Dimitar

jQWidgets team
http://www.jqwidgets.com/

[RedantJParticipant]

I’m thinking about a workaround of this problem using POST. If I’m able to POST the data that I need to update.asp, then it would just be a matter of requesting the data and I can continue onwards. I didn’t have any time this week to try it out this week on account of other priorities. I’ll post up when I succeed.

[RedantJParticipant]

Update: The Ajax POST method does work and will require some tinkering. I am dealing with an issue that is Microsoft Access / IIS related at the moment.

[RedantJParticipant]

After dealing with priorities, I’m back at work on this project.

The IIS issue has been resolved. I’m still perfecting the code, the following works pretty good:

Main page:

               updaterow: function (rowid, newdata, commit) {
                    // synchronize with the server - send update command
                    // call commit with parameter true if the synchronization with the server is successful 
                    // and with parameter false if the synchronization failed.
					$.ajax({
						type:"POST",
						url: "update.asp",
						data: newdata,
							success : function(d) {
			                    commit(true);
								alert("updated!");
							}
						});
                }

….and on Update.asp:

<%dim conn, strFoo1, strFoo2

Set conn = Server.CreateObject("ADODB.Connection")
conn.Mode = 3

strFoo1 = Request.Form("Foo1")
strFoo2 = Request.Form("Foo2")

Conn.open "PROVIDER = MICROSOFT.JET.OLEDB.4.0;DATA SOURCE = C:\inetpub\wwwroot\HoldingBin\InvntryData.mdb"

sql = "INSERT INTO tblTable (Foo1, Foo2) "
sql = sql + "VALUES ('" & strFoo1 & "','" & strFoo2 & "')"

conn.Execute(sql)	
conn.close

There is still a lot of tinkering to do. The ajax passes on the data to update.asp the way I expected it to do, the SQL statement needs work, and I’m pretty sure I will need to add an index column for this to work right. I’m a few steps closer to where I need to be.

Thanks guys!

[RedantJParticipant]

It looks like what I will need to implement for ASP Classic will be similar to this. I will work on it for the rest of the week.

(The wheels are turning, however slowly)

[RedantJParticipant]

And that’s done:

When generating a blank row:

	var generaterow = function (i) {
        var row = {};
	row["idxUID"] = i;
	row["foo1"] = "";
        row["foo2"] = "";
        return row;
	}

and here:

            // create new row.
            $("#addrowbutton").bind('click', function () {
		var rowscount = $("#jqxgrid").jqxGrid('getdatainformation').rowscount;			
                var datarow = generaterow(rowscount + 1);
		var commit = $("#jqxgrid").jqxGrid('addrow', null, datarow);
            });

…when using it inside of a function, for example addrow:

	var data = "action=insert&" + $.param(rowdata);
	$.ajax({
		type: "GET",
		url: "controller.asp",
		data: data,
		success : function(d) {
			commit(true);
			alert("added!");
		}
	});
        },

This generates:

http://localhost/blah/controller.asp?action=insert&idxUID=41&foo1=&foo2=

Which makes controller.asp:

<%dim conn, strIndex

Set conn = Server.CreateObject("ADODB.Connection")

strIndex = Request.QueryString("idxUID")
strAction = Request.QueryString("action")

Conn.open "PROVIDER = MICROSOFT.JET.OLEDB.4.0;DATA SOURCE = C:\blah\FooData.mdb"

intComp = StrComp(strAction, "insert", vbTextCompare)

if (intComp = 0) then
	sql = "INSERT INTO tblTable (index) "
	sql = sql + "VALUES (" & strIndex & ")"
	conn.Execute(sql)	
end if

conn.close

So now it works!

[DimitarParticipant]

Hi RedantJ,

Thank you for your contribution to the forum.

Best Regards,
Dimitar

jQWidgets team
http://www.jqwidgets.com/

[RedantJParticipant]

One more thing:

As far as security goes, using GET in your ajax isn’t secure. I would use GET for testing purposes (to be sure the data is going from your grid to your controller). For a more secure page, use POST:

(this is addrow)

		var data = "action=insert&" + $.param(rowdata);
		$.ajax({
			type: "POST",
			url: "controller.asp",
			data: data,
			success : function(data, status, xhr) 
			{
		                commit(true);
			},
			        error: function(jqXHR, textStatus, errorThrown)
			{
				commit(false);
			}
		});
                },

and in controller:

strIndex = Request.Form("idxUID")
strAction = Request.Form("action")

And now it’s more secure.

[sergio57Participant]

RedantJ,
I’m interested to integrate jqxgrid with classic asp, and I wanted to ask you if it was possible to have the scripts that you mention here, (update, delete, insert in the database with asp classic) in order to study them.
If you think it’s possbile to do this I thank you in advance
Good day and greetings

[Author]

Posts