一个关于sql的问题,谢谢了
bobqi 2001-04-16 08:14:00 有如下一段代码
sql = "select m.[报价表编号] as 报价表编号,m.[产品编号] as 产品编号,a.[名称] as 地区,d.[名称] as 经销商,m.[品名] as 产品名称,c.[名称] as 材料类别,m.[销售价格] as 销售价格,m.[报价日期] as 报价日期,m.[产品类别] as 材料编号, m.[规格] as 材料规格, m.[产地品牌] as 厂牌名, m.[单位] as 单位, m.[备注] as 备注 from 报价表 m join 地区 a on m.[地区编码] = a.[编码] join 材料类别 c on m.[产品类别] = c.[编码] join 经销商 d on m.[用户编码] = d.[编码] where d.[编码]=""" & Session("username") & """"
sql = sql & " order by m.[报价表编号] desc" 'where m.[报价表编号] = '"&Market_PriceID&"'"
set rs=server.CreateObject ("ADODB.Recordset")
Response.Write sql
'Response.End
rs.Open sql,conn,3,1
在 rs.Open sql,conn,3,1
中出错,但是我把他输出后,放到 query analyer 中运行又没有问题,
本来也好好,但是我在加了一句 where 就开始报错。