SQL转ACCESS 问题
在SQL SERVER中能可以通过并能达到了想要的功能Sql = "select isnull(max(model_id)," & ParentModelID & ") from icms_model where parent_model_id = " & ParentModelID
response.write(sql)
response.end()
ModelID = Lpad((CInt(Conn.Execute(Sql)(0)) + 1),4,"0")
转为ACCESS中就出错
