In my code behind files I have this:
public void test()
{
MTConnection con = MTConnection.CreateConnection(new Credential(new Context("ClearQuest - Boise", "Version 2.0", Micron.Application.Context.Environments.Production), "DSSPROD", Credential.DataSourceTypes.MSSQL, Credential.DataSourceProviders.Odbc));
string sqltest = " select T1.dbid,T12.systemname AS 'ParentSystem',T1.systemname,T1.systemstate,T1.features,T3.name,T4.stakeholder,"+
" T4.fldcolumn_1,T1.systemwebpage,T1.description from ( ( ( ( ( ( ( ( CQ_ADMIN.micronsystem T1 INNER JOIN"+
" CQ_ADMIN.microngroup T6 ON T1.primarysupportgroup = T6.dbid ) INNER JOIN CQ_ADMIN.securitygroups T7 ON T1.secuirtygroup"+
" = T7.dbid ) LEFT OUTER JOIN CQ_ADMIN.parent_child_links T12mm ON T1.dbid = T12mm.child_dbid and 16778862 ="+
" T12mm.child_fielddef_id ) LEFT OUTER JOIN CQ_ADMIN.micronsystem T12 ON T12mm.parent_dbid = T12.dbid )"+
" LEFT OUTER JOIN CQ_ADMIN.parent_child_links T3mm ON T1.dbid = T3mm.parent_dbid and 16804095 ="+
" T3mm.parent_fielddef_id ) LEFT OUTER JOIN CQ_ADMIN.feature_1 T3 ON T3mm.child_dbid = T3.dbid ) LEFT OUTER"+
" JOIN CQ_ADMIN.parent_child_links T4mm ON T3.dbid = T4mm.parent_dbid and 16804263 = T4mm.parent_fielddef_id )"+
" LEFT OUTER JOIN CQ_ADMIN.stakeholder T4 ON T4mm.child_dbid = T4.dbid ) where T1.dbid <> 0 and ((T6.abbreviation ="+
" 'Test ES Eng Software' and T1.systemstate = 'Active')) and ((T7.dbid in (select parent_dbid from"+
" CQ_ADMIN.parent_child_links where parent_fielddef_id = 16778767 and child_dbid in (select child_dbid from"+
" CQ_ADMIN.parent_child_links where parent_fielddef_id = 16777328 and parent_dbid = 33664106) ))) order by T3.name"+
" ASC,T1.systemname ASC";
System.Data.DataSet ds = con.ExecuteDataset(CommandType.Text, sqltest);
foreach (DataRow drCQ in ds.Tables[0].Rows)
{
string parent_system = drCQ["ParentSystem"].ToString();
string support_system = drCQ["systemname"].ToString();
//Response.Write(drCQ["systemname"] + " <B><I>Its parent is</I></B> " + drCQ["ParentSystem"] + "<BR />");
}
}
I am wondering if it were possible to pull the the results into JavaScript so that I can make an array out of the results. If so how would you do that?
Thanks,
Xana
If history is to change let it change. If the world is to be destroyed so be it. If it is my fate to die ... I must simply laugh.