type NMTOKEN must be a name token error

[ktrinad]

By: chris chern - chrischern

type NMTOKEN must be a name token error

2003-04-20 20:43

Hi Guys,

 

Newbies here...

When I try to run this query on iReport :-

select tran_appraisee, sum(criteria_result) from transaction group by tran_appraisee

 

Error come out:

SEVERE: Parse Error at line 22 column 63: Attribute value "sum(criteria_result)" of type NMTOKEN must be a name token.

 

org.xml.sax.SAXParseException: Attribute value "sum(criteria_result)" of type NMTOKEN must be a name token.

 

How can I get override of the NMTOKEM error?

 

Thanks.

 

 

 

 

By: Ratchapong - jeng

RE: type NMTOKEN must be a name token error

2003-04-20 21:02

Hi,

Try to use "AS" after sum...

 

Ok first remove all fields from the value windows and register it again with the new query....

 

select tran_appraisee, sum(criteria_result) AS sumCriteria from transaction group by tran_appraisee

 

Hope this will help

Jeng

 

 

 

 

By: chris chern - chrischern

RE: type NMTOKEN must be a name token error

2003-04-21 18:42

Gotcha!

Thanks

 

 

 

 

By: ben - hootonbs

type NMTOKEN must be a name token error

2004-07-13 20:10

Hi, I am getting a "type NMTOKEN must be a name token" error because of spaces in field names but I can't change/alias the field names in the SQL query because I am executing a stored procedure on a SQL Server database. ie. my query string is:

 

exec sp_CollegeUnits

 

I can't change the stored procedure as it is used by other applications - is there any other way around this problem?

 

Thanks.