Product Classification Updation bsaed on Product and how give the range for the Item

static void updateProductClasification(Args _args)
{
    EcoResProduct   ecoResProduct;
   
  
 while select forUpdate SearchName,DisplayProductNumber,WW_Category from ecoResProduct
     where  ecoResProduct.DisplayProductNumber >= '11001' &&  ecoResProduct.DisplayProductNumber <='11142'
  {
   
   ttsBegin;
     ecoResProduct.WW_Category = WW_Category::Stock;
     ecoResProduct.update();
   ttsCommit;  
    }
  }