function WRGetFieldsList($table) { if (is_wr_project()) { $pSet = new ProjectSettings($table); return $pSet->getFieldsList(); } if (is_wr_db()) { global $wr_is_standalone; if (!$wr_is_standalone) { global $dal; if ($dal->Table($table)) { return $dal->GetFieldsList($table); } } return dbinfoFieldsList($table); } if (is_wr_custom()) { $res = array(); $sql = $_SESSION["object_sql"]; //The default connection is temporary used #9875 $connection = getDefaultConnection(); $arr = $connection->getFieldsList($sql); foreach ($arr as $val) { $res[] = $val["fieldname"]; } return $res; } }
function WRGetFieldsList($table) { if(is_wr_project()){ $pSet = new ProjectSettings($table); return $pSet->getFieldsList(); } if(is_wr_db()) { global $wr_is_standalone; if(!$wr_is_standalone) { global $dal; if($dal->Table($table)) return $dal->GetFieldsList($table); } return dbinfoFieldsList($table); } if(is_wr_custom()) { global $conn; $arr=array(); $sql=""; $res=array(); // $rs=db_query("select * from ".AddTableWrappers("webreport_sql")." where ".AddFieldWrappers("sqlname")."='".$table."'",$conn); // if($data = db_fetch_array($rs)) // $sql=$data["sqlcontent"]; $sql=$_SESSION["object_sql"]; $arr=db_getfieldslist($sql); foreach($arr as $val) $res[]=$val["fieldname"]; return $res; } }