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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Using Stored Proc to retrieve data type "text"

Status
Not open for further replies.
oliveto

oliveto

Technical User
Mar 22, 2003
8
US
I have a stored procedure that does not return the data in a field with a data type of "text". There is only one field of type "text" in my Stored Proc. (I did upgrade mdac to the latest (2.8) version to no avail.) I've looked around and found that moving the text type field to the last column in the query can help. It did help for a little while then broke again. I can access this field using a sql statement in my asp code but would prefer to use a stored proc. Also, I have tried adjusting my connection paramaters several times to no success. I could go with the access methods for accessing blobs but don't wish to unless absolutely necessary (seems like too much work).

Thanks in advance for any ideas.
-Stephen
 
Status
Not open for further replies.

Similar threads

penguinspeaks
  • Locked
  • Question
READ TEXT FILE BASED ON VARIABLE 1
Replies
2
Views
385
guitarzan
guitarzan
penguinspeaks
  • Locked
  • Question
Return to current location on page after asp processes.
Replies
2
Views
411
penguinspeaks
penguinspeaks
leifoet
  • Locked
  • Question
How to display an existing date in Input type="date"?
Replies
4
Views
256
leifoet
leifoet
leifoet
  • Locked
  • Question
How to link a condition to a session("UID") ?
Replies
14
Views
477
leifoet
leifoet
leifoet
  • Locked
  • Question
How to send HTML emails with ASP classic?
Replies
0
Views
484
leifoet
leifoet

Part and Inventory Search

Sponsor

Back
Top