c# - sql hibernate and or restrictions -


my sql should this:

select cell1 table cell2 = 1 , (cell3 = '' or cell3 null)

but how "and ( x or y )" restricion hibernate?

what logicalexpression

try and condition:

criteria cr = session.createcriteria(table.class);  // records matching , condistions logicalexpression andexp = restrictions.and(cell2, cell3); cr.add( andexp );

for or condition use this

 // records matching or condistions   logicalexpression orexp = restrictions.or(cell2, cell3);   cr.add( orexp );   list results = cr.list();

Comments

Post a Comment

Popular posts from this blog

java - Callback from new thread to class from which thread was initiated -

i have class calling new thread. public class mainclass{ private void cleardata() { // on separate thread new thread(new runnable() { @override public void run() { //do //after notify mainclass thing has been done , pass value. } } } private void callbackfunc(int a){ // based on value of } } i have function in mainclass. how call function new thread, receive callback. thanks. you should able call method in mainclass name if calling directly inside mainclass (as opposed inner class). if method name want call happens conflict 1 inner class has inherited object can prefix call mainclass.this , e.g. mainclass.this.tostring() calls tostring on mainclass , whereas tostring() calls on inner class instance.
Read more

Receive udp packets in android gstreamer -

i using eclipse juno in windows 7. doing programming on android 4.2 platform. want receive udp packets in gstreamer application. giving uri udp://127.0.0.1:1234 , sending file vlc player same computer. emulator giving message could not get/set setting from/on resource while in case of rtp, giving message no uri implementer found rtp ideas how receive streaming media in android?
Read more

php - Extract Text from HTTP referer -

i using following code show referer link page on website. how can modify code shows part of link. i.e if website url www.example.com/?s=printing want extract printing. , should happen if format www.example.com/?s=aaa , not if format else www.example.com/printing. code: <?php session_start(); if ( !isset( $_session["origurl"] ) ) $_session["origurl"] = $_server["http_referer"]; echo $_session["origurl"] ?> i figured out , following code works: <?php session_start(); if ( !isset( $_session["origurl"] ) ) $_session["origurl"] = $_server["http_referer"]; $mysearchterm = $_server["http_referer"]; $whatiwant = substr($mysearchterm, strpos($mysearchterm, "=") +1); echo $whatiwant; ?>
Read more