I'm using PD edit with SQL Server 2000, my edit pages show absolutely NOTHING inside the editor, even though there are over 15.000 characters in there. My ASP display page had the same problem, it displayed nothing but started to display my data after I moved the TEXT column to be the last column in the table.

Has anyone else bumped into this, if so how do you fix it so that the editor will function ?

TIA

with regards,

Dennis van Galen
Webmaster KPN Telecom Holland
Financial & Information Services

Studio MX / CFMX PRO / SQL 2000 / NT4 AND win2kPRO / IIS5

Dear Dennis,
Back in the day, this was a problem w/Access & Memo fields, unless they were at the end of the table - I never had this issue in SQL Server, but I always put Text fields at the end as well, out of habit.

Regards,
Brent

Brent,

I solved this 5 minutes after I posted this, the solution is simple:

in your table design place the TEXT column as last column of the table, and in your SELECT statements you must also select the TEXT column as last column in the select clause.

Also, this is not a SQL Server problem because I had the same setup in my new ColdFusion website which worked great when going above 8000 characters in a TEXT field, it broke when I tried to access this in ASP, so ASP is the problem and not SQL Server.

It is strange though, ASP works ok UNTIL SQL decides to replace content with simply <long text> when you do a "Return all Rows" in the Enterprise manager.

with regards,

Dennis van Galen
Webmaster KPN Telecom Holland
Financial & Information Services

Studio MX / CFMX PRO / SQL 2000 / NT4 AND win2kPRO / IIS5