Create a ticker bar of information

You could add the url to the database and return it with your query...How you do it depends on how what the link to the call looks like...

something like this...

<%
Dim varcalldetails
varcalldetails = ""

Do while NOT oRSeofd22.EOF

     varCallREF =  Trim(oRSeofd22("SRQHdNum"))
     varType = Trim(oRSeofd22("Type"))
     varUrl = "<a href=" & Trim(orSeofd22("Url")) & ">" & varCallREF  & "</a>"
         
     varcalldetails = " " & varcalldetails & " " & varUrl & " - " & varType  
     oRSeofd22.MoveNext

Loop
%>              
<MARQUEE TITLE="Critical Calls" scrolldelay='95'>
<%=varcalldetails%>
</marquee>


--------
D_M_D

thanks for the advice gents -

But I used this way in the end - I think its easier to control my varibles this way and it is very simple:-


    <MARQUEE TITLE="Critical Calls" ONMOUSEOVER="this.stop();" ONMOUSEOUT="this.start();" scrolldelay='95'>                  
                              
<%                  
      set oRSeofd22=Server.CreateObject("ADODB.recordset")
      sqltext22="Select * from HDSRQHDR Where Status='Open' and CallStatus='Critical' OR CallStatus='Exceeded Limit'"
      oRSeofd22.open sqltext22, "dsn=*;uid=*;pwd=*"
      
      if NOT oRSeofd22.EOF then
      %>
      <img height='20' src=>
      <%
      end if
                              
      'Start a loop here and check the end time of each Service Request
      do while NOT oRSeofd22.EOF

      varSRQHdNum= oRSeofd22("SRQHdNum")
      varSRQType= oRSeofd22("SRQType")
      varCallStatus= oRSeofd22("CallStatus")
      
      if varCallStatus="Exceeded Limit" then
      varFontColour="Red"
      elseif varCallStatus="Critical" then
      varFontColour="Orange"      
      end if
            
      set oRSeofd223=Server.CreateObject("ADODB.recordset")
      sqltext223="Select * from HDLUTYPE Where SRQType='"&varSRQType&"'"
      oRSeofd223.open sqltext223, "dsn=*;uid=*;pwd=*"
            
      varTypeDescrip = oRSeofd223("Description")
      
                  
      'varcalldetails=" " & varcalldetails & " " & varSRQHdNum & " - " & varTypeDescrip & ".....&nbsp;&nbsp;&nbsp;&nbsp;"
      %>      
<font face='arial' size='2' color='black'><b>&nbsp;&nbsp;<a hreftarget='main'><font color="#000000"><%=varSRQHdNum%> - <%=varTypeDescrip%> - <font color='<%=varFontColour%>'><%=varCallStatus%></font></a>&nbsp;&nbsp;&nbsp;&nbsp;
      <%
      oRSeofd22.Movenext
      loop
if NOT oRSeofd22.EOF then
      %>
      <img height='20' src=>
      <%
      else
      %>
      There are no Critical Calls
      <%
      end if
      %>
</marquee>

DMD - would you mind me if I get this closed and the points refunded - as I used my own way in the end?

Glad to see you answered it yourself.  No objections here.

--------
D_M_D

Cheers buddy!