function DeleteRow()
{
var cn = new ActiveXObject("ADODB.Connection");
var strConn = "PUTSQLCONNECTIONSTRINGHERE";
cn.Open(strConn);
var rs = new ActiveXObject("ADODB.Recordset");
var SQL = "delete from Requests where referenceID="+XDocument.DOM.selectSingleNode("dfs:myFields/dfs:dataFields/d:Requests/@referenceID").text;
rs.Open(SQL, cn);
var SQLnew = "delete from furtherTracking where referenceID="+XDocument.DOM.selectSingleNode("dfs:myFields/dfs:dataFields/d:Requests/@referenceID").text;
rs.Open(SQLnew, cn);
cn.Close();
}
That code deletes a row from the database. Now, with similar code, shouldnt I be able to query the database and select the largest number. However if I used "select" rather than delete, how would I store the result, in a dataset? I think I've got somewhat of a general concept here, but I need some help actually writing the code...