我的语句为str1.Format("UPDATE wz set title='%s',class='%s',nr='%s' WHERE title=m_xb1",
m_bt, strTemp, fromClipboard);
其中CString m_xb1;保存的值,但是这个语句里title就直接等于m_xb1。这该怎么办?
str1.Format("UPDATE wz set title='%s',class='%s',nr='%s' WHERE title=%s",
m_bt, strTemp, fromClipboard,(LPCTSTR)m_xb1);
C/C++ code:
str1.Format("UPDATE wz set title='%s',class='%s',nr='%s' WHERE title='%s'",
m_bt, strTemp, fromClipboard, m_title);
//都用了CString::Format了,还..
str1.Format("UPDATE wz set title='%s',class='%s',nr='%s' WHERE title=%s",
m_bt, strTemp, fromClipboard,m_xb1);
SELECT Count(*) from In_fo WHERE Reader_Time between #" + time1 + "# AND #" + time2 + "# and id=" + userid + ";
上面是我写的sql语句 Reader_Time是时间类型 id为数字 ......