Databases
StackOverflow2013
Postsdbo
POCFChart labels disappear
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POCFChart labels disappear
    primarykey
    data
    text
    <p>I'm running the following query and after running the QoQ for SECONDCONN , I am not getting the desired output in my cfchart.</p> <pre><code>&lt;!--- QoQ for FIRSTCONN ---&gt; &lt;!--- Master Query ---&gt; &lt;cfquery datasource = "XX.XX.X.XX" name="master1"&gt; SELECT STR_TO_DATE(date_format(Timedetail,'%m-%d-%Y'),'%m-%d-%Y') as FIRSTCONN , COUNT(Timedetail) as FIRSTOccurances , EVENTS FROM MyDatabase WHERE EVENTS = "FIRST" GROUP BY FIRSTCONN ; &lt;/cfquery&gt; &lt;!--- Detail Query ---&gt; &lt;!--- &lt;cfdump var = "#master#"&gt; ---&gt; &lt;cfquery dbtype="query" name="detail1"&gt; SELECT * FROM master1 WHERE FIRSTCONN &gt;= &lt;cfqueryparam value="#form.startdate#" cfsqltype="cf_sql_varchar"&gt; AND FIRSTCONN &lt; &lt;cfqueryparam value="#dateAdd('d', 1,form.enddate)#" cfsqltype="cf_sql_varchar"&gt;; &lt;/cfquery&gt; &lt;!--- QoQ for SECONDCONN ---&gt; &lt;!--- Master Query ---&gt; &lt;cfquery datasource = "XX.XX.X.XX" name="master2"&gt; SELECT STR_TO_DATE(date_format(Timedetail,'%m-%d-%Y'),'%m-%d-%Y') as SECONDCONN , COUNT(Timedetail) as SECONDOccurances , EVENTS FROM MyDatabase WHERE EVENTS = "SECOND" GROUP BY SECONDCONN ; &lt;/cfquery&gt; &lt;!--- Detail Query ---&gt; &lt;!--- &lt;cfdump var = "#master#"&gt; ---&gt; &lt;cfquery dbtype="query" name="detail2"&gt; SELECT * FROM master2 WHERE SECONDCONN &gt;= &lt;cfqueryparam value="#form.startdate#" cfsqltype="cf_sql_varchar"&gt; AND SECONDCONN &lt; &lt;cfqueryparam value="#dateAdd('d', 1,form.enddate)#" cfsqltype="cf_sql_varchar"&gt;; &lt;/cfquery&gt; &lt;cfchart format="flash" chartwidth="1000" chartheight="500" scalefrom="0" scaleto="50000" xAxisTitle="Dates" yaxistitle="Number of Connections"&gt; &lt;cfchartseries query="detail1" type="line" itemColumn="FIRSTCONN" valueColumn="FIRSTOccurances" &gt; &lt;cfchartseries query="detail2" type="line" itemColumn="SECONDCONN" valueColumn="SECONDOccurances" &gt; &lt;/cfchartseries&gt; &lt;/cfchart&gt; </code></pre> <p>On X Axis, the chart is displaying the correct <code>startdate</code> but it stops displaying the dates after middle point somewhere and rest of the line chart is displayed without any dates mentioned on the x-axis. What could be the reason? The dates are displaying properly when I ran just one query, that is QoQ for <code>FIRSTCONN</code>. </p> <p><img src="https://i.stack.imgur.com/xDpCw.jpg" alt="Image #1"> attached shows the output with only one query , that is QoQ for <code>FIRSTCONN</code></p> <p><img src="https://i.stack.imgur.com/RXfwD.jpg" alt="Image #2"> is for the both and showing undesirable output.</p> <p>Another point I noticed is that when I run the query for only SECONDCONN, I see an output without any dates mentioned on the x-axis. What could be th reason? I have attached <img src="https://i.stack.imgur.com/qYQVY.jpg" alt="image #3"> below for the reference.there is no change in the query.</p> <p>The cfchart code I'm using is as follows:</p> <pre><code>&lt;cfchart format="flash" chartwidth="1000" chartheight="500" scalefrom="0" scaleto="50000" xAxisTitle="Date" yaxistitle="Number of Connections" showLegend = "yes" showMarkers = "yes" sortXAxis= "yes" tipStyle="MouseDown" &gt; &lt;cfchartseries query="detail2" type="line" itemColumn="SECONDCONN " valueColumn="SECONDOccurances" &gt; &lt;/cfchartseries&gt; &lt;/cfchart&gt; </code></pre> <p>The cfdump of second query is as follows:</p> <pre><code>query RESULTSET query SECONDCONN SECONDOCCURANCES EVENTS 1 {ts '2013-06-24 00:00:00'} 556 SECOND 2 {ts '2013-06-25 00:00:00'} 2710 SECOND 3 {ts '2013-06-26 00:00:00'} 2854 SECOND 4 {ts '2013-06-27 00:00:00'} 6348 SECOND 5 {ts '2013-06-28 00:00:00'} 4285 SECOND 6 {ts '2013-06-29 00:00:00'} 2843 SECOND 7 {ts '2013-06-30 00:00:00'} 875 SECOND 8 {ts '2013-07-01 00:00:00'} 4033 SECOND 9 {ts '2013-07-02 00:00:00'} 3211 SECOND 10 {ts '2013-07-03 00:00:00'} 2882 SECOND 11 {ts '2013-07-04 00:00:00'} 978 SECOND 12 {ts '2013-07-05 00:00:00'} 1727 SECOND 13 {ts '2013-07-06 00:00:00'} 811 SECOND 14 {ts '2013-07-07 00:00:00'} 522 SECOND 15 {ts '2013-07-08 00:00:00'} 2556 SECOND 16 {ts '2013-07-09 00:00:00'} 1160 SECOND 17 {ts '2013-07-10 00:00:00'} 8580 SECOND 18 {ts '2013-07-11 00:00:00'} 2630 SECOND 19 {ts '2013-07-16 00:00:00'} 12 SECOND </code></pre> <p>Please let me know if I can answer more questions.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USTan
    1. USTan
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COWe need to see a dump of the query used for the chart to help with #1. Posting a screen shot would not hurt either. Question #2 should be posted separately. Hint: Read the documentation on [`<cfchart>`](http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/WSc3ff6d0ea77859461172e0811cbec22c24-7930.html) first, specifically the url attribute.
      singulars
      1. POCFChart labels disappear
      1. USLeigh
    2. CO@Leigh I have attached the images and updated my post. Please take a look at it.
      singulars
      1. POCFChart labels disappear
      1. USTan
    3. COAs you can see, the dates in second image stopped displaying after 2013-07-10
      singulars
      1. POCFChart labels disappear
      1. USTan
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload