IngWebGen: Ingres Web Generator

Demo Version Rel. 1.0

1. Description

IngWebGen enables you to generate HTML and CGI scripts to query and display data from INGRES tables or views. You select a table or view from a database and IngWebGen will display all the fields with attributes like: Fieldname, Fieldtext, Fieldtype and Fieldlength.

By changing Fieldtext and/or Fieldlength you are selecting fields, you are modifying the column header of a field and you are specifying the length of the display of a field.

Three scripts are generated:

HTML form search method 1: allows you to search for the first n characters of a field

HTML form search method 2: allows you to search any selected field using the operators: LIKE, equal first n characters, equal (=), not equal (<>), greater than (>), greater or equal (>=), smaller than (<), smaller or equal (<=).

CGI script: allows you to display the data as SimpleFields, TableField and HTML Table
HTML form search method 1: allows you to search for the first n characters of a field

HTML form search method 2: allows you to search any selected field using the operators: LIKE, equal first n characters, equal (=), not equal (<>), greater than (>), greater or equal (>=), smaller than (<), smaller or equal (<=).

CGI script: allows you to display the data as SimpleFields, TableField and HTML Table
HTML form search method 2: allows you to search any selected field using the operators: LIKE, equal first n characters, equal (=), not equal (<>), greater than (>), greater or equal (>=), smaller than (<), smaller or equal (<=).

CGI script: allows you to display the data as SimpleFields, TableField and HTML Table
CGI script: allows you to display the data as SimpleFields, TableField and HTML Table

The features of IngWebGen Rel. 1.0 include:

2.1. Select Tablename

2.2. Enter Programname

2.3. Select fields

2.4. Change length of field

2.5. Change column header of field

3.1. Search for matching first n characters

3.2. Search any selected field using the operators: LIKE,

4.1. Display as SimpleFields

4.2. Display as TableField

4.3. Display as HTML Table

4.4. Modify Table Layout

4.5. Sort by any field

2. Parameters for the generation

2.1. Select Tablename

Please select a table:

rubis_committee - addresses of the RUBIS committee members

www_exhibitor_test - exhibitor information of TELECOM 95

2.2. Enter Programname

Please enter a special programname because this test version of the HTML generator can be used by several persons.

2.3. Select fields

By default all fields are selected. If you want to ignore a field please enter 0 as Fieldlength.

2.4. Change length of field

Modify Fieldlength.

2.5. Change column header of field

Modify Fieldtext.

3. Search methods

3.1. Search method 1
Search for matching first n characters

3.2. Search method 2
Search any selected field using the operators: LIKE, equal first n characters, equal (=), not equal (<>), greater than (>), greater or equal (>=), smaller than (<), smaller or equal (<=).

4. Display data

CGI script which allows you to display the data as SimpleFields, TableField and HTML Table, modify the layout of the TableField and HTML Table display, sort by any field

4.1. Display as Simple Fields

style                         Madame
first_name                    Monique
last_name                     LONG
company                       HCU  CIH
department                    
street                        24, rue Micheli du Crest
post_box                      
zip_code                      1211
city                          GENEVE  14
phone                         021/372.62.74
fax                           022/372.62.55
remarks

4.2. Display as TableField

Search: last_name > H --- Click on the column name you wish to sort on



style                first_name           last_name            company                                            department                                         street                                             post_box                                           zip_code   city                 phone                fax                  remarks                                            

Monsieur             Akram                HAJJAOUI             Université de Lausanne                             Centre Informatique                                33, rte de Chavannes                                                                                  1007       LAUSANNE             021/692.22.53        021/692.22.05                                                           
Madame               Monique              LONG                 HCU  CIH                                                                                              24, rue Micheli du Crest                                                                              1211       GENEVE  14           021/372.62.74        022/372.62.55                                                           
Monsieur             Daniel               PETITHUGUENIN        DTPAT                                              Ser. routes et autoroutes                          3, av. de l'Université                                                                                1014       LAUSANNE             021/316.70.91        021/316.71.19                                                           
Monsieur             Michel               ROCH                 DTPE                                                                                                  5, David Dufour                                                                                       1211       GENEVE  8            022/327.47.04        022/328.43.82                                                           
Monsieur             Michel               WALTER               DTPAT                                              Service des Bâtiments                              10, place de la Riponne                                                                               1014       LAUSANNE             021/316.73.02        021/316.73.47        021/316.73.02 (Lu->Mer) 021/691.06.64 (Je->Ve)     
Monsieur             Wolfgang             WOHLLEBER            UIT                                                                                                   Place des Nations                                                                                     1211       GENEVE  20           022/730.58.97        022/730.53.37                                                           

Number of rows found : 6

4.3. Display as HTML Table

Search: last_name < G --- Click on the column name you wish to sort on

style first_name last_name company department street post_box zip_code city phone fax remarks

Monsieur Dominique CENTENO Institut de Pathologie 25, rue du Bugnon 1011 LAUSANNE 021/314.71.17 021/652.08.80 bip: 021/802.22.11
Monsieur Georges DUMOULIN QUOD S.A. Grand-Rue, 4 1095 LUTRY 021/792.12.83 021/792.12.90
Monsieur Hervé DuBois IPB - NCS 29-31, rte de l'Aéroport Case postale 599 1215 GENEVE 15 022/929.83.56 022/929.83.83
Monsieur Eric EGGEN Loterie Suisse Romande 15, rue du Marterey 1005 LAUSANNE 021/311.45.55 021/320.00.25
Monsieur Hubert FREY Computer Associates S.A. Avenue Reverdil, 2 1260 NYON 022/362.26.10 022/362.26.51

style	first_name	last_name	company	street	post_box	zip_code	city	phone	fax	remarks
Monsieur	Dominique	CENTENO	Institut de Pathologie	25, rue du Bugnon		1011	LAUSANNE	021/314.71.17	021/652.08.80	bip: 021/802.22.11
Monsieur	Georges	DUMOULIN	QUOD S.A.	Grand-Rue, 4		1095	LUTRY	021/792.12.83	021/792.12.90
Monsieur	Hervé	DuBois	IPB - NCS	29-31, rte de l'Aéroport	Case postale 599	1215	GENEVE 15	022/929.83.56	022/929.83.83
Monsieur	Eric	EGGEN	Loterie Suisse Romande	15, rue du Marterey		1005	LAUSANNE	021/311.45.55	021/320.00.25
Monsieur	Hubert	FREY	Computer Associates S.A.	Avenue Reverdil, 2		1260	NYON	022/362.26.10	022/362.26.51

Number of rows found : 5

4.4. Modify Table Layout

You can modify the column width.

You can delete a column from the display. Setting the column width to 0 will ignore the field for display.

You can reorder the column position, but make sure that each position is unique.

4.5. Sort by any field

Search: last_name > H --- Click on the column name you wish to sort on



style                first_name           last_name            company                                            department                                         street                                             post_box                                           zip_code   city                 phone                fax                  remarks                                            

5. Currently in development
Display as Form

Display on row at a time using HTML fill-out-forms
Next and Previous keys to scroll forward and backward

Display as Reportn n - 1 .. 5

Display a standard report with each field on a separate line
The reports can be customized directly on the WEB

Modify Report

To customize reports