<% idcliente=request.querystring("idcliente")
%>
<head>
</head>
<body bgcolor="white" text="Black" link=" " vlink="#008080" leftmargin=0 topmargin=0 alink="black" >
<TABLE WIDTH="100%" BORDER="1" CELLSPACING="0" CELLPADDING="5" BORDERCOLOR="#008080" BGCOLOR="#ebf3f3" ALIGN="center">
<%
set oConn=Server.CreateObject("ADODB.Connection")
oconn.open "Driver={SQL Server};server=nombreservidor;UID=sa;PWD=clave;DAT ABASE=nombretabla;"
SQL= "select pedido,nit,aprobado,fechaingreso from pedidos and '"&idcliente&"'= nit order by numero"
set rs=Oconn.execute(SQL)
%>
<table WIDTH="100%" ALIGN="center" border="1" cellspacing="0" cellpadding="2">
<tr valign="top" >
<td align="left"> <b><font face="Arial" size="1" >peidido</font></b> </td>
<td align="left"> <b><font face="Arial" size="1" >nit </font></b> </td>
<td align="left"> <b><font face="Arial" size="1" >fechaingreso </font></b> </td>
</tr>
<% Do while Not rs.EOF %>
<tr>
<td align="lef"> <font face="Arial" size="1"> <A HREF="pedido.asp?numero=<%=rs("pedido")%>"> <%=rs("pedido")%></A> </font></td>
<td align="left"><font face="Arial" size="1" color="black"><% = rs("nit")%> </font></td>
<td align="left"><font face="Arial" size="1" color="black"><% = rs("fehaingreso")%> </font></td>
</tr>
<% rs.MoveNext
Loop %>
</table>
</TABLE>
</body>