希望Select方法能支持插值 #2327

New Issue

cos800 · 2023-08-30T06:13:03Z

cos800 commented

2023-08-30 06:13:03 +00:00

我要查询的SQL大概是这样

SELECT`id`, `title`, ST_Distance_Sphere(POINT(`pos_lng`, `pos_lat`), POINT(?, ?)) as `dist` FROM `table_name`

两个问号，分别要替换成经度和纬度，

但是XORM的Select方法并不支持插值。

我要查询的`SQL`大概是这样 ```sql SELECT`id`, `title`, ST_Distance_Sphere(POINT(`pos_lng`, `pos_lat`), POINT(?, ?)) as `dist` FROM `table_name` ``` **两个问号，分别要替换成经度和纬度，** 但是`XORM`的`Select`方法并不支持插值。 ![image](/attachments/4071e3f5-8cc9-40e8-b7ed-b7a3877db8d0)

image.png

19 KiB

lunny added the

kind

proposal

label 2023-08-31 16:00:19 +00:00

FlyingOnion commented

2023-09-30 13:53:59 +00:00

不一定可以，得看底层驱动支不支持 select 中占用占位符

Sign in to join this conversation.