I
Ingpw
I am trying to publish an office chart use frontpage web component. Everything works fine except that i need this chart to be based on a string pased to the Select statement . asp example of select statement ---- sqlEdit = "SELECT Product as [Product], Count(Product) as [Number of Calls] FROM tblMysteryShop where " & strSearch & "Group BY Product
When i paste this in the dialog box (connection section) it does not work, Please help me write the correct statement to return the results based on the string i am passing to it
Thank yo
When i paste this in the dialog box (connection section) it does not work, Please help me write the correct statement to return the results based on the string i am passing to it
Thank yo