GetString

데이터 값을 가져옵니다.

Prototype

string GetString(string FieldName)

string GetString(integer FieldIndex)

Parameters

Example 1

function OZJSResultSetSample(){

   var con = OZCreator.GetBuiltInObject(OZBuiltInObject.DBCONNECTION);

   con.SetAlias("ozcar");

   con.Connect(true);

   var stmt = con.CreateStatement();

   var rs = stmt.ExecuteQuery("select * from car");

   while(rs.Next()) {

       var data = "";

       data = data + rs.GetString("Field1");

       _DEBUG(data);

   }

   rs.Close();

   stmt.Close();

}

Example 2

function OZJSResultSetSample(){

   var con = OZCreator.GetBuiltInObject(OZBuiltInObject.DBCONNECTION);

   con.SetAlias("ozcar");

   con.Connect(true);

   var stmt = con.CreateStatement();

   var rs = stmt.ExecuteQuery("select * from car");

   var meta = rs.GetMetaData();

   for(var i=0; i<meta.GetColumnCount(); i++) {

       _DEBUG(i+"= column Name="+meta.GetColumnName(i+1)+" type="+meta.GetColumnType(i+1));

   }

   while(rs.Next()) {

       var data = "";

       for(var i=0; i<meta.GetColumnCount(); i++) {

           data = data + rs.GetString(i+1) + ",";

       }

       _DEBUG(data);

   }

   rs.Close();

   stmt.Close();

}