LINK NOT WORKING 1

[gsc123]

Hi

Anyone see why my link created is not a proper link, cant see wood for the trees

do until rstemp.eof
for i = 0 to rstemp.fields.count - 1
v=rstemp(i)
if isnull(v) then v = " "
id = rstemp(0)
select case i
case 0
str = "<td><font face='Verdana, Arial, Helvetica, sans-serif' size='1'><a href='pt_viewitem.asp?idproduct="&id&">" + CStr(v) + "</td><td><font face='Verdana, Arial, Helvetica, sans-serif' size='1'>" + CStr(v) + "</a></font></td>"
case else
str = "<td><font face='Verdana, Arial, Helvetica, sans-serif' size='1'>" + CStr(v) + "</td>"
end select

if i = 3 then
Response.Write str
str = "</tr><tr>"
end if
Response.Write str
Next
rstemp.MoveNext
loop

 

[guitarzan]

Maybe

str = "<td><font face='Verdana, Arial, Helvetica, sans-serif' size='1'><a href='pt_viewitem.asp?idproduct="&id&">" + CStr(v) + "[b][COLOR=blue]</a>[/color][/b]</td><td><font face='Verdana, Arial, Helvetica, sans-serif' size='1'>" + CStr(v) + "[s][COLOR=red]</a>[/color][/s]</font></td>"

 

[gsc123]

Nice try but no ... i'm baffled

 

[guitarzan]

Ahh, looks like a missing single quote also

str = "<td><font face='Verdana, Arial, Helvetica, sans-serif' size='1'><a href='pt_viewitem.asp?idproduct="&id&"[COLOR=blue yellow][b]'[/b][/color]>" + CStr(v) + "</a></td><td><font face='Verdana, Arial, Helvetica, sans-serif' size='1'>" + CStr(v) + "</font></td>"

 

[gsc123]

Your the man full points, give this man a card!!!!

 

[gsc123]

Sorry a pint!!!

 

[guitarzan]

A pint sounds great right about now ;-)

 

[alex5935]

try with no quotes