This is a multi-part message in MIME format.



------=_NextPart_000_02F2_01C16404.D32441A0

Content-Type: text/plain;

	charset="iso-8859-1"

Content-Transfer-Encoding: quoted-printable



Hello all;



I emailed the list with this one a while ago and got some great 

suggestions for getting down to the root of the problem but I have a bit 

more info this time and would totally appreciate any feedback.



I am having a problem with certain records in my DB being truncated 

during an edit function. This problem is intermittent, and seems to only 

occur to records above 50000 characters. I'm running an access DB - the 

field in question is a memo type, and it's a Win2K server.



I have tried endlessly to re-create the truncated conditions but to no 

avail. It seems that it's only when my clients use the content editor 

does this occur.



I was wondering if it's possible that heavy use of the database while 

updating the data could cause this problem.



Truly- I'm at my wits end



TIA



spencer 

This is a multi-part message in MIME format.



------=_NextPart_000_000D_01C165DE.2C708040

Content-Type: text/plain;

	charset="iso-8859-1"

Content-Transfer-Encoding: quoted-printable



I'm going to reply to my own message because since I sent this I have 

figured out what is going on. It's not a DB problem at all. It's a 

Mac/PC problem.



The textarea in IE on a MAC only allows 32k  of data (32000 characters), 

and so when my clients were editing a record,  it was updating the 

record with the truncated data.



ANybody know a way around this? I know netscape will work but I didn't 

really design the site with Netscape for a MAC - plus netscape 6 on a 

MAC is a world of problems from what I've heard.



Any thoughts or suggestions are welcome.



spence 

  ----- Original Message -----

  From: Spencer Saunders

  To: Access ASP

  Sent: November 3, 2001 1:14 AM

  Subject: [access_asp] Truncated records





  Hello all;



  I emailed the list with this one a while ago and got some great 

suggestions for getting down to the root of the problem but I have a bit 

more info this time and would totally appreciate any feedback.



  I am having a problem with certain records in my DB being truncated 

during an edit function. This problem is intermittent, and seems to only 

occur to records above 50000 characters. I'm running an access DB - the 

field in question is a memo type, and it's a Win2K server.



  I have tried endlessly to re-create the truncated conditions but to no 

avail. It seems that it's only when my clients use the content editor 

does this occur.



  I was wondering if it's possible that heavy use of the database while 

updating the data could cause this problem.



  Truly- I'm at my wits end



  TIA



  spencer 



  




$subst('Email.Unsub')

Is it possible to detect how many characters are in the record, and if it's

close to 32,000 then create two text areas, and split the content? Not

exactly elegant, I know, but...



Alternatively, upon submit, detect how many characters there are using

javascript, and then populate hidden form fields with values instead...



Cheers

Ken



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

From: "Spencer Saunders" <ssaunders@i...>

Subject: [access_asp] Re: Truncated records





I'm going to reply to my own message because since I sent this I have

figured out what is going on. It's not a DB problem at all. It's a Mac/PC

problem.



The textarea in IE on a MAC only allows 32k  of data (32000 characters), and

so when my clients were editing a record,  it was updating the record with

the truncated data.



ANybody know a way around this? I know netscape will work but I didn't

really design the site with Netscape for a MAC - plus netscape 6 on a MAC is

a world of problems from what I've heard.



Any thoughts or suggestions are welcome.



spence

  ----- Original Message -----

  From: Spencer Saunders

  To: Access ASP

  Sent: November 3, 2001 1:14 AM

  Subject: [access_asp] Truncated records





  Hello all;



  I emailed the list with this one a while ago and got some great

suggestions for getting down to the root of the problem but I have a bit

more info this time and would totally appreciate any feedback.



  I am having a problem with certain records in my DB being truncated during

an edit function. This problem is intermittent, and seems to only occur to

records above 50000 characters. I'm running an access DB - the field in

question is a memo type, and it's a Win2K server.



  I have tried endlessly to re-create the truncated conditions but to no

avail. It seems that it's only when my clients use the content editor does

this occur.



  I was wondering if it's possible that heavy use of the database while

updating the data could cause this problem.



  Truly- I'm at my wits end



  TIA



  spencer

Hey Ken



Thanks for the suggestion- a friend suggested something very similar- but as

it turns out IE 5 on a MAC won't even let you ENTER anything in excess of

32000 characters. It pops up an error apparently telling the user that they

have exceeded the allowed amount. So I can't even read in the characters

through JavaScript cause it can't even get entered through a browser.



I have just told my clients that they have to use netscape to use their

content editor

*sigh*

I'm not a big fan of netscape- but what's a guy to do when Microsoft can't

(won't, doesn't want to) fix a very bizarre bug.



spence

----- Original Message -----

From: Ken Schaefer <ken@a...>

To: Access ASP <access_asp@p...>

Sent: November 5, 2001 8:51 PM

Subject: [access_asp] Re: Truncated records





> Is it possible to detect how many characters are in the record, and if

it's

> close to 32,000 then create two text areas, and split the content? Not

> exactly elegant, I know, but...

>

> Alternatively, upon submit, detect how many characters there are using

> javascript, and then populate hidden form fields with values instead...

>

> Cheers

> Ken

>

> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

> From: "Spencer Saunders" <ssaunders@i...>

> Subject: [access_asp] Re: Truncated records

>

>

> I'm going to reply to my own message because since I sent this I have

> figured out what is going on. It's not a DB problem at all. It's a Mac/PC

> problem.

>

> The textarea in IE on a MAC only allows 32k  of data (32000 characters),

and

> so when my clients were editing a record,  it was updating the record with

> the truncated data.

>

> ANybody know a way around this? I know netscape will work but I didn't

> really design the site with Netscape for a MAC - plus netscape 6 on a MAC

is

> a world of problems from what I've heard.

>

> Any thoughts or suggestions are welcome.

>

> spence

>   ----- Original Message -----

>   From: Spencer Saunders

>   To: Access ASP

>   Sent: November 3, 2001 1:14 AM

>   Subject: [access_asp] Truncated records

>

>

>   Hello all;

>

>   I emailed the list with this one a while ago and got some great

> suggestions for getting down to the root of the problem but I have a bit

> more info this time and would totally appreciate any feedback.

>

>   I am having a problem with certain records in my DB being truncated

during

> an edit function. This problem is intermittent, and seems to only occur to

> records above 50000 characters. I'm running an access DB - the field in

> question is a memo type, and it's a Win2K server.

>

>   I have tried endlessly to re-create the truncated conditions but to no

> avail. It seems that it's only when my clients use the content editor does

> this occur.

>

>   I was wondering if it's possible that heavy use of the database while

> updating the data could cause this problem.

>

>   Truly- I'm at my wits end

>

>   TIA

>

>   spencer

>

>




$subst('Email.Unsub')

>

>

>




>

>

>

>

I'm not a DHTML expert, but could you dynamically "unhide" additional text

areas when the content got to a certain length (eg in 1,000 or 10,000

character increments?)



Cheers

Ken



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

From: "Spencer Saunders" <ssaunders@i...>

Subject: [access_asp] Re: Truncated records





: Hey Ken

:

: Thanks for the suggestion- a friend suggested something very similar- but

as

: it turns out IE 5 on a MAC won't even let you ENTER anything in excess of

: 32000 characters. It pops up an error apparently telling the user that

they

: have exceeded the allowed amount. So I can't even read in the characters

: through JavaScript cause it can't even get entered through a browser.

:

: I have just told my clients that they have to use netscape to use their

: content editor

: *sigh*

: I'm not a big fan of netscape- but what's a guy to do when Microsoft can't

: (won't, doesn't want to) fix a very bizarre bug.

:

: spence



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~