field "METHOD" in "<FORM>"

decoux@moulon.inra.fr (ts)

Mail folder: WWW Talk Oct 93-present
Next message: Tony Sanders: "Re: httpd scripts for WAIS queries. "
Previous message: Steve Romig: "Socially correct URLs for archived RFCs"
In-reply-to: Paul Everitt: "Re: field "METHOD" in "<FORM>""

Date: Fri, 12 Nov 93 06:30:43 +0100
From: decoux@moulon.inra.fr (ts)
Message-id: <9311120530.AA10415@moulon.moulon.inra.fr>
To: peveritt@pandora.ncts.navy.mil
Cc: www-talk@nxoc01.cern.ch
In-reply-to: Paul Everitt's message of Thu, 11 Nov 1993 18:53:54 +0600 <9311120053.AA05706@voltaire.ncts.navy.mil>
Subject: field "METHOD" in "<FORM>"


> 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