Can't figure out what I am doing wrong. Object required....

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

:confused: :confused: :confused: :confused:
tmtest.TSD (4.14 KB)