este es el codigo
Código PHP:
sql ="SELECT nro_orden_compra, producto, cantidad, fecha_req_desde, peso_placa, job_number, inv_no, qty_to_ship, unit_price, shipped_dt, search_name, descripcion, vtaus, ctomt, dpc FROM VDespachos_Con_DPC_web ORDER BY search_name, nro_orden_compra, job_number "
Set Rs = oConn.Execute(SQL)
miTabla = rs.GetRows
Liberamos los objetos ya!!
rs.Close
set rs = nothing
oConn.Close
set oConn = nothing
nro_orden_compra = 0
producto = 1
cantidad = 2
fecha_req_desde = 3
peso_placa = 4
job_number = 5
inv_no = 6
qty_to_ship = 7
unit_price = 8
shipped_dt = 9
search_name = 10
descripcion = 11
vtaus = 12
ctous = 13
ton = 14
pvtaus = 15
ctomt = 16
dpc = 17
%>
<table width="760" border="0" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC">
<tr bgcolor="#FFCC33">
<td> </td>
</tr>
<%For I = 0 To UBound(miTabla,1)%>
<tr bgcolor="#FFFFFF">
<td> <%=mitabla(search_name,I)%> </td>
</tr>
<%Next%>
</table>