code/.docs/prototype_Global/function_helma.sqlshell.Datasource.prototype.getColumns.html

   1 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0//EN">
   2 <html>
   3
   4 <head>
   5         <title></title>
   6         <style type="text/css">
   7
   8         body, p, td, th, li {
   9                 font-family: verdana, sans-serif;
  10                 font-size: 10pt;
  11         }
  12
  13         big.top {
  14                 font-size: 18pt;
  15                 font-weight: bold;
  16         }
  17
  18         big {
  19                 font-size: 13pt;
  20                 font-weight: bold;
  21         }
  22
  23         a {
  24                 font-weight:bold;
  25                 color: #cc3333;
  26                 text-decoration:none;
  27         }
  28         a:hover {
  29                 text-decoration:underline;
  30         }
  31
  32         .navig  {
  33                 font-size: 9px;
  34                 text-decoration: none;
  35                 font-weight:normal;
  36         }
  37
  38         li {
  39                 padding-bottom: 5px;
  40         }
  41
  42
  43         .mainbox        {
  44                 border-color:#999999;
  45                 padding-top:5px;
  46                 padding-bottom:5px;
  47                 border-bottom-width:1px;
  48                 border-bottom-style:dotted;
  49         }
  50
  51         .headline {
  52                 font-weight:bold;
  53                 background:#dfdfdf;
  54                 border-color:#999999;
  55                 padding-top:5px;
  56                 padding-bottom:5px;
  57         }
  58
  59         </style>
  60 </head>
  61
  62 <body>
  63
  64 <table width="90%" border="0" cellspacing="1" cellpadding="5">
  65 <tr>
  66         <td class="headline">
  67         <big><tt>Global.helma.sqlshell.Datasource.prototype.getColumns&nbsp;(meta,&nbsp;schema,&nbsp;table)</tt></big><br>
  68         </td>
  69 </tr>
  70
  71 <tr>
  72         <td class="mainbox">
  73
  74
  75         <ul>
  76
  77
  78
  79
  80
  81
  82         </ul>
  83         </td>
  84 </tr>
  85 </table>
  86
  87 <table width="90%" border="0" cellspacing="1" cellpadding="5">
  88 <tr>
  89         <td>Sourcecode in helmaTools.zip/Global/helma.sqlshell.js:
  90         <pre><font color="#aaaaaa">139:</font>   helma.sqlshell.Datasource.prototype.getColumns = function(meta, schema, table) {
  91 <font color="#aaaaaa">140:</font>       var columns = [];
  92 <font color="#aaaaaa">141:</font>       var t = meta.getColumns(null, schema, table, <font color="#9999aa">&quot;%&quot;</font>);
  93 <font color="#aaaaaa">142:</font>       while (t.next()) {
  94 <font color="#aaaaaa">143:</font>           columns.push(t.getString(4));
  95 <font color="#aaaaaa">144:</font>       }
  96 <font color="#aaaaaa">145:</font>       return columns;
  97 <font color="#aaaaaa">146:</font>   }
  98 </pre>
  99         </td>
 100 </tr>
 101
 102 </table>
 103
 104
 105
 106
 107
 108 </body>
 109 </html>