CMyRecordset set;
CMyRecordset * pset;
pset=&set;
CString str;
str.Format ("SELECT * FROM user and WHERE username='myname'");
if(pset->IsOpen())
pset->Close;
pset->Open(CRecordset::dynaset,str);
if (pset->IsBOF())
{
MessageBox("对不起,没有该用户名,请确认后再输!");
}
str.Format("password %s",pset->m_password);
MessageBox(str);我明明是找到了数据项了的但是确显示不出m_password 来,说是空串,郁闷呀?
问题在什么地方?
CMyRecordset * pset;
pset=&set;
CString str;
str.Format ("SELECT * FROM user and WHERE username='myname'");
if(pset->IsOpen())
pset->Close;
pset->Open(CRecordset::dynaset,str);
if (pset->IsBOF())
{
MessageBox("对不起,没有该用户名,请确认后再输!");
}
str.Format("password %s",pset->m_password);
MessageBox(str);我明明是找到了数据项了的但是确显示不出m_password 来,说是空串,郁闷呀?
问题在什么地方?
SELECT * FROM user and WHERE username='myname'
^^^^^^^^^^^^^do you meanSELECT * FROM [user] WHERE username='myname'?
这个SQL语句对吗?我平时都写成
str.Format ("SELECT * FROM user WHERE username='myname'"); //去掉and