|
| |
|
|
Abacus
Posts: 3
Joined: 3/10/2004
From: Quesnel, BC Canada
Status: offline
 |
ASP and MS SQL7 text fields - 3/10/2004 16:32:32
I am writing an web application for a grade twelve class so they may post their creative stories and have them peer reviewed and rated. Most stories are greater than the 8000 character limit of the varchar datatype so I need to use a text field. I am unable to find any code examples in my searches (even at MSDN) but have found I need to use GetChunk and AppendChunk functions. These are not working for me and I get this error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e21'
I am connecting to the DB with OLEDB (are get and append chunk part of this connection scheme?). Does anybody have any experience with SQL text fields (or access memo fields)? I would rather learn how to do this than break the text up over several varchar fields.
Thanks in advance for your help
|
|
|
|
BeTheBall
Posts: 6381
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
RE: ASP and MS SQL7 text fields - 3/10/2004 19:08:56
Access memo fields require no special coding for inserting records. They are inserted the same way as other text fields. For example, INSERT INTO MyTable SET MyMemoField = '"&MyFormField&"'
Unfortunately, I have zero experience with SQL databases, but maybe the concept is the same?
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
|
|
Abacus
Posts: 3
Joined: 3/10/2004
From: Quesnel, BC Canada
Status: offline
|
RE: ASP and MS SQL7 text fields - 3/10/2004 19:23:52
Thanks betheball,
Inserting large amounts of data into a text field (memo) seems to work fine in MS SQL although documentation says it shouldn't. In Access do you need to do anything special to extract the information from a very large memo field?
| |
|
|
|
Spooky
Posts: 26606
Joined: 11/11/1998
From: Middle Earth
Status: offline
|
RE: ASP and MS SQL7 text fields - 3/10/2004 21:55:19
text
Variable-length non-Unicode data in the code page of the server and with a maximum length of 231-1 (2,147,483,647) characters. When the server code page uses double-byte characters, the storage is still 2,147,483,647 bytes. Depending on the character string, the storage size may be less than 2,147,483,647 bytes.
_____________________________
If you arent part of the solution, then there is good money to be made prolonging the problem
§þ k¥
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
