示例#1
0
文件: LB_DB.php 项目: elemenofi/lb
 public function GET___FKs__Names()
 {
     $Query = "SELECT FK__Class.Name AS FK__Class__Name\r\r\n                    FROM       lbxxdb50.proc__fact \r\r\n                    INNER JOIN lbxxdb50.proc__class              ON proc__fact.Class__Id     = proc__class.Id\r\r\n                    INNER JOIN lbxxdb50.proc__class AS FK__Class ON proc__fact.FK__Class__Id = FK__Class.Id\r\r\n                    WHERE \r\r\n                            FK__Class__Id IS NOT NULL \r\r\n                        AND proc__class.Name = :inClass_Name;";
     global $PDO;
     $SP = $PDO->prepare($Query);
     $SP->bindValue(":inClass_Name", $this->Name, PDO::PARAM_STR);
     $ResultsSets = ccDB::GET__ResultsSets__Merged($SP, PDO::FETCH_COLUMN);
     return $ResultsSets;
 }