Ver Mensaje Individual
  #1 (permalink)  
Antiguo 25/02/2008, 12:10
Avatar de PedroJTR
PedroJTR
 
Fecha de Ingreso: febrero-2008
Ubicación: Guarenas, Venezuela
Mensajes: 116
Antigüedad: 17 años, 2 meses
Puntos: 1
Pregunta Insertando Formulario en BD Access

Saludos amigos..
Tengo un problemilla insertando mi form en una base de datos access...
Este es mi código, me da error 501 HTTP
¿Será que tengo mi cod mal?.. ustedes que dicen?
Código PHP:
<form id="formulario" name="formulario" method="post" action="nuevoclienteProceso.asp">
                <
table width="507" border="0" cellpadding="1" cellspacing="2">
 
                  <
tr>
                    <
td><div align="left"><strong>CÓDIGO </strong></div></td>
                    <
td colspan="4"><div align="left"><strong>
                      <
input name="id_cte" type="text" class="TEXT_AREA" id="id_cte" onkeyup="this.value=this.value.toUpperCase()" size="40" maxlength="15" readonly style="color:gray" />
                    </
strong></div></td>
                  </
tr>
                  <
tr>
                    <
td><div align="left"><strong>NOMBRE </strong></div></td>
                    <
td colspan="4"><div align="left">
                      <
input name="nom_cte" type="text" class="TEXT_AREA" id="nom_cte" size="40" />
                    </
div></td>
                  </
tr>
                  <
tr>
                    <
td width="83"><p align="left"><strong>TIPO PERSONA</strong></p>                      </td>
                    <
td width="56">
                      <
div align="left"><em>
                        <
script language="javascript">
      var 
f11 = new LiveValidation('nom_cte');
      
f11.addValidate.Length, { minimum} );
      
f11.addValidate.Presence );
         
</script>
                        NATURAL</em></div></td><td width="37"><div align="left"><em>
                          <input type="radio" name="tip_cte" id="tip_cte" value="N" onclick="rif_cte.disabled = false" />
                        </em></div></td>
                    <td width="54"><div align="left"><em>JURIDICA</em></div></td>
                    <td width="255"><div align="left"><em>
                      <input type="radio" name="tip_cte" id="tip_cte" value="J" onclick="rif_cte.disabled = false" />
                    </em></div></td>
                  </tr>
 
                  <tr>
                    <td><div align="left"><strong>RIF/C.I.</strong></div></td>
                    <td colspan="4"><div align="left">
                      <input name="rif_cte" type="text" class="TEXT_AREA" id="rif_cte" size="40" maxlength="11" disabled="disabled" onclick="ub_cte.disabled = false"/>
                      <script language="javascript">
      var f11 = new LiveValidation('rif_cte');
      f11.add( Validate.Length, { minimum: 10, maximum: 11 } );
      f11.add( Validate.Presence );
      f11.add( Validate.Inclusion, { within: [ 'J-' , 'j-', 'E-', 'e-', 'V-', 'v-' ], partialMatch: true } );
     </script>
                    </div>                      <div align="left"></div>                    <div align="left"></div></td>
                    </tr>
                  <tr>
                    <td valign="top"><div align="left"><strong>UBICACIÓN</strong></div></td>
                    <td colspan="4" valign="top"><div align="left">
                      <label>
                      <select name="ub_cte" class="TEXT_AREA" id="ub_cte" onchange="Codigo(this.id,'tip_cte','id_cte',this.form)" disabled="disabled" onfocus="dir_cte.disabled = false">
                        <option>--Seleccione un estado--</option>
                        <option value="E01">AMAZONAS</option>
                        <option value="E02">ANZOATEGUI</option>
                        <option value="E03">APURE</option>
                        <option value="E04">ARAGUA</option>
                        <option value="E05">BARINAS</option>
                        <option value="E06">BOLIVAR</option>
                        <option value="E07">CARABOBO</option>
                        <option value="E08">COJEDES</option>
                        <option value="E09">DELTA AMACURO</option>
                        <option value="E10">DISTRITO CAPITAL</option>
                        <option value="E11">FALCON</option>
                        <option value="E12">GUARICO</option>
                        <option value="E13">LARA</option>
                        <option value="E14">MERIDA</option>
                        <option value="E15">MIRANDA</option>
                        <option value="E16">MONAGAS</option>
                        <option value="E17">NUEVA ESPARTA</option>                      
                        <option value="E18">PORTUGUESA</option>
                        <option value="E19">SUCRE</option>
                        <option value="E20">TACHIRA</option>
                        <option value="E21">TRUJILLO</option>
                        <option value="E22">VARGAS</option>
                        <option value="E23">YARACUY</option>
                        <option value="E24">ZULIA</option>
                        <option value="I00">OTRO/INTERNACIONAL</option>
                            </select>
                      </label>
                    </div></td>
                  </tr>
                  <tr>
                    <td valign="top"><div align="left"><strong>DIRECCIÓN</strong></div></td>
                    <td colspan="4" valign="top"><label>
 
                        <div align="left">
                          <textarea name="dir_cte" cols="40" rows="5" class="TEXT_AREA" id="dir_cte" disabled="disabled"></textarea>
                          <script type="text/javascript">
              var dir_cte = new LiveValidation('dir_cte');
     dir_cte.add(Validate.Presence);
            </script>  
                        </div>
                    </label></td>
                  </tr>
                  <tr>
                    <td valign="top"><div align="left"><strong>TELEFONO</strong></div></td>
                    <td colspan="4"><div align="left">
                      <input name="telefono1" type="text" class="TEXT_AREA" id="telefono1" size="40" maxlength="11" onkeypress="noletras()"/>
                      <script language="javascript">
      var telefono1 = new LiveValidation('telefono1');
      telefono1.add( Validate.Length, { minimum: 11, maximum: 11 } );
      telefono1.add( Validate.Presence );
     </script>
                    </div></td>
                  </tr>
 
 
                  <tr>
                    <td><div align="left"><strong>FAX</strong></div></td>
                    <td colspan="4"><div align="left">
                      <input name="fax" type="text" class="TEXT_AREA" id="fax" size="40" maxlength="11" onkeypress="noletras()" />
                    </div></td>
                    </tr>
                  <tr>
                    <td>
                      <div align="left"><strong>CONTACTO</strong></div>
                    <td colspan="4">
                      <div align="left">
                        <input name="contac_cte" type="text" class="TEXT_AREA" id="contac_cte" size="40"/>                                                            
                        </div>
                    <tr>
                      <td><div align="left"><strong>EMAIL</strong></div>
                      <td colspan="4"><div align="left">
                        <input name="email_cte" type="text" class="TEXT_AREA" id="email_cte" size="40"/> 
                        <script type="text/javascript">
              var f1 = new LiveValidation('email_cte');
              f1.add(Validate.Email );
     f1.add(Validate.Presence);
            </script>   
                      </div>
                    <tr>
                      <td height="30" colspan="5"><div align="center">
                        <label>                        </label>
                        <table width="100%" border="0" cellspacing="2" cellpadding="0">
                          <tr>
                            <td height="35" valign="bottom"><div align="center">
                              <input type="image" value="submit" name="entrar" src="imagenes/but_ingresarcte.jpg" id="entrar"/>
                            </div>
                              <div align="left"></div></td>
                            </tr>
                        </table>
                        <label></label>
                      </div>
                    </table>
                            </form> 
Código PHP:
<%
Dim oConnid_ctefechai_ctenom_ctetip_cte,rif_cte,dir_cte,tel_cte,tel2_cte,fax_cte,contac_cte,mail_cte
id_cte 
Request("id_cte")
fechai_cte Date
nom_cte 
Request("nom_cte")
tip_cte Request("tip_cte")
rif_cte Request("rif_cte")
dir_cte Request("dir_cte")
tel_cte Request("tel_cte")
fax_cte Request("fax_cte")
contac_cte Request("contac_cte")
mail_cte Request("mail_cte")
Set oConn Server.CreateObject("ADODB.Connection"
oConn.Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" Server.MapPath("masstramites.mdb"))
oConn.execute "INSERT INTO clientes(id_cte,fechai_cte,nom_cte,tip_cte,rif_cte,dir_cte,tel_cte,fax_cte,contac_cte,mail_cte) VALUES('"&id_cte&"','"&fechai_cte&"','"&nom_cte&"','"&tip_cte&"','"&rif_cte&"','"&dir_cte&"','"&tel_cte&"','"&fax_cte&"','"&contac_cte&"','"&mail_cte&"')"
oConn.Close
Set oConn 
nothing
%> 

Última edición por PedroJTR; 25/02/2008 a las 12:15