<Long Text> - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Author

Topic

cmh
Starting Member

20 Posts

Posted - 2004-09-07 : 15:07:58

I am trying to figure out where the information goes that does not appear in the field under <Long Text>. I show all records in the table and all fields are filled in with the exception of the "Comments" field. This field shows "<long Text>" in the "Comments" field for every record. Where is the actual text stored and how do I get to it?
Thank you.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-09-07 : 15:08:43

You are viewing this data in Enterprise Manager. View the data in Query Analyzer using a SELECT statement.

Tara

cmh
Starting Member

20 Posts

Posted - 2004-09-07 : 15:40:38

I am not real familiar with SQL. How do I write a query to access this information? I open the Query Analyzer and enter a SELECT statement but then it tells me I need a LIKE statement.

I get this error when I try to present all data in the table to the user on the screen. I assumed it had something to to with the <Long Text> feature.

error '80020009'
Exception occurred.

/Previousjobpostings.asp, line 92

i]Originally posted by tduggan[/i]

You are viewing this data in Enterprise Manager. View the data in Query Analyzer using a SELECT statement.

Tara
[/quote]

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2004-09-07 : 16:12:15

show us the query.

it should be:
select col1, col2, ...
from TableName

col1, col2, ... are your Column names

Go with the flow & have fun! Else fight the flow

cmh
Starting Member

20 Posts

Posted - 2004-09-07 : 16:16:19

This is the query:

select Content
from IntranetJobPostings

These are the results (there are 4 test records in the table):

<Long Text>
<Long Text>
<Long Text>
<Long Text>

Originally posted by spirit1

show us the query.

it should be:
select col1, col2, ...
from TableName

col1, col2, ... are your Column names

Go with the flow & have fun! Else fight the flow

[/quote]

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-09-07 : 16:17:19

So you ran this:

select Content
from IntranetJobPostings

from Query Analyzer? Or from Enterprise Manager?

Tara

cmh
Starting Member

20 Posts

Posted - 2004-09-07 : 16:21:58

From Query Analyzer

i]Originally posted by tduggan[/i]

So you ran this:

select Content
from IntranetJobPostings

from Query Analyzer? Or from Enterprise Manager?

Tara
[/quote]

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-09-07 : 16:27:49

What is the data type of this column?

Tara

cmh
Starting Member

20 Posts

Posted - 2004-09-07 : 16:49:27

ntext length is 16.

i]Originally posted by tduggan[/i]

What is the data type of this column?

Tara
[/quote]

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2004-09-07 : 23:21:39

since this is ntext, and i guess the text exceeded the length per row, you'll get more than 1 row returned.

you can view the content in vb if you're not familiar with QA.

open a recordset and traverse the recordset, concatenating the field from previous record to current. This should give you the entire text

rs.cursorposition=aduseclient
rs.open "your query and connection here"
if rs.recordcount>0 then
rs.movefirst
while not rs.eof
sVar=sVar & rs.fields("fieldname")
rs.movenext
wend
endif

hope this helps...

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources