close ad
 
Important WebAssist Announcement
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Graph XML

Thread began 6/05/2009 10:22 am by xag | Last modified 7/13/2009 6:30 am by xag | 18261 views | 41 replies |

xag

Graph XML

Hello Ray,

I was wondering how easy it is to modify the SQL in the Graph_data page for graphs. I saw the tutorial and I change the line in SQL to a bit more complex SQL but still doesn't render. Can the Graph do the following SQL?

SELECT dbo.LOG_USER.LOG_BROWSER AS XLABEL, count(LOG_BROWSER) AS YVALUE 
FROM dbo.LOG_USER GROUP BY dbo.LOG_USER.LOG_BROWSER
Sign in to reply to this post

Ray BorduinWebAssist

Yes. It should work. Try browsing the data file directly to see if there are any errors or issues with the data or query being used.

Sign in to reply to this post
Did this help? Tips are appreciated...

xag

Nope I even tested out in the Graph_data page in the record set and it returnd the correct values I wanted.

Sign in to reply to this post

xag

so the SQL is good but when i view the graph site I get this /DynamicWebCharts/Data/Graph_dataparser8.asp?in the white area. when i go to the page all thats on the page is teh following code

<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
<!--#include virtual="wa_dfc_xmlVB.asp" -->
<%
Dim queryString : queryString = Request.QueryString()
Dim thisChartXML : thisChartXML = WA_DFC_getXMLFileContents("Graph_data8.asp", queryString)
Response.Write(WA_DFC_XML2ChartData(thisChartXML, queryString))
%>
Sign in to reply to this post

Ray BorduinWebAssist

What happens when you go to the page: Graph_data8.asp directly in the browser?

Sign in to reply to this post
Did this help? Tips are appreciated...

xag

I see my data that I want in a box

Y%20Axis%20Legend  
X%20Axis%20Legend
Ball Valves 4 Brand/Subsidiaries 1 BVH Product Page 1 Certifications 1 Contact us Page 13
Culture & Values 2 Home Page 145 Value Proposition 4
Fluid Control Valves sub-menu page 1 Global Footprint 2 History 1 Level Gauge Manifolds 1
NEWS Menu 3.1 2 NEWS Spry Main Menu 8 Pressure Gauges 1
Products Root Level Tab 11
Sign in to reply to this post

xag

hmm but when I go to this page DynamicWebCharts/Data/Graph_dataparser8.asp?

I get the following error

Microsoft VBScript runtime  error '800a000d'

Type mismatch: 'XAxisData'

/DynamicWebCharts/Data/wa_dfc_xmlVB.asp, line 422



Here is line 422

chartstr = chartstr & XAxisData(0)
Sign in to reply to this post

Ray BorduinWebAssist

Try:

chartstr = chartstr & cStr(XAxisData(0))

Sign in to reply to this post
Did this help? Tips are appreciated...

richard347309

This post has been deleted.

xag

Sorry Ray that didn't work and when I go to the page in the URL it still gives me the type mismatch error

Sign in to reply to this post
loading

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...