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
<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
Edited by - Mazalo on 28 Jan 2002 21:41:13