CString mid = 2;
_bstr_t strsql = "SELECT * FROM [tables] WHERE [id] = '"+ mid +"'";
這里的mid是的整數形式的變數,但是表中的欄位[id]是整數型,運行以后提示“資料型別不匹配”,應該如何改寫。
另外,如果在“ [id] =”后面拼接數字的話,應該怎么寫運算式。謝謝
uj5u.com熱心網友回復:
int mid = 2;
cstring sql;
sql.format("SELECT * FROM [tables] WHERE [id] = %d", mid);
uj5u.com熱心網友回復:
字串格式化 sprintf轉載請註明出處,本文鏈接:https://www.uj5u.com/gongcheng/62519.html
標籤:數據庫
