Git Product home page Git Product logo

Comments (2)

big-dream avatar big-dream commented on July 26, 2024
  • 能自行解决的且代码有优化空间的,可提交PR。
  • 自行解决不了的,请补充详细信息(包括但不限于代码和表结构)

from think-orm.

metoogo avatar metoogo commented on July 26, 2024

先声明,我的环境是:sql server
比如我有2个表:customer,equipment
customer表里面有字段:customer_id(主键),name
equipment表里有字段:equipment_id (主键),equipment_model,customer_id

然后我生成了2个model:CustomerModel、EquipmentModel
在CustomerModel添加了:
function equipments() {
return $this->hasMany(EquipmentModel::class,'customer_id','customer_id');
}

现在我在customer的controller里面使用
$customer_equipments_count= CustomerModel::withCount('equipments')->select();
这个就直接报错了,错误代码:
[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]当没有用 EXISTS 引入子查询时,在选择列表中只能指定一个表达式。

合成的sql语句为:
SELECT T1.* FROM (SELECT thinkphp., ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT ,(SELECT T1. FROM (SELECT thinkphp., ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT COUNT(*) AS think_count FROM [d_equipment] [count_table] WHERE ( [count_table].[customer_id] =d_customer.customer_id ) ) AS thinkphp) AS T1) AS [equipments_count] FROM [d_customer] WHERE [customer_id] IN (1,2,3) ) AS thinkphp) AS T1

from think-orm.

Related Issues (20)

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.