急,请好心人帮忙

[vomo]

CString sID,sName;
sName.Format("SELECT * FROM log WHELE id='%s'",sID);
_bstr_t sql = sName;
try
{
m_recordset->Open(sql,_variant_t((IDispatch*)theApp.m_connection,true),adOpenStatic,adLockOptimistic,adCmdText);
}
catch(_com_error e)
{
::AfxMessageBox("log表打开有错误");
}
这个语句为什么会出错??
请指教.

[一条晚起的虫]

sName.Format("SELECT * FROM log WHELE id='%s'",sID);
WHELE 改成 WHERE
数据表中的id是字符型？