Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > SQL Server > SQL Server ASP
Password Reminder
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
SQL Server ASP Discussions about ASP programming with Microsoft's SQL Server. For more ASP forums, see the ASP forum category.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server ASP section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old September 8th, 2003, 07:33 PM
Registered User
Join Date: Sep 2003
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Access long text fields

Hello all,

I'm looking for some info on the ADO Stream object. I'm trying to access a MySql database in ASP.

I can create the connection object, generate a recordset etc without problems and return the text in the various fields with response.write etc. My problem comes with dealing with the last field which is a large text field (about 40k of text in some records) I understand that I need to use a Stream object and read/writetext etc but my docs only detail using this with a file object. Could anyone give me some idea on how to set this up with a recordset or provide me a URL? I cannot find anything on w3schools to help, and I'd buy to required book if I knew that it would work, however I don't - yet!

Thanks in advance.

Sorry, forgot to include. This is IIS running on Win2k SP3 using ASP v3.0 and ADO 2.5

Reply With Quote
  #2 (permalink)  
Old September 15th, 2003, 01:14 PM
Friend of Wrox
Join Date: Jun 2003
Location: Arlington, TX, USA.
Posts: 119
Thanks: 0
Thanked 1 Time in 1 Post

Are you timing out when you get to this last record? If that is the case, you need to add a command such as COMMANDTIMEOUT parameter to be equal to a certain number of seconds in order to allow you to complete the process before a timeout occurs.

Reply With Quote
  #3 (permalink)  
Old October 30th, 2003, 08:47 AM
Registered User
Join Date: Oct 2003
Location: wuhan, hubei, China.
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts

I need to know what you exactly will deal with the largr text field so I may suggest the way out.

Reply With Quote

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
long text field SKhna SQL Language 1 June 6th, 2008 12:43 PM
Long Long int to bin walid C# 0 January 23rd, 2007 12:47 PM
Long text irfan4 ASP.NET 1.0 and 1.1 Basics 1 July 27th, 2004 09:30 AM
Modifying long text in a long field sajsal Classic ASP Databases 1 February 20th, 2004 12:36 PM
How to use long text in data base? tiolele Classic ASP Databases 3 November 26th, 2003 09:15 PM

All times are GMT -4. The time now is 07:41 AM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.