close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

textfields not showing on x-axis

Thread began 10/28/2010 3:05 pm by jonas.ottosson417319 | Last modified 11/01/2010 10:13 am by Jason Byrnes | 1371 views | 5 replies |

jonas.ottosson417319

textfields not showing on x-axis

I am trying to make a basic dynamic chart work like this:

I have a MySQL database table with a column "ID", and a column "instrument"
I want the chart to display the number of rows per instrument, so I choose
"instrument" for the x-label and I choose Group by value.
For the Y value I choose "ID" and I also choose calculation count.
The only result I get is a blank chart where the x-axis has the labels 0-10 (nothing to do with the "instrument" column that i want to be there.)
I keep getting the same result as long as I choose a text field for the x-label.
But when I choose a numeric field for the x-label the chart gives back a correct result.
Doesn´t Dynamic web charts support text fields in dynamic charts?
This could not be the case or what?

/Jonas

Sign in to reply to this post

Jason ByrnesWebAssist

The chart should work with text for the labels, can you send a link where i could see the problem to investigate the issue?

Sign in to reply to this post

jonas.ottosson417319

Thanks for your help!

Here´s a link to the page showing an empty chart with numbers on the x-axis, instead of the different instruments I want it to be there.

/Jonas

charttest.php

Sign in to reply to this post

Jason ByrnesWebAssist

when i view the xml:
charttest_data1.php


I see that one of the lines has an accented character that is not displaying properly:
<label>Klassisk s&#65533;ng</label>



Does it show correctly ion the database?


If so try setting the connection to use the utf-8 character set.

In the connection file, locate the closing php tag:
?>


and add this code before it:

php:
mysql_set_charset('utf8',$<your connection name>);



where <your connection name> is the name of your connection

Sign in to reply to this post

jonas.ottosson417319

That was the solution!

Now it works just fine.

Thank´s a lot for your help!

/Jonas

Sign in to reply to this post

Jason ByrnesWebAssist

great, glad to hear it is working.

Sign in to reply to this post

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...