Subversion Repositories eFlore/Applications.coel

Rev

Rev 1507 | Rev 1545 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 1507 Rev 1517
Line 52... Line 52...
52
		
52
		
53
		// Construction de la requête
53
		// Construction de la requête
54
		$requete = 	(($this->distinct) ? 'SELECT DISTINCT' : 'SELECT').' cs_id_structure, cs_ville, cs_nom, '.
54
		$requete = 	(($this->distinct) ? 'SELECT DISTINCT' : 'SELECT').' cs_id_structure, cs_ville, cs_nom, '.
55
					'	cc_id_collection, cc_nom '.
55
					'	cc_id_collection, cc_nom '.
56
					$this->construireFromEtWhere($p).
56
					$this->construireFromEtWhere($p).
57
					'ORDER BY '.((!is_null($this->orderby)) ? $this->orderby  : 'cs_ville ASC, cs_nom ASC').' '.
57
					'ORDER BY '.((!is_null($this->orderby)) ? $this->orderby  : 'cs_ville ASC, cs_nom ASC, cc_nom ASC').' '.
58
					"LIMIT $this->start, $this->limit ";
58
					"LIMIT $this->start, $this->limit ";
59
		$this->debug[] = $requete;
59
		$this->debug[] = $requete;
60
		// Récupération des résultats
60
		// Récupération des résultats
61
		try {
61
		try {