Recuperar e exibir informação do banco de dados.

[Lucas Pohlmann 0]

Eu preciso resgatar informações do banco e exibir em uma pagina HTML...

Fiz esse código depois de muitas pesquisas mas não funciona alguem sabe me diser porque não funciona?

Grato!

 

<%

Set Conexao = Server.CreateObject("ADODB.Connection")	
Conexao.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\inetpub\wwwroot\asp\servicos\database\curriculo.mdb" 

ComandoSQL = "select * from curriculo where nome = 'Teste'";
Set rsQuery = Conexao.Execute(ComandoSQL)

%>
<center>
<table>
<tr><td>Nome</td><td>Numero</td></tr>
<%
While not rsQuery.EOF
%>
<tr><td><%=rsQuery("nome").value%></td><td><%=rsQuery("numero").value
%></td></tr>
<%
rsQuery.Movenext
Wend
%>
</table>
</center>
<%
rsQuery.Close()
Conexao.Close()
Set Conexao = Nothing
Set rsQuery = nothing
%>

[Gilberto Jr 26]

muda esse codigo

<tr><td>Nome</td><td>Numero</td></tr>
<%
While not rsQuery.EOF
%>
<tr><td><%=rsQuery("nome").value%></td><td><%=rsQuery("numero").value
%></td></tr>
<%
rsQuery.Movenext
Wend
%>

 

para

<tr><td>Nome</td><td>Numero</td></tr>
<%
While rsQuery.EOF = false
%>
<tr><td><%=rsQuery("nome").value%></td><td><%=rsQuery("numero").value
%></td></tr>
<%
rsQuery.Movenext
Wend
%>

[Lucas Pohlmann 0]

Não Funcionou!

Da isso:

 

Server Error in '/' Application.

--------------------------------------------------------------------------------

 

Runtime Error

Description: An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed remotely (for security reasons). It could, however, be viewed by browsers running on the local server machine.

 

Details: To enable the details of this specific error message to be viewable on remote machines, please create a <customErrors> tag within a "web.config" configuration file located in the root directory of the current web application. This <customErrors> tag should then have its "mode" attribute set to "Off".

 

 

<!-- Web.Config Configuration File -->

 

<configuration>

<system.web>

<customErrors mode="Off"/>

</system.web>

</configuration>

 

 

Notes: The current error page you are seeing can be replaced by a custom error page by modifying the "defaultRedirect" attribute of the application's <customErrors> configuration tag to point to a custom error page URL.

 

 

<!-- Web.Config Configuration File -->

 

<configuration>

<system.web>

<customErrors mode="RemoteOnly" defaultRedirect="mycustompage.htm"/>

</system.web>

</configuration>

[Vinicius Ianni 189]

Sem post up.

 

Se ainda não respoderam sua pergunta é porque não sabem ou estão sem tempo para responder.

Seja paciente e espere.

 

Nesta linha:

<tr><td><%=rsQuery("nome").value%></td><td><%=rsQuery("numero").value %></td></tr>

 

Muda para

<tr><td><%=rsQuery("nome")%></td><td><%=rsQuery("numero")%></td></tr>

 

Veja se assim dá certo

 

Ah, e mude isto:

 

While rsQuery.EOF = false

 

Para o que estava antes

 While rsQuery.EOF