This topic is locked

Edit page doesn't show all the existing values

9/28/2005 1:43:57 AM
ASPRunnerPro General questions
T
tiedanjj author

I just upgraded to ASPRunner 3.2. I insert a new record with the values in all the 14 fields. Then go back to list page and see all the values are there (also in sql server database). I click on edit link to go to edit page, it only shows the values in the first eight fields, the last six fields are all empty. I struggled quite awhile to figure out what's wrong but failed. Help please.

T
tiedanjj author 9/28/2005

I found out th problem. Not until I modified the field type from 'ntext' to 'nvarchar' in the sql server database, all the values are displayed. My question is whether this is an expected behavior or I can get over it? Look forward to your reply!

S
stevemcm 9/28/2005

I've just come across the exact same thing. I'm attempting to display 2 SQL Server ntext fields consecutively on a page.
I've formatted both as TextArea. It seems if I only show 1 TextAre field then all the text fields from that point onward are displayed.
If I attempt to put both on the same page, then all the fields below them are blank.
If I put the 2 TextArea fields on the top of the form, all fields below are blank. If I put them at the bottom then all fields above are displayed correctly.
So, there does seem to be some issue with displaying ntext fields.
I even tried to show the ntext fields as just plain Text (and not TextArea) and still had the problem...

T
tiedanjj author 9/28/2005

Thanks for sharing your experiences. Correct me if my following conclusion is wrong: either keep ntext (image too) at the bottom of the edit page, or change the data type from ntext to nvarchar which has a max of 4000 characters. Other than that, any other downside for using nvarchar instead??? Thanks!

S
stevemcm 9/29/2005

Tiedanjj;
Yes, that seems to have worked for me - placing the ntext field at the bottom. However, it also seemd to work if I had only 1 ntext field on the form - regardless of position...
I'm stuck with having to keep the ntext formatted field as-is. I'm allowing users to crate an html newsletter using a form, and I need the field to be longer than 4,000 characters.
Hopefully we'll get some guidance from support on this instead of just speculating on the cause and backing into a solution...

Sergey Kornilov admin 10/3/2005

Tiedanjj,
I can not reproduce this error. please send to support@xlinesoft.com all generated pages where you get this error(empty blanks) along with table creation script for investigation.