两次使用SQL语言的有关问题
两次使用SQL语言的问题
我想用某一条件查询数据库后在控件第一行输出数据,然后根据第二个条件再查询数据库,在第二行输出数据,但结果只显示了第一行,且弹出错误提示,要怎么办呢
double max=b[0];
for(m=1;m <100;m++)
{
if(max <b[m]) max=b[m];}
m_a.Format( "%f ",max);
sql= "SELECT * FROM 钢管 where 流量= "+m_a;
m_pRecordset2-> Open(_variant_t(sql), theApp.m_pConnection2.GetInterfacePtr(),adOpenDynamic,adLockOptimistic,adCmdText);
m_jg.InsertItem(0, " ");
m_jg.SetItemText(0,0,(LPCSTR)_bstr_t(m_pRecordset2-> GetCollect( "流量 ")));
m_jg.SetItemText(0,1,m_gj);
m_pRecordset2-> MoveNext();
double min=c[0];
for(n=0;n <100;n++)
{
if(min> c[n]&&c[n]> 0) min=c[n];}
m_b.Format( "%f ",min);
sql= "SELECT * FROM 钢管 where 流量= "+m_b;
m_pRecordset2-> Open(_variant_t(sql), theApp.m_pConnection2.GetInterfacePtr(),adOpenDynamic,adLockOptimistic,adCmdText);
m_jg.InsertItem(1, " ");
m_jg.SetItemText(1,0,(LPCSTR)_bstr_t(m_pRecordset2-> GetCollect( "流量 ")));
m_jg.SetItemText(1,1,m_gj);
------解决方案--------------------
Open()了没有Close()?
我想用某一条件查询数据库后在控件第一行输出数据,然后根据第二个条件再查询数据库,在第二行输出数据,但结果只显示了第一行,且弹出错误提示,要怎么办呢
double max=b[0];
for(m=1;m <100;m++)
{
if(max <b[m]) max=b[m];}
m_a.Format( "%f ",max);
sql= "SELECT * FROM 钢管 where 流量= "+m_a;
m_pRecordset2-> Open(_variant_t(sql), theApp.m_pConnection2.GetInterfacePtr(),adOpenDynamic,adLockOptimistic,adCmdText);
m_jg.InsertItem(0, " ");
m_jg.SetItemText(0,0,(LPCSTR)_bstr_t(m_pRecordset2-> GetCollect( "流量 ")));
m_jg.SetItemText(0,1,m_gj);
m_pRecordset2-> MoveNext();
double min=c[0];
for(n=0;n <100;n++)
{
if(min> c[n]&&c[n]> 0) min=c[n];}
m_b.Format( "%f ",min);
sql= "SELECT * FROM 钢管 where 流量= "+m_b;
m_pRecordset2-> Open(_variant_t(sql), theApp.m_pConnection2.GetInterfacePtr(),adOpenDynamic,adLockOptimistic,adCmdText);
m_jg.InsertItem(1, " ");
m_jg.SetItemText(1,0,(LPCSTR)_bstr_t(m_pRecordset2-> GetCollect( "流量 ")));
m_jg.SetItemText(1,1,m_gj);
------解决方案--------------------
Open()了没有Close()?