No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
|
Below is my scripts: <% connstring ="Provider=MSDAORA;Data Source=(DESCRIPTION="&_ "(ADDRESS=(PROTOCOL=TCP)(HOST=cqcmdb1.corp.mot.com) (PORT=1521))"&_ "(CONNECT_DATA=(SID=CQPD2)));User ID=report_ccmpd_ro;Password=report" set con = server.CreateObject("ADODB.Connection") con.open connstring set conn = server.CreateObject("ADODB.Connection") conn.open connstring sqltest = "select T1.screen_failure, DBMS_LOB.SUBSTR(T1.ROOT_CAUSE_ANALYSIS,9000,1) AS RCATT from Submission_Record T1 where T1.dbid <> 0 and (T1.Headline like '%[O2O7]%')" set rs=server.createobject("adodb.recordset") rs.open sqltest ,con,1,3 sqltestonly = "select …
|