Sign in to follow this  
cawthor

drill-down example, escaping text values

Recommended Posts

I am following the drill-down example using ASP in the evaluation version. In order to call the detail graph, you use the following syntax to set up the links:

strXML = strXML & "<set label='" & ors("FactoryName") & "' value='" & ors2("TotOutput") & "' link='updateChart(" & oRs("FactoryId") & ")'/>"

When calling the 'updateChart' function, I want to pass a date value, so it needs to be quoted. How do I correctly add quotes around the date value without terminating the string? This is what I'm trying to do, but adding the single quotes around the date value terminates the string being built. I've tried various ways of escaping the quotes, like '', /'...etc.

strXML = strXML & "<set label='" & RS("SYS_DATE") & "' color='ABC4D6' value='" & RS("AMOUNT") & "' link='updateChart('5/27/2007')'/>"

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this