We are using version 1.6.0 and we've also tried version 1.6.1, but the same problem appears.
Many thanks, Ana 2010/4/15 Alexander Klimetschek <[email protected]> > On Thu, Apr 15, 2010 at 13:04, Ana Osman <[email protected]> wrote: > > I can't make it a number. In this particular case, it is a number, but > there > > are exceptions when this field can also contain strings. So, I just have > to > > leave it as a string, and in this particular care, to treat it as a > number. > > You should ensure the right data in the first place and make those a > number. Apart from changing the application that writes those string > properties, you could have a small script that goes over the > repository and converts those string properties into long properties > to change existing data. > > > SELECT * FROM nt:base WHERE (jcr:primaryType = 'mgnl:contentNode' OR > > jcr:primaryType = 'mgnl:content') AND name <> 'description_files' AND > > year='2003' AND jcr:path LIKE '/wsDocumentList/Board-of-Directors/%' > ORDER > > BY name asc > > -> this returns the ERROR > > What error? > > Regards, > Alex > > -- > Alexander Klimetschek > [email protected] >
