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

Dear Angshu, I sent you the code, I was wondering if you'd have a solution for the quote problem. Many thanks, TG

?

Hello Any recommendations? Thanks! TG

Sure, thanks! Here it is. It's 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

Dear Angshu, Many thanks for your reply, but the name with single quote comes from a SQL query in my .asp file. Which file should I modify to encode this description? Cheers, TG

Hi, I created a query which get names that I'd like to display as category column, but some of the names have a single quote in them and FusionCharts doesn't seem to deal with it (gives a 'Invalid XML data' error). Should I use the replace function somewhere, or is there an option for this? Many thanks