Qilan Demonstrations
| AbacusExpressions | This page explores the functionalities of the abacus. Each abacus is evaluated with user data so you can see what can be done with these preconfigured expressions. Qilan automatically translates abacus expressions to SQL so you can concentrate on business logic rather than arcane syntax. |
| Validation | This page shows what can be done to evaluate incoming data. Although you can use JavaScript, Qilan makes this optional or unnecessary. |
| Entering Data | This page shows how user data can be submitted and entered directly into a data base. For this demonstration, we are using FrontBase, but OpenBase, Oracle or Helix can be used equally as well. |
| Updating Data | This page demonstrates two methods to update existing records. Using the primary record key we directly enter the new data and update. Or, we can click the primary key from the list. When this is performed, the data is retrieved and displayed in a new window for editing. Both the FORM methods 'post' and 'get' are demonstrated. |
| Listing, Retrieval and Editing Records | This page uses the sample Company database provided by Openbase. When OpenBase is installed, several sample databases are provided. This demo lists the companies in the database, allows retrieval of the company record, and editing of the record. This example Qilan project is available for download. |
| DeleteData | This page shows how user data can be deleted from a data base. For this demonstration, we are using the record's primary key as the link. We can also remove an entire table or use dynamic query criteria. |
| Searching Data | This page uses a typical search using boolean logic. Qilan translates user's selections into SQL while maintaining an easy to use interface. Search criteria is case specific, but this optional with the use of abacus expressions. For a list of records to search for, refer to "Entering Data". |
| Summarizing Data | This page performs aggregate calculations with no user input. As soon as the page loads, the database is queried and totals are returned. |
| Find then Create | This page locates data in one table, then automatically creates records in a second table. Although we are merely moving data from one table to another within the same database, Qilan can just as easily move data between databases located at the same location or anywhere in the world. Also note that duplicates are not created. |
| Group and Summarize Data | This is a simple demonstration as to how to format reports. The outer table displays the text field for all records. The inner table does the same thing, except a query is used to match it's list to the header record. Qilan uses a powerful interation feature to find, then find next until all records meeting a query criteria are met. Reports can therefore be grouped and summarized with very little effort. |
| Looping and Iteration | Without ever accessing the database, Qilan performs iteration. This page accepts user text then loops it for a set number of times. Qilan automatically stops the looping after a set number of times. This is a user preference. |
| Accessing System Scripts | Qilan makes it possible to access to power, flexibilty and verstility of UNIX and Perl scripting as well as running ANY executable file. Parameters can be passed and standard output returned directly to Qilan. The following page runs some 'stock' UNIX scripts and retrieves a text file from the server. You can also use QRUN to automatically run Qilan web pages. |
| Zip Code Search Example | We wanted to have a working example of querying a decent sized dataset. The day that MacWorld New York started we had a text file containing all the Zip Codes, Towns, and Counties in the US. We built a quick template, exported the schema to an empty FrontBase database and imported the 42 thousand some odd records in less than an hour. This is a slightly dressed up version. |
| Capture Example | This example demonstrates how to perform data entry from a list of records. The entire list is submitted as a whole, yet processed individually. No looping or interation is used or required. This approach is very useful for e-commerce sites or when the number of list items is not known in advance. |
| Login and Session Server Example | This example demonstrates some of the new Qilan 2.0 features. A login process with name and password validation is demonstrated. The example shows how to protect site pages from direct access without having logged in. The session server maintains the login information while the pages are traversed. This example project is available for download. |
| Text search with Recursion Example | Have you ever needed to validate a document or block of text to make sure it didn't contain troublesome characters? This example shows how Qilan can "pre-process" text prior to database access. This example project is available for download. |
| Secure Socket Layer (SSL) and Qilan | SSL is the standard method on the web today to protect confidential data exchange between a web browser and a web server. Qilan works with Apache (the web server) in this web page exchange process. This simple example shows a Qilan page that is encrypted via SSL. |
| 3 month Calendar example | This example creates a listing type calendar for a three month period. Database access is not required. This example project is available for download. |
| Qilan version 3 tour page | This page of examples showcases our newest Qilan version and technology. The examples use JSP as the page export format and Tomcat as the "engine" to serve the pages. |