now here is the problem...i have some column in my database called as prepreq...and has item as G,O in it.when i retreive this item and display on my page i want hyperlink on G seperately and O seperately instead of havign the hyperlink G,O together
How do i display this on my web page?
I dont want to have two rows in my database giving G seperately in one and O in another.
Please help

Hi,

  You can do with simple IF condition.

dim gURL,oURL
while not rs.EOF
  if rs("prepreq")="G" then
    gURL="<a href='...'>G</a>"
  elseif rs("prepreq")="O" then
    oURL="<a href='...'>O</a>"
  end if

  ...

 rs.movenext
wend

Did that help?

_________________________
- Vijay G
Strive for Perfection