求助：select中加入“order by ID”检索条件后，open就报错

	

_ConnectionPtr m_pCon;							// 连接对象

_RecordsetPtr m_pRs;							// 记录集对象



Select_AxleNum.Format("select distinct(num) from CarType where w1>=%d and w1<=%d",MinV,MaxV);

	//

	i=0;

	while(***)

	{

		i++;		

		MaxV=****;

		MinV=(int)(***);

		Str_Add.Format(" and w%d>=%d and w%d<=%d",i+1,MinV,i+1,MaxV);

		Select_AxleNum +=Str_Add;

	}

	//

	i++;

	MaxV=(int)(***);

	if(MaxV > 0)

	{

		Str_Add.Format(" and w%d<=%d",i+1,MaxV);

		Select_AxleNum +=Str_Add;

	}



	Str_Add.Format(" order by ID)");  //加入后open就报错啦

	Select_AxleNum +=Str_Add;



	// 开始检索轴数的唯一性

	bsSql = Select_AxleNum.AllocSysString();

	m_pRs->Open((CComVariant)bsSql,m_pCon.GetInterfacePtr(),adOpenDynamic,adLockOptimistic,adCmdText);

	// 分析查询结果

	while(VARIANT_FALSE == m_pRs->EndOfFile)

	{

		AxleNum++;

		vFieldValue = m_pRs->GetCollect(_variant_t((long)0));

		Train_Num=atoi((char*)_bstr_t(vFieldValue));

		m_pRs->MoveNext();

	}

	// 关闭记录集

		m_pRs->Close();