VB & Database, String Truncation

String Truncation

Author	Message
llam #1 / 5	String Truncation Hello, I have a VBScript / Access2000 ASP application with some memo fields that get passed into queries. I'm finding my data is getting truncated if its more than about 255 bytes, and trying to diagnose where the problrm lies. it could be Access 2000 not allowing more than 255 chars in a query string, even if its pulled from a memo field, or it could be ASP itself, not allowing streams of more than 255 chars? any advice ? thanks.
Sun, 07 Nov 2004 23:44:16 GMT

Val Mazu #2 / 5	String Truncation Hi, To be able to use memo fileds you need to use AppendChunk anf GetChunk methods of field. Those methods work with any BLOB fields. If you use value proprty, then value will be truncated to 255 (in case of Access) characters, because Access has limit on length of string fields - 255 characters. -- Val Mazur Microsoft MVP Quote: > Hello, > I have a vbscript / Access2000 ASP application with some memo > fields that get passed into queries. I'm finding my data is getting > truncated > if its more than about 255 bytes, and trying to diagnose where the problrm > lies. > it could be Access 2000 not allowing more than 255 chars in a query string, > even if its pulled from a memo field, > or it could be ASP itself, not allowing streams of more than 255 chars? > any advice ? > thanks.
Sun, 07 Nov 2004 23:48:18 GMT

llam #3 / 5	String Truncation ah - thanks -I was using .value - does that mean I can use append chunk in ASP ? Quote: > Hi, > To be able to use memo fileds you need to use AppendChunk anf GetChunk > methods of field. Those methods work with any BLOB fields. If you use value > proprty, then value will be truncated to 255 (in case of Access) characters, > because Access has limit on length of string fields - 255 characters. > -- > Val Mazur > Microsoft MVP > > Hello, > > I have a vbscript / Access2000 ASP application with some memo > > fields that get passed into queries. I'm finding my data is getting > > truncated > > if its more than about 255 bytes, and trying to diagnose where the problrm > > lies. > > it could be Access 2000 not allowing more than 255 chars in a query > string, > > even if its pulled from a memo field, > > or it could be ASP itself, not allowing streams of more than 255 chars? > > any advice ? > > thanks.
Mon, 08 Nov 2004 01:51:10 GMT

Val Mazu #4 / 5	String Truncation I think so -- Val Mazur Microsoft MVP Quote: > ah - thanks -I was using .value > - does that mean I can use append chunk in ASP ? > > Hi, > > To be able to use memo fileds you need to use AppendChunk anf GetChunk > > methods of field. Those methods work with any BLOB fields. If you use > value > > proprty, then value will be truncated to 255 (in case of Access) > characters, > > because Access has limit on length of string fields - 255 characters. > > -- > > Val Mazur > > Microsoft MVP > > > Hello, > > > I have a vbscript / Access2000 ASP application with some memo > > > fields that get passed into queries. I'm finding my data is getting > > > truncated > > > if its more than about 255 bytes, and trying to diagnose where the > problrm > > > lies. > > > it could be Access 2000 not allowing more than 255 chars in a query > > string, > > > even if its pulled from a memo field, > > > or it could be ASP itself, not allowing streams of more than 255 chars? > > > any advice ? > > > thanks.
Mon, 08 Nov 2004 02:07:57 GMT

llam #5 / 5	String Truncation thanks. Quote: > I think so > -- > Val Mazur > Microsoft MVP > > ah - thanks -I was using .value > > - does that mean I can use append chunk in ASP ? > > > Hi, > > > To be able to use memo fileds you need to use AppendChunk anf GetChunk > > > methods of field. Those methods work with any BLOB fields. If you use > > value > > > proprty, then value will be truncated to 255 (in case of Access) > > characters, > > > because Access has limit on length of string fields - 255 characters. > > > -- > > > Val Mazur > > > Microsoft MVP > > > > Hello, > > > > I have a vbscript / Access2000 ASP application with some memo > > > > fields that get passed into queries. I'm finding my data is getting > > > > truncated > > > > if its more than about 255 bytes, and trying to diagnose where the > > problrm > > > > lies. > > > > it could be Access 2000 not allowing more than 255 chars in a query > > > string, > > > > even if its pulled from a memo field, > > > > or it could be ASP itself, not allowing streams of more than 255 > chars? > > > > any advice ? > > > > thanks.
Mon, 08 Nov 2004 03:52:39 GMT

Page 1 of 1

[ 5 post ]