asp '[string："SELECT * FROM Orders"]‘

Question

大家好，我有一些代码的问题，我找不到错误

  sql = "select " * " from products where pic = 1 and product_code in ("

    count = ubound(codes)
    for each code  in codes
        if len(code) > 0 then
            sql = sql & "'" & code & "'"
            if i < count - 1 then sql = sql & ","
            i = i + 1
        end if
    next

    sql = sql & ")"

    set res = lo_con.execute(sql)

Answer 1

您的字符串中没有包含星号。尝试：

sql = "select * from products where pic = 1 and product_code in ("