Link to home
Start Free TrialLog in
Avatar of csxhuang
csxhuang

asked on

Executive SQL command in CGI

Dear Madam/Sir,

The attached file is my HTML file. In the "comment.exe", I run the SQL command to insert the data to a database. I could check the data had been put in the correspond variables in "comment.exe". Why dos it appear "File Download" windows when run the sub-procedure including the SQL commands?
My email address is csxhuang@yahoo.com

Thanks!

csxhuang

------------------------------------------------------

<html>

<head>
<title>Òâ¼ûÏä</title>
</head>

<body bgcolor="#FFFFFF">
<div align="center"><center>

<table width="612" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td></td>
    <td align="right" valign="top"><form action="/cgi-bin/comment.exe" method="POST">
      <table border="0" width="100%">
        <tr>
          <td valign="top" align="right"><font size="-1">µç×ÓÓʼþÐÅÏä </font></td>
          <td><input type="text" size="30" name="email" maxlength="50"><br>
<spacer type="vertical" size="15">          </td>
        </tr>
        <tr>
          <td valign="top" align="right"><font size="-1">ϵͳƽ̨</font> </td>
          <td><select name="SYSTEM" size="1">
            <option>ϵͳƽ̨ </option>
            <option>MS Windows 3.1 </option>
            <option>MS Windows 95 </option>
            <option>UNIX </option>
            <option>Other </option>
          </select><br>
<spacer type="vertical" size="15">          </td>
        </tr>
        <tr>
          <td valign="top" align="right"><font size="-1">Ö÷Ìâ</font></td>
          <td><input type="text" size="30" name="URL_Subject"><br>
<spacer type="vertical" size="15">          </td>
        </tr>
        <tr>
          <td valign="top" align="left" colspan="2"><font size="-1">½¨ÒéËù¶ÔÍøÒ³ </font></td>
        </tr>
        <tr>
          <td valign="top" align="right"><font face="arial, helvetica" size="-1">URL</font></td>
          <td><input type="text" size="30" name="URL" maxlength="50"><br>
<spacer type="vertical" size="15">          </td>
        </tr>
        <tr>
          <td valign="top" align="right"><font size="-1">½¨Òé</font></td>
          <td><textarea rows="6" cols="25" name="url_comment">
</textarea><br>
<spacer type="vertical" size="9">          </td>
        </tr>
        <tr>
          <td></td>
          <td><input type="submit" name="Submit" Comments" value=" Ìá½» "> <spacer type="vertical" size="12"></td>
        </tr>
      </table>
    </form>
    </td>
  </tr>
</table>
</center></div>
</body>
</html>
ASKER CERTIFIED SOLUTION
Avatar of MaDdUCK
MaDdUCK
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of csxhuang
csxhuang

ASKER

Dear Dr. MaDdUCK,

Sorry for forget to tell you details! The opearting system is Windows 98, and the Web server is Microsoft FrontPage 98. I put the HTML file in the root, and the "comment.exe" file in cgi-bin.
Could you give me the suggest as soon as possible?
Thanks!!!

csxhuang

Avatar of MaDdUCK
MaDdUCK
Okay, there has to be something in Frontpgae to change the settings for the virtual directory cgi-bin. I don't have Frontpage myself so cannot say exactly, but I shall go and look aroung a little. If you can't get this to work I suggest that you deinstall the Frontpage webserver and user Windows 98's Peer Web Services (or Personal Web Server), whatever it is called. This program will have a nice utility where you can configure your cgi-bin correctly.
Avatar of csxhuang
csxhuang

ASKER

I think you are right. I will try it. I would trouble you again if it is out of order. Thanks a lot! csxhuang
Avatar of csxhuang
csxhuang

ASKER

Using WebSite 1.1, the problem is disappear. Thanks! csxhuang