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

chart from results page?

Thread began 10/04/2010 6:00 pm by pmd339638 | Last modified 10/05/2010 2:09 pm by Jason Byrnes | 1133 views | 5 replies |

pmd339638

chart from results page?

Is it possible to set up a search page where the user selects the variables (say state and county), and send those variables to Dynamic Charts to create a chart? Example: select Calif. and Orange County. Hit submit. Chart would appear on results page where you would see sales by year just for Orange County, Calif.

I tried tinkering with the XML but it doesn't seem to like the variables. thanks.

Sign in to reply to this post

Jason ByrnesWebAssist

yes this can be done.

how you go about it will depend on how complex the search is going to be.

will it just be the state? if so then you can create a search form with a submit button and a state form element. set the forms method to GET.

then when creating the chart, in the wizard, you can set the filtering section to filter the state on the URL perameter and enter the name of the state form element.

Sign in to reply to this post

pmd339638

Thanks

Thanks much for your reply. I will be using two variables, such as state and county. Will I have to go into the XML then and add another URL parameter?

Sign in to reply to this post

Jason ByrnesWebAssist

No, not in the xml, do this in the recordset.


in the dynamicwebcharts folder, there will be a file named <chartPageName>_data1.php, where <chartPageName> is the name of the page you added th;e chart to. the recordset that creates the chart will be on this page, Double click the recordset to edit it and add to the where clause. Examine how the first parameter was added to the where clause for an example on how to add the second one.

Sign in to reply to this post

pmd339638

Excellent. Thanks for the tips. This is a lot of help.

Sign in to reply to this post

Jason ByrnesWebAssist

you're welcome.

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