修改数据的问题
newsid是 自动编号(ACCESS)
修改数据如下
下面这句可以改的
mysql= "update news set newsname= ' "+newsname+ " ',newscontent= ' "+newscontent+ " ' where newsid= "+id
我又加了个时间 (可是改不了数据了)
mysql= "update news set newsname= ' "+newsname+ " ',newscontent= ' "+newscontent+ " ',newstime= ' "+newstime+ " ' where newsid= "+id
就是多修改个时间段数据就改不了数据了 太奇怪(语句应该没错)
[解决办法]
JSCRIPT:
mysql= "update news set newsname= ' "+newsname+ " ',newscontent= ' "+newscontent+ " ',newstime= ' "+newstime+ " ' where newsid= "+id
VBSCRIPT:
mysql= "update news set newsname= ' " & newsname & " ',newscontent= ' " & newscontent & " ',newstime= ' " & newstime & " ' where newsid= " & id
