[Resolvido] Erro de Consulta

[Mário Monteiro 179]

Qual o campo unidade monetária?

[Marcelo Pescador 0]

Qual o campo unidade monetária?

 

 

São os campos: "vl_a_vista" e "vl_a_prazo" !

[Marcelo Pescador 0]

Agora apareceu uma mensagem na página anterior:

 

select * from hospedagem where codigo='14'

 

Microsoft VBScript runtime error '800a01a8'

 

Object required: ''

 

/josephine_thales/controle/alterar_hospede.asp, line 52

Agora apareceu uma mensagem na página anterior:

 

select * from hospedagem where codigo='14'

 

Microsoft VBScript runtime error '800a01a8'

 

Object required: ''

 

/josephine_thales/controle/alterar_hospede.asp, line 52

O Código desta página é o seguinte:

 

<%
dim ID, strsql2, rs2
codigo1=request.querystring("codigo1")
strsql2="select * from hospedagem where codigo='" &codigo1&"'" 

response.write(strsql2)
responde.end

set rs2=Conn.execute(strsql2)
codigo1=rs2("codigo")
%>
        </div>
        <form method="post" action="alterar_hospede_a.asp">
<br>
<table width="605" border="0" align="center" cellpadding="0" cellspacing="0">
            <tr bgcolor="#FF9999"> 
              <td colspan="3" bgcolor="#A6C4E1" class="style8"> Dados do Hospede</td>
            </tr>
            <tr>
              <td colspan="3" class="style1"><div align="center"><span class="style7">------------------------------------------------------------------------------------------------------------------------</span></div></td>
            </tr>
            <tr> 
              <td width="22%" class="style8"><div align="right">Numero:</div></td>
              <td colspan="2" class="style3"> <input name="codigo" type="text" class="fct1" id="codigo" value="<%=rs2("codigo")%>" size="7" maxlength="9"></td>
            </tr>
            <tr>
              <td colspan="3" class="style1"><div align="center"><span class="style7">------------------------------------------------------------------------------------------------------------------------</span></div></td>
            </tr>
            <tr> 
              <td width="22%" class="style8"><div align="right">Nome:</div></td>
              <td colspan="2"> <input name="hospede" type="text" class="fct1" id="hospede" value="<%=rs2("hospede")%>" size="50" maxlength="100"></td>
            </tr>
            <tr>
              <td width="22%" class="style8"><div align="right">E-mail:</div></td> 
              <td colspan="2" valign="top"> <input name="email" type="text" class="fct1" id="email" value="<%=rs2("email")%>" size="50" maxlength="255"></td>
            </tr>
            <tr>
              <td class="style8"><div align="right">Telefone:</div></td>
              <td colspan="2" valign="top"> <input name="ddd" type="text" class="fct1" id="ddd" value="<%=rs2("ddd")%>" size="2" maxlength="3"> 
                <span class="style5">-</span>                <input name="telefone" type="text" class="fct1" id="telefone" value="<%=rs2("telefone")%>" size="7" maxlength="9"></td>
            </tr>
            <tr>
              <td colspan="3" class="style1"><div align="center"><span class="style7">------------------------------------------------------------------------------------------------------------------------</span></div></td>
            </tr>
            <tr>
              <td class="style8"><div align="right">Tipo de Hosp:</div></td>
              <td colspan="2"> <input name="tipo" type="text" class="fct1" id="tipo" value="<%=rs2("tipo")%>" size="50" maxlength="100"></td>
            </tr>
            <tr>
              <td class="style8"><div align="right">Valor:</div></td>
              <td colspan="2" valign="top"> <input name="vl_a_vista" type="text" class="fct1" id="vl_a_vista" value="<%=rs2("vl_a_vista")%>" size="7" maxlength="9"> 
                <span class="style5">à vista</span></td>
            </tr>
            <tr>
              <td class="style8"><div align="right">Valor:</div></td>
              <td colspan="2" valign="top"> <input name="vl_a_prazo" type="text" class="fct1" id="vl_a_prazo" value="<%=rs2("vl_a_prazo")%>" size="7" maxlength="9">
                <span class="style5">02 vezes</span></td>
            </tr>
            <tr>
              <td class="style8"><div align="right">Quartos:</div></td>
              <td colspan="2" valign="top"> <input name="adt" type="text" class="fct1" id="adt" value="<%=rs2("adt")%>" size="1" maxlength="2"> 
                <span class="style5">Adultos -</span>                <input name="chd" type="text" class="fct1" id="chd" value="<%=rs2("chd")%>" size="1" maxlength="2"> 
                <span class="style5">Crianças</span></td>
            </tr>
            <tr bgcolor="#FF9999" class="style1">
              <td colspan="3" bgcolor="#FFFFFF" class="style8"><div align="center"><span class="style7">------------------------------------------------------------------------------------------------------------------------</span></div></td>
            </tr>
            <tr>
              <td class="style8"><div align="right">Dados do Vôo:</div></td>
              <td colspan="2" valign="top"> <input name="numero_voo" type="text" class="fct1" id="numero_voo" value="<%=rs2("numero_voo")%>" size="7" maxlength="9">
              <span class="style5">- Hora: 
              <input name="hora_voo" type="text" class="fct1" id="hora_voo" value="<%=rs2("hora_voo")%>" size="3" maxlength="5">
              - Cia. Aérea:
              <input name="cia_aerea" type="text" class="fct1" id="cia_aerea" value="<%=rs2("cia_aerea")%>" size="7" maxlength="9">
              </span></td>
            </tr>
            <tr>
              <td class="style8"><div align="right">Saída do Vôo:</div></td>
              <td colspan="2" valign="top"> <span class="style5"><input name="hora_voo_saida" type="text" class="fct1" id="hora_voo_saida" value="<%=rs2("hora_voo_saida")%>" size="3" maxlength="5">
                </span></td>
            </tr>
            <tr bgcolor="#FF9999" class="style1">
              <td colspan="3" bgcolor="#FFFFFF" class="style8"><div align="center"><span class="style7">------------------------------------------------------------------------------------------------------------------------</span></div></td>
            </tr>
            <tr>
              <td class="style8"><div align="right">Observações:</div></td>
              <td colspan="2" valign="top"> <span class="style5">
                <textarea name="obs" cols="50" class="fct1" id="obs"><%=rs2("obs")%></textarea>
              <input type="hidden" name="codigo1" value="<%=codigo1%>">
              </span></td>
            </tr>
            <tr bgcolor="#FF9999" class="style1">
              <td colspan="3" bgcolor="#FFFFFF" class="style8"><div align="center"><span class="style7">------------------------------------------------------------------------------------------------------------------------</span></div></td>
            </tr>
            <tr> 
              <td valign="top"> </td>
              <td width="10%" valign="top"> <div align="left">
                  <input name="submit" type="submit" class="fct2" value="Alterar">
              </div></td>
              <td valign="top"><input name="button" type="button" class="fct2" onClick="javascript:history.go(-1)" value="Voltar"></td>
            </tr>
          </table>
          <div align="center"></div>
        </form>

[Marcelo Pescador 0]

Código resolvido, alterei o campo moed para texto dentro do db..

Obrigado a todos.

[Mário Monteiro 179]

bom que resolveu