unable to display information

[immotal]

hi i hav problem display the information i have saved in the database..can anione help mi ? thx a lot! The codes are below..by the way gt can intro ani website that teaches using sql to appy on asp codes.....Reali thx a lot!


<% Option Explicit %>
<%
dim conn
dim rs
dim varDatabaseName
dim sql
varDatabaseName=&quot;db2.mdb&quot;

set conn = server.createobject(&quot;ADODB.connection&quot
conn.open &quot;DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=&quot; & Server.MapPath(varDatabaseName)
set rs = server.createobject(&quot;ADODB.recordset&quot
rs.CursorType = 2
rs.LockType = 3

dim s
s = &quot;Select * from friens&quot;
rs.open s,conn


Do While Not rs.EOF
response.write rs(&quot;Firstname&quot &
response.write rs(&quot;Lastname&quot &
response.write rs(&quot;Gender&quot &
response.write rs(&quot;Age&quot &
response.write rs(&quot;Email&quot &
rs.movenext
loop

rs.close
set rs=nothing
conn.close
set conn=nothing

%>

 

[ehsant]

Hi...
first od all, you don't have to have & after your response.writes
and if the problem is not that, please post your problem...

----
TNX.
E.T.

 

[immotal]

ohh kk.. i manage to solve it thx a lot.. but how do i display information for one record..