为什么总是提示找不到参数?

[mark2003]

为什么总是提示找不到参数chiNam,是不是我的格式错了?

container->ADOQuery2->Close();
container->ADOQuery2->SQL->Clear();
container->ADOQuery2->SQL->Add("select * from reserveRestDays where theMonth=:monthValue and chiNam like'%:chiNam%'");
container->ADOQuery2->Parameters->ParamByName("monthValue")->Value=monthValue;
container->ADOQuery2->Parameters->ParamByName("chiNam")->Value=chiNam;
container->ADOQuery2->Open();

[柯本]

参数不要写在''中,这样可以:
...
container->ADOQuery2->SQL->Add("select * from reserveRestDays where theMonth=:monthValue and chiNam like :chiNam ");
...
container->ADOQuery2->Parameters->ParamByName("chiNam")->Value=String("%")+chiNam+"%";