html within response.write

 hi

what i am trying to do is display a link when my audio field in the db is not empty

the entry in my audio field corresponds to the ID field.

to save space in my DB i want only to enter '1650' in to the DB audio field and then for my asp page to display the link:

<a href="audio\1650.mp3">listen</a> on my page, i currently have the following code

<%
  
  If isNull(rsResults("audio")) THEN
  response.write ""
  ELSE
   response.write "<a href=""audio\" & rsResults("audio") & ".mp3""> listen </a>"
   END IF
   %>

but all i get in my url is audio\.mp3

why wont it read the reResults bit? any ideas?

thanks

mark

hi

all working now, thanks a lot, the code i pasted above actually works today?!

i tried the response.write like above then took it off and it worked?!!

many thanks

mark