[thelist] Procrastinating Variables

Rob Smith rob.smith at THERMON.com
Thu Dec 12 09:59:01 CST 2002


Greetings oh non-maleficent ones,

... that maybe counter intuitive since we know enough to do some damage...
anyway. I have a problem that I've never seen before with SQL Server 2k.

I've got a Column varChar(2056) that contains a bunch of text/links; the
character count of this data is only 416. I'm calling it via ASP and
displaying it normally too. However, it doesn't display the entire contents
of the cell.

These are the contents of the cell:
<a href="../pdf/electric/Terminator.pdf"  target="_top">Terminator
Connection System</a><br>&#149;&nbsp;<a href="../pdf/electric/Electric
Heating Install.pdf"  target="_top">Installation
Procedures</a><br>&#149;&nbsp;<a href="../pdf/electric/Electric Heat Tracing
Guide.pdf" target="_top">Electric Heat Tracing Guide</a><br>&#149;&nbsp;<a
href="../pdf/electric/electric safety precautions.pdf"
target="_top">Electrical Safety Precautions</a>
----416 Chars

This is what is displayed:
&#149;&nbsp;<a href="../pdf/electric/Terminator.pdf"
target="_top">Terminator Connection System</a><br>&#149;&nbsp;<a
href="../pdf/electric/Electric Heating Install.pdf"
target="_top">Installation Procedures</a><br>&#149;&nbsp;<a
href="../pdf/electric/Electric Heat<br>
----258 Chars

This is the ASP i'm using to call the cell:
 <% if NOT isNULL(recordset1.Fields.Item("ProdPDFURL2").value) then %>
 &#149;&nbsp;<%=(Recordset1.Fields.Item("ProdPDFURL2").Value)%><br>

As you can see, the cell did not completely print out. What am I missing?

Thanks,

Rob.Smith



More information about the thelist mailing list