well, i had to change it a little: findeRelatedNodeList dous not have a version
with the below signature (no destination parameter), but i can do it like this:
NodeQuery nq = SearchUtil.createRelatedNodeListQuery(pageNode, "pagina",
"posrel", "tonen", "true", "posrel.pos", "up", "destination");
NodeList nl = cloud.getList(nq);
bug oh bummer, i'm back at square one (worse, becouse there is no fallback to
legacy):
javax.servlet.jsp.JspException: javax.servlet.jsp.JspException: Invalid value
for BOOLEAN field: true, of type java.lang.String
javax.servlet.ServletException: javax.servlet.jsp.JspException:
javax.servlet.jsp.JspException: Invalid value for BOOLEAN field: true, of type
java.lang.String
I'd say the plot thickens....
Ernst
Nico Klasens wrote:
I really would suggest to use the query object. I think this works.
NodeList nl= SearchUtil.findRelatedNodeList(pageNode, "pagina",
"posrel", "pagina.tonen", "true", "posrel.pos", "up", "destination");
Nico
Ernst Bunders wrote:
hello
I have a simple question, and i must say I'm quite surprised it seems
to be an issue.
I am using the new datatypes for the first time and i find it a
problem to create a constraint on a boolean field.
I have a field like this:
<field>
<gui>
<guiname xml:lang="nl">tonen</guiname>
</gui>
<editor>
<positions>
<input>3</input>
<list>3</list>
<search>3</search>
</positions>
</editor>
<dt:datatype
xmlns="http://www.dynasol.nl/xmlns/mmbase-shorthand"; base="boolean">
<dt:default value="true"/>
</dt:datatype>
<db>
<name>tonen</name>
<type key="false" notnull="false" size="50"
state="persistent">BOOLEAN</type>
</db>
</field>
this translate to a bit field in my (mysql) database:
mysql> desc mm_artikel;
+--------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------------+-------------+------+-----+---------+-------+
| number | int(11) | NO | PRI | | |
| otype | int(11) | NO | MUL | | |
| owner | varchar(12) | NO | | | |
| naam | text | NO | | | |
| intro | text | YES | | NULL | |
| tonen | bit(1) | YES | | NULL | |
| aanmaakdatum | datetime | YES | | NULL | |
| door | text | YES | | NULL | |
+--------------+-------------+------+-----+---------+-------+
so far so good, but when i create a constraint using this field, ik
get errors:
NodeList nl = cloud.getList(null, "object,posrel,pagina",
"pagina.number",
"object.number=" + pageNode.getNumber() + " AND
pagina.tonen = 1",
"posrel.pos",
"up", "destination", false);
sqlConstraint = object.number=112 AND pagina.tonen = 1
exception: Invalid value for BOOLEAN field: 1.0, of type
java.lang.Double
i also tried:
AND pagina.tonen
AND pagina.tonen = true
but nothing works (or, it works, but in legacy mode, and an exception
is thrown each time.
I havn't tried creating a Query object, because I am too lazy to do
that. I think it should work like this...
can anybody help me?
regards,
Ernst
8 rows in set (0.00 sec)
_______________________________________________
Developers mailing list
[email protected]
http://lists.mmbase.org/mailman/listinfo/developers
_______________________________________________
Developers mailing list
[email protected]
http://lists.mmbase.org/mailman/listinfo/developers
_______________________________________________
Developers mailing list
[email protected]
http://lists.mmbase.org/mailman/listinfo/developers
