SQL Named Query Example

This example shows how to use a aNamed Query, and display the query results. First add a few named queries (without parameters).

• Create a Label
• Create a Text input
• Create a Button

• Import the Named Query and rendeResultTable functions from function library.
• Add the Function doQuery listed below.
• Open button properties event tab, and set onclick = doQuery

Run the page preview, and try the named queries you setup.

The doQuery function

The doQuery function is used to execute the code. Add this function using the Add Function item in Function menu.

var qname = 'show pages';
var tfield = getWidgetByName('Textbox2');

if (tfield) qname = tfield.value;

   /* Get Ajax Client. */
   var ajaxdb = new Applibase.db.AjaxDb();
   
   /* Do a sql query, asynchronous with callback handler. */
   ajaxdb.query(qname, null, true, callback);
   
   /* Callback handler will be passed with resultSet and error.
    * If resultSet is null you will have to look at the error message.
    */
   function callback(resultSet, error) {
      if(resultSet == null) {
         alert(error + " Response Status:  " + ajaxdb.status());
      } else {
         ajaxdb.renderResultTable(resultSet);
      }
   }

What it Looks Like

• 
  
  
  

  © 2006 Applibase, Inc.