Lines Matching refs:query
420 …$query = 'SELECT id, uri, lastmodified, etag, calendarid, size, calendardata, componenttype FROM '…
422 $query .= implode(',', array_fill(0, count($uris), '?'));
423 $query .= ')';
425 $stmt = $this->pdo->prepare($query);
702 …$query = "SELECT uri, calendardata FROM " . $this->calendarObjectTableName . " WHERE calendarid = …
704 … $query = "SELECT uri FROM " . $this->calendarObjectTableName . " WHERE calendarid = :calendarid";
712 $query .= " AND componenttype = :componenttype";
717 $query .= " AND lastoccurence > :startdate";
721 $query .= " AND firstoccurence < :enddate";
725 $stmt = $this->pdo->prepare($query);
764 $query = <<<SQL
778 $stmt = $this->pdo->prepare($query);
861 …$query = "SELECT uri, operation FROM " . $this->calendarChangesTableName . " WHERE synctoken >= ? …
862 if ($limit > 0) $query .= " LIMIT " . (int)$limit;
865 $stmt = $this->pdo->prepare($query);
895 $query = "SELECT uri FROM " . $this->calendarObjectTableName . " WHERE calendarid = ?";
896 $stmt = $this->pdo->prepare($query);