Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL text field problem

Status
Not open for further replies.
donniea21

donniea21

MIS
Feb 16, 2001
75
US
Im trying to read a field of type text from an sql table into my recordset and then disply it. If i change it to type text (which is not big enough to hold the data) it works fine aside from cutting off at 255. If i try it with the text data type..i get nothing. Thanks
 
Sort by date Sort by votes
sorry made a error in my post...it works fine as type varchar not type text..
 
Upvote 0 Downvote
Ok...now i got it kind of working..the new problem is..if i return multiple rows, the text shows up for all but the first record...
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

penguinspeaks
  • Locked
  • Question
READ TEXT FILE BASED ON VARIABLE 1
Replies
2
Views
390
guitarzan
guitarzan
penguinspeaks
  • Locked
  • Question
Parse a database field that is comma delimited and input the results into another table
Replies
0
Views
351
penguinspeaks
penguinspeaks
leifoet
  • Locked
  • Question
Problem: sql-Select with request.form
2
Replies
22
Views
466
leifoet
leifoet
leifoet
  • Locked
  • Question
How to log in without a popup problem?
Replies
3
Views
166
ggriffit
ggriffit
leifoet
  • Locked
  • Question
Convert Word text with images to html (problems)
Replies
1
Views
173
leifoet
leifoet

Part and Inventory Search

Sponsor

Back
Top