How to contruct the query operation based on DPL effectively?
914264Feb 1 2012 — edited Feb 1 2012Supposing I have a table named msgs whose columns are id, msg, priority and so on.
My sql statement is the following :
SELECT ID, MSG
FROM MSGS
WHERE CONTAINER = ?
AND ((ID > ? AND PRIORITY = ?) OR PRIORITY < ?)
ORDER BY PRIORITY DESC, ID
My question is how to contruct the query operation based on DPL effectively?
Edited by: 911261 on 2012-2-1 上午12:51