I am trying to access an SQL DB via a DSN. Here is my code and attached you will find the Schema:
var SearchVal = Request(“CaseNumber”);
tamino = new ActiveXObject(“TAMINOX.TaminoX1”);
tamino.Initialize();
tamino.csDatabaseURL(“http://mercury/tamino/dev/tmtest”);
query = “casemain[csm_caseno="”+SearchVal+“"]”;
dom = tamino.doQuery(query);
var caseNo = dom.getElementsByTagName(“csm_caseno”);
var caseType = dom.getElementsByTagName(“case_type”);
var nameFirst = dom.getElementsByTagName(“csm_name_first”);
var nameLast = dom.getElementsByTagName(“csm_name_last”);
var status = dom.getElementsByTagName(“csm_status”);
var updateBy = dom.getElementsByTagName(“csm_updateby”);
var updated = dom.getElementsByTagName(“csm_updated”);
var projNo = dom.getElementsByTagName(“csm_projno”);
Response.Write(“
Response.Write(“”);
Response.Write(“”);
Response.Write(“”);
Response.Write(“”);
Response.Write(“”);
Response.Write(“”);
Response.Write(“”);
Response.Write(“”);
Response.Write(“
| Case Number - | ” + caseNo.item(0).text + “ |
| Case Type - | ” + caseType.item(0).text + “ |
| First Name - | ” + nameFirst.item(0).text + “ |
| Last Name - | ” + nameLast.item(0).text + “ |
| Status - | ” + status.item(0).text + “ |
| Updated By - | ” + updateBy.item(0).text + “ |
| Updated - | ” + updated.item(0).text + “ |
| Project Number - | ” + projNo.item(0).text + “ |
Response.Write(“Return to Search Page”)
----
Any Ideas why this is not working? It gives me an object required error, apparently it is not getting the x-node values…
Knute Hestness
tmtest.TSD (4.14 KB)