Re: Informix & Intranet

Sally Woolrich wrote: > > We are thinking of setting up an Intranet project with Netscape browser, > TCP/IP & an Informix database at the other end. We will need to > validate form input before it gets written to the database. Any thought > / suggestions would be most welcome. > > -- > Sally Woolrich Hi Sally, I'm sure there are many solutions to your problem but I'll talk about one (W3SQL) I know about it as I have personally implemented some of its new features. You can use W3SQL together with Javascript (I suppose VBScript will also do it but I haven't test it yet) to achieve what you intend to do. For an example to validate an input on a form field you define the input tag for this field like: <input type="text" name="customer.customer_num" onChange="validate(this)" > and you define the following Javascript function function validate(obj) { document.forms[0].action="/sql=select" document.forms[0].db.value="yourdb" document.forms[0].st.value="select count(*) from customer" document.forms[0].submit() } After you change the content of the customer_num field its content will be validated against your database.You can instruct W3SQL to assign the result of your SQL operations in Javascript variables which you can further process. Another new feature is the support for Stored Procedures. You can pass your form input values to a Stored Procedure and let it do whatever you want to validate. You can have a look at http://wwwserv.orbit.de/w3sqldemo/ for a description/demo of W3SQL. Unfortunately this new features are not yet described at this URL but you can email me if you want further information. Regards Tolis +---------------------------------------------------------------------+ | V+K Relational Solutions email: tvarnas@compulink.gr | | Deligiorgi 26 tvarnas@orbit.de | | 546 42 Thessaloniki Voice: (30) 31 820270 | | Greece Fax: (30) 31 865463 | +---------------------------------------------------------------------+