access数据库，测试时显示参数不足，期待是1

Question

在DREAMWAVER记录集里写的SQL语句
select *
from news inner join sort on sort.sortid=news.sort where Newsid=MMCo1param测试时显示参数不足，期待是1

Answer 1

int MMCo1param = 1;
string sql = "select * from news inner join sort on sort.sortid=news.sort where Newsid=" + MMCo1param;