将varchar 值 '公开课' 转换为数据类型为 int 的列时发生语法错误。
发布网友
发布时间：2024-10-23 17:31
共1个回答
热心网友
时间：2024-11-11 20:46
kc_2.Source = "SELECT * FROM kehceng_1 WHERE kc_dz = '" + Replace(kc_2__MMColParam, "'", "''") + "' and kc_sh=" + Replace(kc_2__a3, "'", "''") + " ORDER BY kc_fbsj DESC"
改成
kc_2.Source = "SELECT * FROM kehceng_1 WHERE kc_dz = '" + Replace(kc_2__MMColParam, "'", "''") + "' and kc_sh='" + Replace(kc_2__a3, "'", "''") + "' ORDER BY kc_fbsj DESC"
