Morning or Evening (Depending on your prospective) -



    I have been trying for the last couple days to put and retrieve data to

and from a database column designated as "Long". Each time I try to put data

into the column it gets chopped off at 255 characters, and when I try and

retrieve that same information, I am simply presented with nothing. I am

sure that I am defining the variable wrong, and that's why I chop off my

input at 255 characters, and I get nothing back. My question is... How do I

define the variable ?



    Wrox says it should be called a "Long" variable, and so does MS but the

only example I find from MS shows something like this:



    "Dim Comments as Long"



    Which on a windows 2000 system may work, ( I haven't tried), but I don't

have a 2000 server to work with in this instance, and NT 4 chokes on that

variable definition. Any help in defining this variable would be great, and

if there is some slightly different way to call, populate, and display the

information in this variable that would be very helpful also.



    Thanks in advance for the help



Russ



--- How do I set a laser printer to stun? ---

I don't know if this applies for your case, but we had a problem once with

Access chopping off a memo field to 255 chars. When we removed the GROUP BY

statement, everything worked fine.



regards

David Cameron

nOw.b2b

dcameron@i...



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

From: Russ Harding [mailto:RHarding@s...]

Sent: Monday, 24 September 2001 9:20 PM

To: ASP Databases

Subject: [asp_databases] Data fron a Long table





Morning or Evening (Depending on your prospective) -



    I have been trying for the last couple days to put and retrieve data to

and from a database column designated as "Long". Each time I try to put data

into the column it gets chopped off at 255 characters, and when I try and

retrieve that same information, I am simply presented with nothing. I am

sure that I am defining the variable wrong, and that's why I chop off my

input at 255 characters, and I get nothing back. My question is... How do I

define the variable ?



    Wrox says it should be called a "Long" variable, and so does MS but the

only example I find from MS shows something like this:



    "Dim Comments as Long"



    Which on a windows 2000 system may work, ( I haven't tried), but I don't

have a 2000 server to work with in this instance, and NT 4 chokes on that

variable definition. Any help in defining this variable would be great, and

if there is some slightly different way to call, populate, and display the

information in this variable that would be very helpful also.



    Thanks in advance for the help



Russ