<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
<%
Dim cnn,sSQL,oRS
response.Write" entrando al sistema "
if request.Form("submit") <> "" then
'if Request.Form() <> "" then
%>
<!-- #include file="include/asp/connect.inc"-->
<!-- #include file="include/asp/getDescrip.inc"-->
<!-- #include file="include/asp/ejecutaQuery.inc"-->
<%
f_inicio = request( "f_inicio")
f_final = request( "f_final" )
matricula = request("matricula")
response.Write"matricula"
sql= "select matricula " & _
",decode (ident_pc, 4112, '1.1',4144,'1.3' " & _
",8208,'2.1'" & _
",8224,'2.2'" & _
",12304,'3.1'" & _
",12320,'3.2'" & _
",12336,'3.3'" & _
",12352,'3.4'" & _
",16400,'4.1'" & _
",16416,'4.2'" & _
",16432,'4.3'" & _
",20496,'5.1'" & _
",20512,'5.2'" & _
",20528,'5.3'" & _
",20544,'5.4') PdC" & _
", to_char(fechatransito,'dd-mm-yyyy') Fecha" & _
", to_char(fechatransito,'hh24:mi') Hora" & _
", importe" & _
", decode (tarifamop,1,'Fuera Punta'" & _
",2,'Punta') Tarifa " & _
", decode (categoria,1,'Auto/Camioneta'" & _
",2,'Camion s/Acoplado'" & _
",3,'Camion c/Acoplado') Categoria " & _
"from TRANSACCIONES_OLAP_MV" & _
"where (fechatransito between to_date('f_inicio','dd-mm-yyyy hh24:mi:ss')" & _
"and to_date('f_final','dd-mm-yyyy hh24:mi:ss'))" & _
"and trim(matricula) in ('matricula') " & _
"order by matricula"
do while getRegistro( conn, rec, sql )%>
<tr bgcolor="#FFFFFF">
<td class=textoEstandar> </td>
<td align=right class=textoEstandar><%=FormatNumber(rec("porcentaj e_diezminutos"),2)%></td>
<td align=right class=textoEstandar><%=FormatNumber(rec("porcentaj e_concesion"),2)%></td>
<td align=right class=textoEstandar><%=FormatNumber(rec("porcentaj e_dia"),2)%></td>
<td align=right class=textoEstandar><%=FormatNumber(rec("porcentaj e_mes"),2)%></td>
<td align=right class=textoEstandar><%=FormatNumber(rec("porcentaj e_ano"),2)%></td>
</tr><%
loop
else
%>
<html>
<!-- #include file="include/asp/head.asp"-->
<body>
<!-- #include file="include/asp/menu.asp"-->
<table border=0 cellspacing=0 cellpadding=0 style="width:760px">
<tr>
<td align=center><br>
<form action ="index.asp" name="frmingreso" method=post onSubmit="return validacampos()">
<div style="width:60%;height:26">
<table border="1" width="100%">
<tr>
<td ><font class=textoEstandarSizeBold>Fecha de Inicio</font></td>
<td width="211">
<INPUT type ="text" name="f_inicio" size="15" class=inputEstandar>
</td>
</tr>
<tr>
<td><b><font class=textoEstandarSizeBold>Fecha Final</font></td>
<td width="211">
<INPUT type ="text" name="f_final" size="15" class=inputEstandar>
</td>
</tr>
<tr>
<td><b><font class=textoEstandarSizeBold>Matrícula</font></td>
<td width="211">
<INPUT type ="text" name="matricula" size="15" class=inputEstandar>
</td>
</tr>
</table>
<p><font class=textoEstandarSizeRed>Ingreso los datos requeridos</font>
<table border="1" width="100%">
<tr>
<td align="center"><input type=submit class=botonEstandar value="Consultar" name="enviar" ></td>
</tr>
</table>
<p>
</div>
</form>
</td>
</tr>
</table>
<%
end if
%>
Sres no me funcina! probe los tres metodos que me recomendaron. y no pasa nada!. Uff.
Les agradesco la ayuda!!
