how to search products start with "a"

[Sony George]

Hello,

I would like to search products that's name starts with "a" or "A", how can i achieve this

regards

Sony

[vpod]

perhaps:

Code Select Expand

KKWSEngIf eng = new KKWSEngIfServiceLocator().getKKWebServiceEng();


int languageId = 1;
String searchString = "a%";
String sessionId = ""; //get the sessionid

List<Product> products = new ArrayList<Product>();

List<Record> records;
try {
Torque.init("torque.properties");

records = BasePeer
  .executeQuery("SELECT pd.products_id " +
"FROM konakart.products_description pd " +
"where pd.products_name like '" + searchString + "' " +
"and pd.language_id = " + languageId);

if (records != null) {
for (Iterator<Record>
         iterator = records.iterator();
         iterator.hasNext();)
{
Record rec = (Record) iterator.next();
int productId = rec.getValue(0).asInt();
Product prod = eng.getProduct(sessionId, productId, languageId)

products.add(prod);
}
}
} catch (TorqueException e) {
e.printStackTrace();
} catch (DataSetException e) {
e.printStackTrace();
}

...handmade