Recently migrated our database from Access to SQL Server and the fields that were memo are now long text in SQL Server. However when I view the ASP, everything displays properly except the long text. Any insights?



Edited by - Mazalo on 28 Jan 2002 15:10:36

Use 'varchar' instead of long text.

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Recently migrated our database from Access to SQL Server and the fields that were memo are now long text in SQL Server. However when I view the ASP, everything displays properly except the long text. Any insights?



Edited by - Mazalo on 28 Jan 2002 15:10:36
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

Viktor Farcic
viktor@udzone.com
TalkZone Manager

It worked after I figured out how to set the max characters to 8000. Thanks!

Edited by - Mazalo on 28 Jan 2002 21:41:13