日期:2014-05-17  浏览次数:20769 次

关于SQL(asp)
can_s=request.QueryString( "zi_y ")
    sql= "select   *   from   xin_x_l_b   where   Lei_b_bh= "&can_s
如果zi_y是数字型时(长整型)时我发现这句话没有问题
但是zi_y是字符型时就错,
老师,这是为什么呢?


------解决方案--------------------
sql= "select * from xin_x_l_b where Lei_b_bh= ' "&can_s& " ' "