subject_61294.htm

vc

<p>
序号：61294 发表者：mwh 发表日期：2003-11-18 23:01:36
<br>主题：数据库查询问题
<br>内容：&nbsp;&nbsp;我欲从一个对话框（m_code)中输入电话号码，在数据库中查询，语句如下，<BR>然而却无任何反应，当我将'%+m_code+%'换为'3200000',却可查到3200000的数据，<BR>请问，我在哪里错了。<BR><BR>&nbsp;&nbsp;&nbsp;&nbsp;he=m_pConnection-&gt;Open(&#34;DSN=jfexam;&#34;,&#34;&#34;,&#34;&#34;,adModeUnknown);<BR>&nbsp;&nbsp;&nbsp;&nbsp;m_pRecordset.CreateInstance(&#34;ADODB.Recordset&#34;);///创建Recordset对象<BR>&nbsp;&nbsp;&nbsp;&nbsp;m_pRecordset-&gt;Open(&#34;SELECT * FROM hddb WHERE calling='%+m_code+%'&#34;, <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; _variant_t ((IDispatch&nbsp;&nbsp;*)m_pConnection, true), <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;adOpenDynamic, adLockOptimistic, adCmdUnknown);&nbsp;&nbsp; //%+m_code+%<BR>&nbsp;&nbsp; while(!m_pRecordset-&gt;adoEOF)<BR> {<BR>&nbsp;&nbsp;v_calling= m_pRecordset-&gt;GetCollect(&#34;calling&#34;);<BR>&nbsp;&nbsp;v_called = m_pRecordset-&gt;GetCollect(&#34;called&#34;);<BR>&nbsp;&nbsp;v_starttime = m_pRecordset-&gt;GetCollect(&#34;starttime&#34;);<BR>&nbsp;&nbsp;v_endtime = m_pRecordset-&gt;GetCollect(&#34;endtime&#34;);<BR>&nbsp;&nbsp;v_calltype = m_pRecordset-&gt;GetCollect(&#34;calltype&#34;);<BR>&nbsp;&nbsp;v_time = m_pRecordset-&gt;GetCollect(&#34;calltime&#34;);<BR> //v_callmoney = m_pRecordset-&gt;GetCollect(&#34;money&#34;);<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR>&nbsp;&nbsp;nItem=m_list.InsertItem(0xffff,(_bstr_t)v_called);<BR>&nbsp;&nbsp;m_list.SetItem(nItem,1,1,(_bstr_t)v_starttime,NULL,0,0,0);<BR>&nbsp;&nbsp;m_list.SetItem(nItem,2,1,(_bstr_t)v_endtime,NULL,0,0,0);<BR>&nbsp;&nbsp;m_list.SetItem(nItem,3,1,(_bstr_t)v_time,NULL,0,0,0);<BR>&nbsp;&nbsp;m_list.SetItem(nItem,4,1,(_bstr_t)v_calltype,NULL,0,0,0);<BR>&nbsp;&nbsp;m_list.SetItem(nItem,5,1,(_bstr_t)v_callmoney,NULL,0,0,0);<BR>&nbsp;&nbsp;m_pRecordset-&gt;MoveNext();<BR> }<BR>
<br><a href="javascript:history.go(-1)">返回上页</a><br><a href=http://www.copathway.com/cndevforum/>访问论坛</a></p>
<hr size=1>
<blockquote><p>
<font color=red>答案被接受</font><br>回复者：蔡霁 回复日期：2003-11-18 23:56:28
<br>内容：一、如果是模糊查询的话，应该用like而不是＝<BR>二、变量这样是传不到sql语句中去的，试试这样<BR>&nbsp;&nbsp;&nbsp;&nbsp;CString strSql = &#34;SELECT * FROM hddb WHERE calling like '%&#34;+m_code+&#34;%'&#34;;<BR>&nbsp;&nbsp;&nbsp;&nbsp;m_pRecordset-&gt;Open(strSql, _variant_t ((IDispatch&nbsp;&nbsp;*)m_pConnection, true), <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;adOpenDynamic, adLockOptimistic, adCmdUnknown);
<br>
<a href="javascript:history.go(-1)">返回上页</a><br><a href=http://www.copathway.com/cndevforum/>访问论坛</a></p></blockquote>
<hr size=1>
<blockquote><p>
回复者：浪际天涯 回复日期：2003-11-19 09:09:54
<br>内容：按一楼的做应该没问题
<br>
<a href="javascript:history.go(-1)">返回上页</a><br><a href=http://www.copathway.com/cndevforum/>访问论坛</a></p></blockquote>