subreport xpath w ' causes Jasper Exception

[2004 IR Help]

By: brent - bvbenson

subreport xpath w ' causes Jasper Exception

2005-04-29 12:20

I have a subreport, with the xpath:

 

"/Envelope/Body/Response/Asset[uatbAsIMCityName = '"+$F{cityName} +"'][uatbAsIMCntyName = '"+$F{countyName}+"'][uatbAsIMStateName = '"+$F{stateName}+"']"

 

I have data being returned and the cityName is "land o' lake". This single quote causes my xpath to fail because it evaluates to:

 

"/Envelope/Body/Response/Asset[uatbAsIMCityName = 'land o' lake'

 

this causes xpath to have to cause an exception. I have tried:

 

"/Envelope/Body/Response/Asset[uatbAsIMCityName = '"+$F{cityName}.replaceAll("'","'")+"'][uatbAsIMCntyName = '"+$F{countyName}+"'][uatbAsIMStateName = '"+$F{stateName}+"']")

 

But then the subreport does not include land o' lakes in the report.

 

Any ideas? thanks.

 

Brent

[ozzie2006]

I am having a similar problem. Did you find a solution for this.

 

Thanks.