I `ve got this f***** prob the last 30 minutes. And my head is total stuck!!!
So please... tell me... What`s wrong???

------------------------------
<%
Dim oRSbn, pecode, code
pecode = Request.Querystring("code")
Set oRSbn=server.createobject("ADODB.recordset")

sqltext = " SELECT * from choices ;"
oRSbn.open sqltext, "DSN=anthem"

oRSbn.MoveFirst

Do while NOT oRSbn.eof

code = oRSbn("code")

if (code=pecode) then
    %>
<tr><td width='100%'><%=oRSbn("choice")%></td></tr>
    <%
    else
        %>
<tr><td width='100%'><a target="_top" href="main.asp?code=<%=code%>"><%= oRSbn("choice")%></a></td></tr>
<%
    end if

    oRSbn.movenext
loop
oRSbn.Close
Set oRSbn=nothing
%>
-----------------------
info: the value from the Response.querystring is coming OK!

I guess the problem is on "if (code=pecode) then"
cause when I tried e.g. "if (code="4") then" it worked fine!!!

:(

Varg_88

Your problems will be solved quicker if you post the error (including line number if possible), you have you run the code I assume?

Anyhow, you say:
;;;I guess the problem is on "if (code=pecode) then"
cause when I tried e.g. "if (code="4") then" it worked fine!!!

What DB field data type is oRSbn("code")? A string I assume since "4" is and you say this works. Response.write code and pecode to determine what values they hold. If on face value they hold equal values, then check their data types. If they are equal in values and in data type then that line shouldn’t have a problem. What error are you getting?




Wind is your friend
Matt