[Error] Type mismatch: 'Response.Write'

[gracenalec]

<% Dim RS Set Conn = Server.CreateObject("ADODB.Connection") Set RS = Server.CreateObject("ADODB.Recordset") Conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("forum.mdb") & ";" Conn.Open SQL = "SELECT * FROM profile" RS.Open SQL, Conn %> Youth Aloud!Forum #content { margin-right:1%; margin-left:1%; margin-top:5%; padding-bottom:10px; background:#fff; border:2px solid #ffaf38; text-align:left; min-width:600px; }

Search the forum:

Name: ">

Age: ">

Gender: ">

Website: ">

MSN: ">

Yahoo: ">

Occupation:

[IronBrad]

Are you checking to make sure your record set has values? Are you displaying a single record because I do not see a loop.

[gracenalec]

i'm onie trying to display a single value..act i'm not sure on how to set the value of RS....i'm soooo new to this :(

[prodigymunky]

I believe you can do without the response.write( ) in that line ... so just use <% RS("Name") %> ~ Munky

[Guffa]

I believe that you are thinking of the short form of Response.Write: <%=RS("Name")%> which is exactly the same as: <%Response.Write(RS("Name"))%> --- b { font-weight: normal; }