field "METHOD" in "<FORM>"

ts (decoux@moulon.inra.fr)
Fri, 12 Nov 93 06:30:43 +0100

> I saw your email a while back. I am *VERY* interested in using
> HTML+ forms as a front end to Sybase. I am trying to explain it
> to my Sybase programmer, but I'm not sure what is involved. What
> is it on the server side that you are using to pass your data
> from the form to the database?

Hello,

I use Oracle Precompilers.

Example :

When server receive :

/oracle/A/update/PROJETS?action=update&selection=ROWID%3D%27000002BF.0000.0003%27&PROJET=P145&TYPE=type+P1

C program is something like this :

putenv("ORACLE_SID=A");
putenv("ORACLE_HOME=/usr/local/oracle");
EXEC SQL CONNECT :username IDENTIFIED BY :password;
strcpy(tmp,"UPDATE PROJETS SET (PROJET='P145',TYPE='type P1') WHERE ROWID='000002BF.0000.0003'");
EXEC SQL EXECUTE IMMEDIATE :tmp;
EXEC SQL COMMIT WORK RELEASE;

Actually, it is a beta test version. When all is well, I put the complete
source of this interface on "moulon.inra.fr" in directory "/pub/www-oracle"

Guy Decoux