Value from SELECT query will not display

[fab77721]

Strange problem I'm running into. When I run my select query one of the fields I query for is something called engUnits. I then us it to display on my Y axis using the following code on my mypage_data.asp page:

<legend size="10" color="#2d2b2e"><%=(WADWCnullpistd.Fields.Item("engunits").Value)%></legend>

Strange thing is that if the value returned for WADWCnullpistd.Fields.Item("engunits").Value = tonnes then it displays fine on the axis. If the value returned by WADWCnullpistd.Fields.Item("engunits").Value = % then nothing is displayed. Is there a chance that the parser doesn't know what to do with this character?

[Ray Borduin]

I suppose it is possible. If you view the parser page directly as it is referenced in the movie, does it show xml properly? Maybe try url encoding the value.

[fab77721]

I entered a support ticket for this as anywhere you use the % sign in either the title or axis it gets pulled out. Tried in on a default graph where I entered the title as "Trend %Oil" and it displayed as "Trend il"

[Ray Borduin]

That makes sense. It means you need to either urlencode this value or use: %25 in place of % since that is the urlencoded version of %

[fab77721]

Any other ideas as I'm using a database query to fill the chart title. URL encoding it or changing the text string is not an option from what I understand.

[Ray Borduin]

You can go to the _data file and add urlencoding by hand pretty easily. It sounds like that is your best option.