Get ready for BLACK FRIDAY shopping starting in

Forums

This topic is locked

SQL Server 2000 and Long Text not displaying...

Posted 28 Jan 2002 15:10:01
1
has voted
28 Jan 2002 15:10:01 Arash Attarzadeh posted:
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

Replies

Replied 28 Jan 2002 17:24:05
28 Jan 2002 17:24:05 Viktor Farcic replied:
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

TalkZone Manager
Replied 28 Jan 2002 18:51:17
28 Jan 2002 18:51:17 Arash Attarzadeh replied:
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

Reply to this topic