close ad
WARNING PC USERS: Do Not Install the DREAMWEAVER CC 2017 Update »
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

value problem

Thread began 10/01/2009 7:02 am by denley525389423 | Last modified 10/16/2009 6:18 pm by Ray Borduin | 3255 views | 10 replies |

denley525389423

value problem

When attempting to create a bar chart from a MySQL table, the chart appears as 'undefined'. When using the wizard to edit the chart, I get the message

'Please use only numerical entires (sic) for values'

The x axis is student ID and the value is the number of merits received,a numerical value. Is there any way I can overcome this?

Many thanks in advance for your help.

Sign in to reply to this post

Eric Mittman

What is the result you get if you attempt to make a chart like this but use static values in the wizard? I'm wondering if it is just a db related issue or a problem with the installation that you have. If it is only a db issue please post back with a copy of the db if it is ok for public posting. If you need to post files privately let me know and I can open a ticket for you.

Sign in to reply to this post

denley525389423

same result for static

Thanks Eric, and thanks also for dealing with my earlier issue so well.

Static gives the same result. Additionally, I have displayed db results in tables etc with no issues in the app. Whenever I view the pages the chart appears as undefined. I have attached the code from the chart page, the associated data page and the parser page if this helps.

Many thanks again.

Attached Files
undefined_chart.txt
Sign in to reply to this post

Eric Mittman

Do you have a link to a live page with this on it? With the page you posted and seeing the end result on a server I will be able to get a better idea of what is going wrong.

Sign in to reply to this post

denley525389423

still not working- see live page

Thanks

Please got to www.ccsparentzone.info and enter the following in the 'UPN' field:
G908200700013

From the next page, select 'chart'. as you will see, it only displays as undefined.

Any help most appreciated!

Many thanks

Sign in to reply to this post

Ray BorduinWebAssist

Go to: charts_dataparser1.php

and

charts_data1.php

That will show you the errors causing the chart not to show.

Sign in to reply to this post

denley525389423

now just displays code

Thanks Ray

I altered the code to render to call the data connection which removed the error, but now only a line of code displays- follow previous links to seewhat I mean. I have attached the code that seems to be the cause.

Attached Files
code.txt
Sign in to reply to this post

Ray BorduinWebAssist

The pages are completely blank when I view them now. It doesn't give me much to go on. You must have some sort of error or else the data1 page would not be blank.

Start by working on getting content on the data1 page and everything else should fall into place.

Sign in to reply to this post

denley525389423

getting closer but...

I can now display a chart from the database but it all goes wrong when I try to apply a filter based on session variable. I know the variable is fine as it filters all my recordsets. When I go in to edit the chart in the wizard, it doesn't even remember the variable and the 'filter' option is set to 'none'. I really need the filter to work as each chart should be unique to the UPN of the student.

Sign in to reply to this post

denley525389423

Problem solved!

OK, managed to sort this. In the data page I used DW to edit the recordset to ensure the session variable was picked up. The wizard won't create the code 100% so some manual editing is required. I'm now going to experiment with passing on a variety of filters as some charts will need to carry two or more.

Thanks for all the help Ray

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