Can't Display Chart With Quote In Name

[fovnyc]

Hi,

 

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 DWFChart.inc.asp file with the replace(string, " ' ", " ' ' ") function, but it still doesn't work.

 

Many thanks for your help!

Cheers,

TG