Sign in to follow this  

Can't Display Chart With Quote In Name

Recommended Posts



I ran a simple SQL query in a Dreamweaver CS4 recordset:


"SELECT DISTINCT tclCustomers.CustomerName, SUM(tblARInvoiceDetailTemp.Quantity) AS sumquant

FROM tblCustomers, tblARInvoiceDetailTemp

WHERE tblCustomers.CustomerID=tblARInvoiceDetailTemp.CustomerID

GROUP BY tblCustomers.CustomerName"


The problem is that in the table tblCustomers, the field CustomerName contains names like "John's Pizzeria", with a single quote.

When I create a FusionCharts chart, it takes the field CustomerName as category, but is unable to display it properly as there is a single quote in some of the names.


I tried to modify the file with the replace(string, " ' ", " ' ' ") function, but it still doesn't work.


Many thanks for your help!



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