dongqian0763 2016-02-05 16:43
浏览 57

SilverStripe SQL布尔值语法错误

I trying to return an sql query with the code below. For some reason the boolean values I'm trying to filter by ('ShowOnHomePage' and 'Published') are throwing the following syntax error due to the question mark placeholder.

You have an error in your SQL syntax; check the manual that corresponds to >your MySQL server version for the right syntax to use near '?) AND ("DummyContentOne"."ShowOnHomePage" = ?)) "DummyContentOne" UNION ALL (S' at line 5

public function getSiteContent() {
    if($this->_contentList!=false) {
        return $this->_contentList;
    }

    $request = (Controller::has_curr() ? Controller::curr()->getRequest() : null);
    $start = round(($request ? intval($request->getVar('start')) : 0));

    $DummyContentOne = DummyContentOne::get()->filter('Published', true)->filter('ShowOnHomePage', true)->dataQuery()->query()->setOrderBy(null);
    $DummyContentTwo = DummyContentTwo::get()->filter('Published', true)->filter('ShowOnHomePage', true)->dataQuery()->query()->setOrderBy(null);

    $this->fixQueryColumns($DummyContentOne, $DummyContentTwo);

    $db = DB::query(
        'SELECT * '.
        'FROM ('.$DummyContentOne->sql().') "DummyContentOne" '.
        'UNION ALL ('.$DummyContentTwo->sql().') '.
        'ORDER BY "Date" DESC, "Created" DESC '.
        'LIMIT '.$this->config()->item_count.' OFFSET '.$start
    );

    // Merge into an array list
    $list = new ArrayList();
    foreach($db as $row) {
        $className=$row['ClassName'];
        $list->push(new $className($row, false, DataModel::inst()));
    }

    // Calculate the total number of items
    $totalItems = $DummyContentOne->count() + $DummyContentTwo->count();

    // Convert to a paginated list
    $pagedList=ActionPaginatedList::create($list, $this->Link('more-content'), $request)
    ->setPageLength($this->config()->item_count)
    ->setPageStart($start)
    ->setTotalItems($totalItems)
    ->setLimitItems(false);

    return $pagedList;
}

...

private function fixQueryColumns() {
    $queries = func_get_args();
    $columns = array();

    // Debug::show($queries);

    // Get all of the columns from each query
    foreach($queries as $query) {
        $columns = array_merge($columns, array_keys($query->getSelect()));
    }
...

Any ideas what would cause this?

I'm using SS3.2

Thanks

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥500 火焰左右视图、视差(基于双目相机)
    • ¥100 set_link_state
    • ¥15 虚幻5 UE美术毛发渲染
    • ¥15 CVRP 图论 物流运输优化
    • ¥15 Tableau online 嵌入ppt失败
    • ¥100 支付宝网页转账系统不识别账号
    • ¥15 基于单片机的靶位控制系统
    • ¥15 真我手机蓝牙传输进度消息被关闭了,怎么打开?(关键词-消息通知)
    • ¥15 装 pytorch 的时候出了好多问题,遇到这种情况怎么处理?
    • ¥20 IOS游览器某宝手机网页版自动立即购买JavaScript脚本