Tema: 3 combobox dependientes
Ver Mensaje Individual
  #15 (permalink)  
Antiguo 28/02/2009, 07:10
hugorei
(Desactivado)
  
Fecha de Ingreso: agosto-2002
Mensajes: 1.458
Antigüedad: 22 años, 4 meses
Puntos: 0
Respuesta: 3 combobox dependientes
<HTML>
<HEAD>
<TITLE>caterpillar</TITLE>
<META HTTP-EQUIV="" CONTENT="text/html; charset=iso-8859-1">
</HEAD>
<BODY BGCOLOR=#000000 text="#FFFF00" link="#FF0000" LEFTMARGIN=0 TOPMARGIN=0 MARGINWIDTH=0 MARGINHEIGHT=0>
<div align="center">
<TABLE WIDTH=797 BORDER=0 CELLPADDING=0 CELLSPACING=0>
<!--DWLayoutTable-->
<TR>
<TD COLSPAN=3> <IMG SRC="caterimagen/caterpillar_01.jpg" WIDTH=797 HEIGHT=159 ALT=""></TD>
</TR>
<TR>
<TD COLSPAN=3> <IMG SRC="caterimagen/caterpillar_02.jpg" WIDTH=797 HEIGHT=14 ALT=""></TD>
</TR>
<TR>
<TD ROWSPAN=2> <IMG SRC="caterimagen/caterpillar_03.jpg" WIDTH=33 HEIGHT=427 ALT=""></TD>
<TD width="725" height="399" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<TD width="725" height="399" valign="top">
<div align="center">
<table width="75%" border="0">
<tr>
<td width="89%"><div align="center"><font color="#FFFF00" face="Arial, Helvetica, sans-serif"><strong><u>RESULTADO
DE SU BUSQUEDA </u></strong> </font></div></td>
<td width="11%">
<%
Dim oConn, rs, SQL, cuenta, categoria


Set oConn = Server.CreateObject("ADODB.Connection")
set rs=Server.CreateObject("ADODB.Recordset")

oConn.open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source= " & Server.MapPath("ejemplo.mdb")&" ; Jet OLEDB:Database Password=741"
SQL="SELECT P.*,C.NomCategoria FROM Productos AS P,Categorias AS C WHERE P.Categoria=C.idCategoria AND P.IdProducto="&Request.Form("Productos")
rs.Open SQL, oConn
%>
</td>
</tr>
</table>

</div>
<div align="center">
<table width="90%" height="52" border="1" cellpadding="0" cellspacing="0" bordercolor="#CC9900">
<tr>
<td><div align="center">
<table width="649" bordercolor="#FF0000" >
<tr>
<td width="641"><strong><font face="Arial, Helvetica, sans-serif">Marca
</font></strong><font face="Arial, Helvetica, sans-serif">:
<font color="#FF0000" size="+1"><strong><%=rs("NomCategoria")%></strong></font></font></td>
</tr>
<tr>
<td><strong><font face="Arial, Helvetica, sans-serif">Modelo:</font></strong>
<font color="#FF0000" size="+1" face="Arial, Helvetica, sans-serif"><strong><%=rs("nombre")%></strong></font></td>
</tr>
<tr>
<td><strong><font face="Arial, Helvetica, sans-serif">Serie:</font></strong>
<font color="#FF0000" size="+1" face="Arial, Helvetica, sans-serif"><strong><%=rs("serie")%></strong></font></td>
</tr>
<tr>
<td><strong><font face="Arial, Helvetica, sans-serif">Motor:</font></strong>
<font color="#FF0000" size="+1" face="Arial, Helvetica, sans-serif"><strong><%=rs("motor")%></strong></font></td>
</tr>
<tr>
<td><strong><font face="Arial, Helvetica, sans-serif">A&ntilde;o</font></strong><font face="Arial, Helvetica, sans-serif">:
<font color="#FF0000" size="+1"><strong><%=rs("año")%></strong></font></font></td>
</tr>
<tr>
<td><strong><font face="Arial, Helvetica, sans-serif">Aire:</font></strong>
<font color="#FF0000" size="+1" face="Arial, Helvetica, sans-serif"><strong><%=rs("aire")%></strong></font></td>
</tr>
<tr>
<td><strong><font face="Arial, Helvetica, sans-serif">Aceite:</font></strong>
<font color="#FF0000" size="+1" face="Arial, Helvetica, sans-serif"><strong><%=rs("aceite")%></strong></font></td>
</tr>
<tr>
<td><strong><font face="Arial, Helvetica, sans-serif">Combustible:</font></strong>
<font color="#FF0000" size="+1" face="Arial, Helvetica, sans-serif"><strong><%=rs("combustible")%></strong></font></td>
</tr>
<tr>
<td><strong><font face="Arial, Helvetica, sans-serif">Otros:
</font></strong><font color="#FF0000" size="+1" face="Arial, Helvetica, sans-serif"><strong><%=rs("otros")%> </strong></font></td>
</tr>
</table>
</div></td>
</tr>
</table>
</div>
<p align="center"><font size="+1" face="Arial, Helvetica, sans-serif"><strong>
<input type="button" name="Button" value="Regresar" onclick="javascript:history.back();">
<br>
<font size="+1" face="Arial, Helvetica, sans-serif"><br>
<u>Referencias :</u> <font color="#FFFFFF" size="-1">HD: Direcci&ograve;n
Hidr&agrave;ulica - HG: Engranaje Hidr&agrave;ulico - TC: Trampa
de combustible - SA : separador de agua - H: Sistemas Hidr&agrave;ulicos-
TH Y T : Transmisi&ograve;n Hidra&ugrave;lica DF:Circuito de Frenos</font></font><br>
</strong></font></p></TD>
</tr>
</table></TD>
<TD ROWSPAN=2> <IMG SRC="caterimagen/caterpillar_05.jpg" WIDTH=39 HEIGHT=427 ALT=""></TD>
</TR>
<TR>
<TD> <IMG SRC="caterimagen/caterpillar_06.jpg" WIDTH=725 HEIGHT=28 ALT=""></TD>
</TR>
</TABLE>
</div>
</BODY>
</HTML>