August 28, 2002 at 9:16 am
Hello there,
I have a really strange problem and i hope someone here can enlighten me on how to solve it. Without further adue here it is:
i've been trying to insert bunch of text into
an nText type field.
Its all fine and dandy until i try to insert more than about a paragraph worth of text in which case nothing goes into the field.
When i look at the table containing that field in enterprise manager all of the other columns are populated but that one (it just says:<Long Text>) I've tried inserting stuff from an ASP page as well as directly with enterprise manager.Nothing works.
Furthermore if i open the table and click on the field in question i get a warning telling me i cannot edit that field.
Please help!
August 28, 2002 at 10:00 am
From BOL : (Subject : Results Pane - just hit F1 in the results pane when browsing data)
Columns containing long varchar-type data display up to 900 characters of data. If the data is longer, the cell displays <Long Text>.
So you should check in any other way if the data is present, but my guess is that it is.
You can use Query Analyzer (returning only the first 255 bytes by default) or an ASP page or Access.
August 28, 2002 at 10:15 am
Thanks for your input.
The data is there like you said. It never crossed my mind to check it thourgh a asp page. That's what you call a brain fart i suppose.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply