SELECT indo pra 2 campos
/applications/core/interface/imageproxy/imageproxy.php?img=http://img43.imageshack.us/img43/3200/tabelaug.jpg&key=5388a3684a35e8cdf43563ae88818083142f074900ec618a69271cfb801b4c2a" alt="Imagem Postada" />
Como podem ver o a data 22/9 do COBRE ta puxando os dados do MÊS do ALUMÍNIO, segue o código:
<body>
<style type="text/css">
.text{
font-family:Verdana;
font-size:10px;
color:#58595b;
text-align:center;.border{
border-bottom:2px solid #d2d3d5;
border-right:1px solid #d2d3d5;<%
'Função que determina a quantidade de números'
function numDuplo(texto)
varTxtLen = Len(texto)
if(varTxtLen <= 1)Then
texto = "0"&texto
end if
numDuplo = texto
end function
'Seleciona o mês e o ano'
varSelDia = day(date) & "/" & month(date)
varSelMes = request("mes")
varSelAno = request("ano")
'Checa as datas obtidas'
if(isNull(varSelDia) OR varSelDia = "")Then
varSelDia = day(now)
end if
if(isNull(varSelMes) OR varSelMes = "")Then
varSelMes = month(now)
end if
if(isNull(varSelAno) OR varSelAno = "")Then
varSelAno = year(now)
end if
'Resgata os valores inputados nas cotações'
set rsquery = conn.execute("SELECT * FROM tabCotAl WHERE data LIKE '"&varSelDia&"'")
while not rsquery.eof
varCash = rsquery("usCash")
varDolar = rsquery("dolar")
varMdCash = rsquery("mdCash")
varTipo = rsquery("tipo")
rsquery.movenext
wend
'Checa os dados obtidos'
if(isNull(varCash) OR varCash = "")Then
varCash = "-"
end if
if(isNull(varDolar) OR varDolar = "")Then
varDolar = "-"
end if
if(isNull(varMdCash) OR varMdCash = "")Then
varMdCash = "-"
end if
%>
<a href="cotResumo.asp" target="_parent"><img src="images/indices_mercado.gif" width="162" height="17" border="0" alt="" style="margin:10 0 10 10;"></a><br>
<table border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="242" align="left" valign="top">
<table width="237" border="0" cellpadding="0" cellspacing="0" style="border:3px solid #d2d3d5;">
<tr>
<td height="120" valign="top">
<table width="231" bgcolor="#ffffff" border="0" cellpadding="0" cellspacing="0" style="border:3px solid #ffffff;">
<tr>
<td height="21" align="center" colspan="4" bgcolor="#d2d3d5">
<b style="font-family:Verdana; font-size:12px; color:#58595b;">LME Alumínio - (<%=varSelAno%>)</b>
</td>
</tr>
<tr>
<td class="text border">
</td>
<td class="text border"></td>
<td class="text border"></td>
<td class="text border"></td>
</tr>
<tr>
<td class="text border"></td>
<td class="text border"></td>
<td class="text border"></td>
<td class="text border"></td>
</tr>'Checa os dados obtidos'
if(isNull(varCash) OR varCash = "")Then
varCash = "-"
end if
if(isNull(varDolar) OR varDolar = "")Then
varDolar = "-"
end if
if(isNull(varMdCash) OR varMdCash = "")Then
varMdCash = "-"
end if
%>
<tr>
<td class="text border">mês
</td>
<td class="text border"><%=varCash%>
</td>
<td class="text border"><%=varDolar%>
</td>
<td class="text border"><%=varMdCash%>
</td>
</tr>
<tr>
<td height="5" colspan="4">
</td>
</tr><%
'Função que determina a quantidade de números'
function numDuplo(texto)
varTxtLen = Len(texto)
if(varTxtLen <= 1)Then
texto = "0"&texto
end if
numDuplo = texto
end function
'Seleciona o mês e o ano'
varSelDia = day(date) & "/" & month(date)
varSelMes = request("mes")
varSelAno = request("ano")
'Checa as datas obtidas'
if(isNull(varSelDia) OR varSelDia = "")Then
varSelDia = day(now)
end if
if(isNull(varSelMes) OR varSelMes = "")Then
varSelMes = month(now)
end if
if(isNull(varSelAno) OR varSelAno = "")Then
varSelAno = year(now)
end if
'Resgata os valores inputados nas cotações'
set rsquery = conn.execute("SELECT * FROM tabCotCu WHERE data LIKE '"&varSelDia&"'")
while not rsquery.eof
varCash = rsquery("usCash")
varDolar = rsquery("dolar")
varMdCash = rsquery("mdCash")
varTipo = rsquery("tipo")
rsquery.movenext
wend
'Checa os dados obtidos'
if(isNull(varCash) OR varCash = "")Then
varCash = "-"
end if
if(isNull(varDolar) OR varDolar = "")Then
varDolar = "-"
end if
if(isNull(varMdCash) OR varMdCash = "")Then
varMdCash = "-"
end if
%>
<tr>
<td height="21" align="center" colspan="4" bgcolor="#d2d3d5">
<b style="font-family:Verdana; font-size:12px; color:#58595b;">LME Cobre - (<%=varSelAno%>)</b>
</td>
</tr>
<tr>
<td class="text border">
</td>
<td class="text border">Cash(US$)
</td>
<td class="text border">Dólar
</td>
<td class="text border">Cash(R$)
</td>
</tr>
<tr>
<td class="text border"><%=varSelDia%>
</td>
<td class="text border"><%=varCash%>
</td>
<td class="text border"><%=varDolar%>
</td>
<td class="text border"><%=varMdCash%>
</td>
</tr><%
'Resgata os valores inputados nas cotações'
set rsquery = conn.execute("SELECT * FROM tabCotCu WHERE (MONTH(data) LIKE '"&varSelMes&"') AND (tipo LIKE 'mes')")
while not rsquery.eof
varCash = rsquery("usCash")
varDolar = rsquery("dolar")
varMdCash = rsquery("mdCash")
varTipo = rsquery("tipo")
rsquery.movenext
wend
'Checa os dados obtidos'
if(isNull(varCash) OR varCash = "")Then
varCash = "-"
end if
if(isNull(varDolar) OR varDolar = "")Then
varDolar = "-"
end if
if(isNull(varMdCash) OR varMdCash = "")Then
varMdCash = "-"
end if
%>
<tr>
<td class="text border">mês
</td>
<td class="text border"><%=varCash%>
</td>
<td class="text border"><%=varDolar%>
</td>
<td class="text border"><%=varMdCash%>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</body>Discussão (2)
Carregando comentários...