Wednesday, April 16, 2014

Show, Hide Rows In HTML


   <-- click here

parent A
child 1
child 2
parent B
child 3
child 4
parent C
child 5
child 6

One button, one function, one class name . . .

. . . no style sheets, no frameworks, no Adobe, no Silverlight, no HTML5, no baggage!

What does this have to do with SQL Anywhere?

For you, maybe nothing, maybe a lot, more on that later.

But first, the code:
<script Language="JavaScript"> 
   function showHideTrs ( buttonObject ) { 
      var trs = document.getElementsByClassName ( 'showHideTr' );
      var trCounter = trs.length;
      if ( buttonObject.value == "Show" ) {
         while ( trCounter-- ) {
            trs [ trCounter ].style.display = "table-row";
         }
         buttonObject.value = "Hide"; 
      } 
      else { 
         while ( trCounter-- ) {
            trs [ trCounter ].style.display = "none";
         }
         buttonObject.value = "Show"; 
      } 
   } 
</script> 
<input type="button" value="Hide" onClick="javascript:showHideTrs ( this );" STYLE="font-size: 10pt; text-decoration:underline; cursor:pointer; background-color: #E6E6E6; border-width: 0; ">
<table>
<tr><td>parent A</td></tr>
<tr class="showHideTr"><td>child 1</td></tr>
<tr class="showHideTr"><td>child 2</td></tr>
<tr><td>parent B</td></tr>
<tr class="showHideTr"><td>child 3</td></tr>
<tr class="showHideTr"><td>child 4</td></tr>
<tr><td>parent C</td></tr>
<tr class="showHideTr"><td>child 5</td></tr>
<tr class="showHideTr"><td>child 6</td></tr>
</TABLE> 
  • The HTML input button on line 19 calls the JavaScript function showHideTrs() defined on line 2.

  • The var trs on line 3 creates an array filled by calling the builtin getElementsByClassName() function which returns all the HTML elements on the page that have class="showHideTr".

  • The CSS class="ShowHideTr" attribute is specified for all the TR elements that are used to show child rows; i.e, lines 22 and 23, 25 and 26, etc.

  • There's no actual CSS class selector definition for the "ShowHideTr" class, it's just a name given to a bunch of TR elements so that getElementsByClassName() can find them all.

  • The rest of the code on lines 4 through 16 serves to switch the CSS display property between "none" and "table-row" (normal for a TR), as well as switching the button's visible value between "Hide" and "Show".

What about SQL Anywhere?

SQL Anywhere's builtin HTTP server can be used to directly display tables and rows via HTML, and sometimes the amount of data can be overwhelming, hence the desire for a "show hide" button.

OK, ok, it's all about Foxhound :)... the new Connection History page shows all the data collected for one connection every 10 seconds, including the SQL statement and the execution plan, and the result is the very definition of "overwhelming":



Sure, it's got "Show More / Show Less" buttons on the Last Statement and Last Plan Text lines, but it needs another button to make those lines disappear altogether:


Saturday, April 12, 2014

Latest SQL Anywhere Updates: Heartbleed (edit 1)

The entries marked Heartbleed contain OpenSSL code affected by the Heartbleed vulnerability.

The entries marked OK may be used to download the latest EBFs known to be unaffected by the Heartbleed vulnerability.

GA builds of version 16 are not shown on this page. Note that version 16 builds earlier than 16.0.0.1690 are unaffected by the Heartbleed vulnerability. Also note that version 12 builds earlier than 12.0.1.3994, and all version 11 builds, are unaffected. For more information see OpenSSL HeartBleed and SQL Anywhere.

Current builds for the active platforms...

HP-UX     16.0.0.1823                                         Heartbleed
 Itanium  16.0.0.1691                                         Heartbleed
          12.0.1.4081                                         Heartbleed
          12.0.1.3994                                         Heartbleed
          12.0.1.3894 (EBF 21788 SP60)    OK  13 Sep 2013
          11.0.1.3113 (EBF 22590 SP100)   OK  18 Mar 2014     End of Life 31 May 2014

IBM AIX   16.0.0.1691                                         Heartbleed
          12.0.1.3994                                         Heartbleed
          12.0.1.3894 (EBF 21787 SP60)    OK  13 Sep 2013
          11.0.1.3113 (EBF 22660 SP100)   OK  01 Apr 2014     End of Life 31 May 2014

Linux     16.0.0.1823                                         Heartbleed
          16.0.0.1691                                         Heartbleed
          16.0.0.1512 (EBF 21797 SP1)     OK  13 Sep 2013
          On Demand 1.0.4613 (SP3)        OK  13 Sep 2013
          12.0.1.4062                                         Heartbleed
          12.0.1.3994                                         Heartbleed
          12.0.1.3967 (EBF 21835 SP65)    OK  30 Sep 2013
          12.0.1 Chinese,                 OK  16 Apr 2013
                 Japanese Docs (Eclipse)  OK  16 Apr 2013
          11.0.1.3113 (EBF 22587 SP100)   OK  18 Mar 2014     End of Life 31 May 2014

Mac OS    16.0.0.1785                                         Heartbleed
          16.0.0.1565 (EBF 21800 SP3)     OK  13 Sep 2013
          12.0.1.4006                                         Heartbleed
          12.0.1.3958 (EBF 21796 SP64)    OK  19 Sep 2013
          11.0.1.2449 Update              OK  29 Jun 2010     End of Life 31 May 2014

Solaris   16.0.0.1691                                         Heartbleed
 SPARC    12.0.1.3994                                         Heartbleed
          12.0.1.3894 (EBF 21789 SP60)    OK  13 Sep 2013
          11.0.1.3113 (EBF 22661 SP100)   OK  01 Apr 2014     End of Life 31 May 2014

Solaris   16.0.0.1823                                         Heartbleed
 x64      16.0.0.1691                                         Heartbleed
          12.0.1.4081                                         Heartbleed
          12.0.1.3994                                         Heartbleed
          12.0.1.3894 (EBF 21790 SP60)    OK  19 Sep 2013
          11.0.1.3113 (EBF 22591 SP100)   OK  18 Mar 2014     End of Life 31 May 2014

Windows   16.0.0.1823                                         Heartbleed
          16.0.0.1761                                         Heartbleed
          16.0.0.1691                                         Heartbleed
          16.0.0.1644 (EBF 21802 SP5)     OK  13 Sep 2013
          On Demand 1.0.4613 (SP3)        OK  13 Sep 2013
          12.0.1.4085                                         Heartbleed
          12.0.1.4062                                         Heartbleed
          12.0.1.3994                                         Heartbleed
          12.0.1.3967 (EBF 21834 SP65)    OK  30 Sep 2013
          12.0.1 French,                  OK  25 Sep 2012
                 English,                 OK  25 Sep 2012
                 German,                  OK  25 Sep 2012
                 Chinese,                 OK  28 Mar 2013
                 Japanese Docs (HTML/PDF) OK  28 Mar 2013
          11.0.1.3113 (EBF 22624 SP100)   OK  18 Mar 2014     End of Life 31 May 2014 

Other Stuff...

 Older Updates

 Free support! Q&A forum
   ...or, call Tech Support

 SQL Anywhere...
   ...Sybase home page 
   ...SAP home page 
   ...SAP Developer Center 

 Buy SQL Anywhere 

 Developer Edition... 
   [16.0] [12.0.1(?)] [11.0.1]

 Download the Educational Edition 

 Supported Platforms...
   SQL Anywhere 
   Linux 
   OnDemand

 ODBC Drivers for MobiLink

Friday, April 11, 2014

Latest SQL Anywhere Updates: Heartbleed

For more information see OpenSSL HeartBleed and SQL Anywhere.

The entries marked Heartbleed contain OpenSSL code affected by the Heartbleed vulnerability.

The entries marked OK are known to be unaffected by the Heartbleed bug because they don't contain any OpenSSL code.

Current builds for the active platforms...

HP-UX     16.0.0.1823 (EBF 22636 SP9)         21 Mar 2014 Heartbleed
 Itanium  16.0 GA                         OK
          12.0.1.4081 (EBF 22633 SP69)        20 Mar 2014 Heartbleed
          12.0.1.3894 (EBF 21788 SP60)    OK  13 Sep 2013
          11.0.1.3113 (EBF 22590 SP100)   OK  18 Mar 2014     End of Life 31 May 2014

IBM AIX   16.0.0.1691 (EBF 22262 SP6)         11 Dec 2013 Heartbleed
          16.0 GA                         OK
          12.0.1.3994 (EBF 22136 SP66)        02 Dec 2013 Heartbleed
          12.0.1.3894 (EBF 21787 SP60)    OK  13 Sep 2013
          11.0.1.3113 (EBF 22660 SP100)   OK  01 Apr 2014     End of Life 31 May 2014

Linux     16.0.0.1823 (EBF 22589 SP9)         18 Mar 2014 Heartbleed
          16.0.0.1512 (EBF 21797 SP1)     OK  13 Sep 2013
          On Demand 1.0.4613 (SP3)        OK  13 Sep 2013
          12.0.1.4062 (EBF 22588 SP68)        18 Mar 2014 Heartbleed
          12.0.1.3967 (EBF 21835 SP65)    OK  30 Sep 2013
          12.0.1 Chinese,                 OK  16 Apr 2013
                 Japanese Docs (Eclipse)  OK  16 Apr 2013
          11.0.1.3113 (EBF 22587 SP100)   OK  18 Mar 2014     End of Life 31 May 2014

Mac OS    16.0.0.1785 (EBF 22412 SP8)         04 Feb 2014 Heartbleed
          16.0.0.1565 (EBF 21800 SP3)     OK  13 Sep 2013
          12.0.1.4006 (EBF 22318 SP67)        24 Dec 2013 Heartbleed
          12.0.1.3958 (EBF 21796 SP64)    OK  19 Sep 2013
          11.0.1.2449 Update              OK  29 Jun 2010     End of Life 31 May 2014

Solaris   16.0.0.1691 (EBF 22267 SP6)         11 Dec 2013 Heartbleed
 SPARC    16.0 GA                         OK
          12.0.1.3994 (EBF 22138 SP66)        03 Dec 2013 Heartbleed
          12.0.1.3894 (EBF 21789 SP60)    OK  13 Sep 2013
          11.0.1.3113 (EBF 22661 SP100)   OK  01 Apr 2014     End of Life 31 May 2014

Solaris   16.0.0.1823 (EBF 22635 SP9)         21 Mar 2014 Heartbleed
 x64      16.0 GA                         OK
          12.0.1.4081 (EBF 22634 SP69)        20 Mar 2014 Heartbleed
          12.0.1.3894 (EBF 21790 SP60)    OK  19 Sep 2013
          11.0.1.3113 (EBF 22591 SP100)   OK  18 Mar 2014     End of Life 31 May 2014

Windows   16.0.0.1823 (EBF 22519 SP9)         10 Mar 2014 Heartbleed
          16.0.0.1644 (EBF 21802 SP5)     OK  13 Sep 2013
          On Demand 1.0.4613 (SP3)        OK  13 Sep 2013
          12.0.1.4085 (EBF 22637 SP70)        21 Mar 2014 Heartbleed
          12.0.1.3967 (EBF 21834 SP65)    OK  30 Sep 2013
          12.0.1 French,                  OK  25 Sep 2012
                 English,                 OK  25 Sep 2012
                 German,                  OK  25 Sep 2012
                 Chinese,                 OK  28 Mar 2013
                 Japanese Docs (HTML/PDF) OK  28 Mar 2013
          11.0.1.3113 (EBF 22624 SP100)   OK  18 Mar 2014     End of Life 31 May 2014 

Other Stuff...

 Older Updates

 Free support! Q&A forum
   ...or, call Tech Support

 SQL Anywhere...
   ...Sybase home page 
   ...SAP home page 
   ...SAP Developer Center 

 Buy SQL Anywhere 

 Developer Edition... 
   [16.0] [12.0.1(?)] [11.0.1]

 Download the Educational Edition 

 Supported Platforms...
   SQL Anywhere 
   Linux 
   OnDemand

 ODBC Drivers for MobiLink

Monday, April 7, 2014

Latest SQL Anywhere Updates: 11.0.1 for AIX and SPARC

Current builds for the active platforms...

HP-UX     16.0.0.1823 (EBF 22636 SP9)     *  21 Mar 2014  *
 Itanium  12.0.1.4081 (EBF 22633 SP69)    *  20 Mar 2014  *
          11.0.1.3113 (EBF 22590 SP100)      18 Mar 2014     End of Life 31 May 2014

IBM AIX   16.0.0.1691 (EBF 22262 SP6)        11 Dec 2013
          12.0.1.3994 (EBF 22136 SP66)       02 Dec 2013
          11.0.1.3113 (EBF 22660 SP100)  *** 01 Apr 2014 *** End of Life 31 May 2014

Linux     16.0.0.1823 (EBF 22589 SP9)        18 Mar 2014
          On Demand 1.0.4613 (SP3)           13 Sep 2013
          12.0.1.4062 (EBF 22588 SP68)       18 Mar 2014
          12.0.1 Chinese,                    16 Apr 2013
                 Japanese Docs (Eclipse)     16 Apr 2013
          11.0.1.3113 (EBF 22587 SP100)      18 Mar 2014     End of Life 31 May 2014

Mac OS    16.0.0.1785 (EBF 22412 SP8)        04 Feb 2014
          12.0.1.4006 (EBF 22318 SP67)       24 Dec 2013
          11.0.1.2449 Update                 29 Jun 2010     End of Life 31 May 2014

Solaris   16.0.0.1691 (EBF 22267 SP6)        11 Dec 2013
 SPARC    12.0.1.3994 (EBF 22138 SP66)       03 Dec 2013
          11.0.1.3113 (EBF 22661 SP100)  *** 01 Apr 2014 *** End of Life 31 May 2014

Solaris   16.0.0.1823 (EBF 22635 SP9)     *  21 Mar 2014  *
 x64      12.0.1.4081 (EBF 22634 SP69)    *  20 Mar 2014  *
          11.0.1.3113 (EBF 22591 SP100)      18 Mar 2014     End of Life 31 May 2014

Windows   16.0.0.1823 (EBF 22519 SP9)        10 Mar 2014
          On Demand 1.0.4613 (SP3)           13 Sep 2013
          12.0.1.4085 (EBF 22637 SP70)    *  21 Mar 2014  *
          12.0.1 French,                     25 Sep 2012
                 English,                    25 Sep 2012
                 German,                     25 Sep 2012
                 Chinese,                    28 Mar 2013
                 Japanese Docs (HTML/PDF)    28 Mar 2013
          11.0.1.3113 (EBF 22624 SP100)      18 Mar 2014     End of Life 31 May 2014 

Other Stuff...

 Older Updates

 Free support! Q&A forum
   ...or, call Tech Support

 SQL Anywhere...
   ...Sybase home page 
   ...SAP home page 
   ...SAP Developer Center 

 Buy SQL Anywhere 

 Developer Edition... 
   [16.0] [12.0.1(?)] [11.0.1]

 Download the Educational Edition 

 Supported Platforms...
   SQL Anywhere 
   Linux 
   OnDemand

 ODBC Drivers for MobiLink

The 3 asterisks "***" mark items have appeared on the Sybase website since the previous version of this page.

The single asterisks "*" mark items that first appeared on the previous version of this page.
  • Only the latest fully-supported versions of SQL Anywhere (11.0.1, 12.0.1, 16.0 and On Demand) are shown here.

  • The "EBF 21788 SP60" numbers are the new SAP-specific codes associated with the build numbers "12.0.1.3894".

  • Just because an older version or different platform isn't "fully supported" any more doesn't mean you can't download files (or ask questions, or get help), it just means there won't be any more new Updates released.