how to pass a database column value to a string

[sanika1507]

dim url,ojRS, SQL_Input
set ojRS = Server.CreateObject("ADODB.Command")
Set ojRS.ActiveConnection = C
SQL_Input ="CP.dbo.usp_cs_Links"
ojRS.CommandType = adCmdStoredProc
set ojRS = C.Execute(SQL_Input,,adCmdText)
 
 
url  = ojRS(LastKeyValue)
 
 Response.Write("<tr>")
    Response.Write("<td Class=Field> ID:</td>")
 
        Response.Write("<td><A Class=TableLink HREF = 'http://"" url ""/cs/login.asp?SysKey="& SecEncode(iId) &" &srcserver=CP' >  " &SecEncode(iId) &"  </a> </td>")                  
         Response.Write("</tr>")
         objRS.close
         Set ojRS = Nothing
 

The problem with this is that it gives me an error with the hyper link
'http://"" url ""/cs/login.asp?SysKey="& SecEncode(iId) &" &srcserver=CP'

the url is actually the value of the from the database..the stored proc .
the output is the LastKeyValue from the stored proc .

there is an error
Can anyone please check the syntax.

thanks in advance

[sanika1507]

url = ojRS(LastUsedKeyValue)

Response.Write("<td><A Class=TabLink HREF = 'http://"" url ""/csipts/login.asp?Key="& SecEncode(iId) &" &scserver=CP' > " &SecEncode(iId) &" </a> </td>")


HREF = 'http://"" url ""/csipts/login.asp?Key="& SecEncode(iId) &" &scserver=CP'

how to use the url here .can anyone help plzzzzzzzzzz

Thanks in advance

[sonu5588]

Madam u can take help me on Yahoo,
Mailme on <private message>
i will send u some files which helps u


Thanks In Advance
Nice laga

[jhardman]

url  = ojRS(LastUsedKeyValue) 
%>
<td><A Class="TabLink" HREF="http://<%=url%>/csipts/login.asp?Key=<%=SecEncode(iId)%>&scserver=CP">   <%=SecEncode(iId)%></a> </td>
<%
 

[jhardman]

dim url,ojRS, SQL_Input
set ojRS = Server.CreateObject("ADODB.Command")
Set ojRS.ActiveConnection = C
SQL_Input ="CP.dbo.usp_cs_Links"
ojRS.CommandType = adCmdStoredProc
set ojRS = C.Execute(SQL_Input,,adCmdText)
 
 
url  = ojRS(LastKeyValue) %>
<tr>
   <td Class="Field"> ID:</td>
   <td><A Class="TableLink" HREF="http://<% =url %>/cs/login.asp?SysKey=<% =SecEncode(iId) %>&srcserver=CP"><% =SecEncode(iId) %></a> </td>
    </tr>
   <%
         objRS.close
         Set ojRS = Nothing
 

The problem is that whenever you need to print large amounts of quote marks it is difficult to keep them straight. Of course it is up to you when to use response.write and when to leave the code delimiters, but I suggest that you leave the code delimiters entirely for this case since this block is so long. Does this make sense?

Jared