Results 1 to 2 of 2

Thread: Form won't post to database.

  1. #1
    Join Date
    Mar 2007
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Angry Form won't post to database.

    Hi there - I need some help with my code if you all might be so kind. Here is the scope - I have created a 2 page database app that will create and show work orders when I create them. I am currently running this on my home IIS but will be getting ready to upload to my web server. See the first page - I had it posting to the database, but now since I have created the second page that displays the results of the database - the posting page won't post.

    Here is the code of the posting page (can you show me what I am doing wrong? Please bear in mind I am somewhat programming challenged as I do not speak tech in this way. So please make your explanation easy to follow if you could.

    Okay - here is my code for my form page:

    <%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
    <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
    <html>
    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
    <title>Ekho3 Technology Work Orders</title>
    <style type="text/css">
    <!--
    body,td,th {
    font-family: Verdana, Arial, Helvetica, sans-serif;
    font-size: 10px;
    }
    -->
    </style>
    <script language="JavaScript" type="text/JavaScript">
    <!--
    function MM_reloadPage(init) { //reloads the window if Nav4 resized
    if (init==true) with (navigator) {if ((appName=="Netscape")&&(parseInt(appVersion)==4)) {
    document.MM_pgW=innerWidth; document.MM_pgH=innerHeight; onresize=MM_reloadPage; }}
    else if (innerWidth!=document.MM_pgW || innerHeight!=document.MM_pgH) location.reload();
    }
    MM_reloadPage(true);
    //-->
    </script>
    <link href="style/css.css" rel="stylesheet" type="text/css">
    <style type="text/css">
    <!--
    a:link {
    color: #000000;
    }
    a:hover {
    color: #990000;
    }
    a:visited {
    color: #000000;
    }
    -->
    </style></head>

    <body>
    <form action="changerequests.asp" method="post" name="workorders" id="workorders">
    <p class="heading">Ekho3 Technology Work Order Request </p>
    <p><a href="changeorderresults.asp">Change Order Results</a> </p>
    <div id="lrsenddata" style="position:absolute; width:200px; height:115px; z-index:1; left: 467px; top: 60px;" class="aspfont">
    <%
    set conn=Server.CreateObject("ADODB.Connection")
    conn.Provider="Microsoft.Jet.OLEDB.4.0"
    conn.Open "C:/Inetpub/wwwroot/ekho3/WorkOrders/workorders.mdb"

    sql = "INSERT INTO workorder (clientname, mdate, workordernumber, priority, datedue, approval, designtime, description, completed, completiondate, hoursused, followupnotes) VALUES ('" & Request.Form("clientname") & "','" & Request.Form("mdate") & "','" & Request.Form("workordernumber") & "','" & Request.Form("priority") & "','" & Request.Form("datedue") & "','" & Request.Form("approval") & "','" & Request.Form("designtime") & "','" & Request.Form("description") & "','" & Request.Form("completed") & "','" & Request.Form("completiondate") & "','" & Request.Form("hoursused") & "','" & Request.Form("followupnotes") & "')"
    on error resume next
    conn.Execute sql,recaffected
    if err<>0 then
    Response.Write("")
    else
    Response.Write("<h3>" & recaffected & " record added</h3>")
    end if
    conn.close
    %>
    </div>
    <table border="0" cellpadding="4" cellspacing="0">
    <tr>
    <td valign="top">Client Name: </td>
    <td><select name="clientname" id="clientname">
    <option value="Bella Vista Church">Bella Vista Church</option>
    <option value="Betty Rummel">Betty Rummel</option>
    <option value="CD McDonald">CD McDonald</option>
    <option value="Crossroads Church">Crossroads Church</option>
    <option value="Data Specialists">Data Specialists</option>
    <option value="Ekho3 Photography">Ekho3 Photography</option>
    <option value="Ekho3 Technology">Ekho3 Technology</option>
    <option value="Front Door Realty">Front Door Realty</option>
    <option value="GoZabo.com">GoZabo.com</option>
    <option value="Jeffrey Parker Architect">Jeffrey Parker Architect</option>
    <option value="Judy Williams">Judy Williams</option>
    <option value="Kim Selesky">Kim Selesky</option>
    <option value="Klackle Orchards">Klackle Orchards</option>
    <option value="Mari-Mar Antiques">Mari-Mar Antiques</option>
    <option value="Merritt Auction Services">Merritt Auction Services</option>
    <option value="Merrill & Margaret Russell">Merrill &amp; Margaret Russell</option>
    <option value="Micro Visions, Inc.">Micro Visions, Inc.</option>
    <option value="MVI - Bright Technologies">MVI - Bright Technologies</option>
    <option value="MVI - Burns Contracting">MVI - Burns Contracting</option>
    <option value="MVI - Ed Young, DDS.">MVI - Ed Young, DDS.</option>
    <option value="MVI - Heather Lane Pottery">MVI - Heather Lane Pottery</option>
    <option value="MVI - John Tamboer">MVI - John Tamboer</option>
    <option value="MVI - Sebright Products">MVI - Sebright Products</option>
    <option value="MVI - Tyrone Township">MVI - Tyrone Township</option>
    <option value="MVI - United Electric">MVI - United Electric</option>
    <option value="Michigan Fundraising">Michigan Fundraising</option>
    <option value="Pique, LLC.">Pique, LLC.</option>
    <option value="Robin & Patrick Strong">Robin &amp; Patrick Strong</option>
    <option value="Rockford Package Supply">Rockford Package Supply</option>
    <option value="Russell Siding">Russell Siding</option>
    <option value="Sow Hope">Sow Hope</option>
    <option value="The Studio Salon">The Studio Salon</option>
    <option value="The Gameroom Guys">The Gameroom Guys</option>
    <option value="Thomas Home Interiors">Thomas Home Interiors</option>
    <option value="Trinitas Classical School">Trinitas Classical School</option>
    <option value="Turk Lake Auto Sales">Turk Lake Auto Sales</option>
    <option value="Wise Photography">Wise Photography</option>
    </select></td>
    </tr>
    <tr>
    <td valign="top">Date: </td>
    <td><input name="mdate" type="text" id="mdate" size="27"></td>
    </tr>
    <tr>
    <td valign="top">Priority Level: </td>
    <td><select name="priority" id="priority">
    <option value="1 - Urgent (ASAP)">1 - Urgent (ASAP)</option>
    <option value="2 - High (2 Days)">2 - High (2 Days)</option>
    <option value="3 - Medium (1 Week)" selected>3 - Medium (1 Week)</option>
    <option value="4 - Low (2 Weeks)">4 - Low (2 Weeks)</option>
    <option value="5 - Pending Contact">5 - Pending Contact</option>
    </select></td>
    </tr>
    <tr>
    <td valign="top">Approved: </td>
    <td><select name="approval" id="approval">
    <option value="Approved" selected>Yes</option>
    <option value="Not Approved">No</option>
    </select></td>
    </tr>
    <tr>
    <td valign="top">Estimated Design Time: </td>
    <td><input name="designtime" type="text" id="designtime" size="8">
    Hrs. </td>
    </tr>
    <tr>
    <td valign="top">Job Desciption: </td>
    <td><textarea name="description" cols="45" rows="6" id="description"></textarea></td>
    </tr>
    <tr>
    <td valign="top">Completed: </td>
    <td><select name="completed" id="completed">
    <option value="Completed">Yes</option>
    <option value="Not Completed" selected>No</option>
    </select></td>
    </tr>
    <tr>
    <td valign="top">&nbsp;</td>
    <td><div align="right">
    <input type="submit" name="Submit" value="Submit">
    <input type="reset" name="Reset" value="Reset">
    </div></td>
    </tr>
    </table>
    </form>
    </body>
    </html>

    Thank you for all of your help!!

  2. #2
    Join Date
    Mar 2007
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default By the way...

    Not sure if I mentioned, but the form was working fine until I created the second page that shows me the results of the database. Now it won't work. I don't understand if something in this second page screwed things up for the first. I am coding in Dreamweaver too.

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •