Prepare another query

1 files changed, 13 insertions, 0 deletions

diff --git a/db/smsmapper.php b/db/smsmapper.php
index b022f41..e62edad 100644
--- a/db/smsmapper.php
+++ b/db/smsmapper.php
@@ -183,6 +183,19 @@ class SmsMapper extends Mapper {
 		$query = \OCP\DB::prepare('SELECT sms_address, sms_date, sms_msg, sms_type, sms_mailbox FROM ' .
 			'*PREFIX*ocsms_smsdatas WHERE user_id = ? AND sms_date > ? ORDER BY sms_date', (int) $limit);
 		$result = $query->execute(array($userId, $start));
+
+//		$qb = $this->db->getQueryBuilder();
+//		$qb->select('sms_address, sms_date, sms_msg, sms_type, sms_mailbox')
+//			->from('ocsms_smsdatas')
+//			->where($qb->expr()->andX(
+//				$qb->expr()->eq('user_id', $qb->createNamedParameter($userId)),
+//				$qb->expr()->gt('sms_date', $qb->createNamedParameter($start))
+//			)
+//			)
+//			->orderBy('sms_date');
+//		$result = $qb->execute();
+// How to do limit ?
+
 		while ($row = $result->fetchRow()) {
 			$messageList[$row["sms_date"]] = array(
 				"address" => $row["sms_address"],