Question

ASP中怎样把从文本框中获取的值作为sql查询的条件？

SELECT flight_date 航班日期,count(AC_reg) 合计投入运力 From (Select flight_date,AC_REG FROM hbhkmarket.flight WHERE carrier='NS' And flg_cs Is Null And flight_date Between to_date('"+startdate.Text.+"','yyyy-mm-dd') And to_date('"+enddate.Text.+"','yyyy-mm-dd') And flight_type In ('J','G','1') Group By flight_date,AC_REG Order By flight_date) Group By flight_date ORDER BY flight_date"

文本框定义如下
<input name="startdate" type="text" id="startdate" value="2018-03-25" size="12" />
-
<input name="enddate" type="text" id="enddate" value="2018-04-01" size="12" />

Answer 1

group by 前面加 where 字段 between startdate.text and enddate.text

Answer 2

英语题目得的