Hello,
I would like to search products that's name starts with "a" or "A", how can i achieve this ???
regards
Sony
perhaps:
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