<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Tahoma
}
--></style>
</head>
<body class='hmmessage'><div dir='ltr'>
Dear Klaus, <br><br>e.g. to get all values labeled between a length of 10 and 15, try this syntax: <br>SQL: select*from %Layer name% where Shape_Leng <b>between </b>10 and 15;<br>Hope this helps!<br>Best regards, Ruth<br><br>Ruth Schönbuchner<br><b>CSGIS</b><br>Email:ruth.schoenbuchner@csgis.de<br>Web: h<b>ttp://www.csgis.de</b><br><br><div>> Date: Mon, 31 Oct 2011 00:45:16 -0700<br>> From: klaus.schaefer4@giz.de<br>> To: gvsig_internacional@listserv.gva.es<br>> Subject: [Gvsig_english] syntax "IsBetween" for layer labeling<br>> <br>> Hi there,<br>> <br>> can someone explain to me the correct use of the "IsBetween" syntax in layer<br>> labeling? I wanted to do a between 3 and 4, but "IsBetween" requires 3<br>> operands, which I do not really understand. And even with 3 operands I<br>> didn't get it to work...<br>> <br>> My above filter can be achieved with "<= 4 && >= 3", of course, but I would<br>> be interested how "IsBetween" works...<br>> <br>> Thanks and best regards<br>> Klaus<br>> <br>> --<br>> View this message in context: http://osgeo-org.1803224.n2.nabble.com/syntax-IsBetween-for-layer-labeling-tp6947244p6947244.html<br>> Sent from the gvSIG users mailing list archive at Nabble.com.<br>> _______________________________________________<br>> Gvsig_internacional mailing list<br>> Gvsig_internacional@listserv.gva.es<br>> http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional<br></div>                                            </div></body>
</html>