Hi,



i have a problem where i cannot see the full contents of a memo field.  Can

anyone shed any light on this?  I am using access 2000 as the database.





...

'strSQL supplies a query which contains the memo field 'HTML' - I can't see

the fields entire contents!



			SET oRS= server.createobject("ADODB.Recordset")



			oRS.open strsql, oConn	

			oRS.movefirst

	

			strResponse  = oRS("HTML")

			strPageTitle = oRS.fields("title")



			oRS.close

			set oRS = nothing

...





thanks a lot!

Did you do SELECT * in your query?  Ideally individually name all the

fields that you want to SELECT.  Have SQL Server Text, and Access MEMO

fields listed last and in the order that they are in the database.  Memo

fields can be truncated if not selected last.

Hi



If you are doing SELECT * - you have to stop:

http://www.adOpenStatic.com/faq/selectstarisbad.asp



At the bottom of that page there is a link to a MS KB article that also says

you should use GetChunk and AppendChunk for MEMO fields if you want to be

certain of returning all the info. There is a explanation of why as well.



Cheers

Ken



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

From: "Tristian O'brien" 

To: "ASP Databases" <asp_databases@p...>

Sent: Thursday, August 31, 2000 2:43 AM

Subject: [asp_databases] cannot see the full contents of a memo field





> Hi,

>

> i have a problem where i cannot see the full contents of a memo field.

Can

> anyone shed any light on this?  I am using access 2000 as the database.

>

>

> ...

> 'strSQL supplies a query which contains the memo field 'HTML' - I can't

see

> the fields entire contents!

>

Thanks for the info.  I am not using select * as i know its bad.  



I discovered the caveats:  put my memo fields at the end of the select

statement and don't use DISTINCT!







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

From: Ken Schaefer 

Sent: Thursday, August 31, 2000 2:36 AM

To: ASP Databases

Subject: [asp_databases] Re: cannot see the full contents of a memo

field





Hi



If you are doing SELECT * - you have to stop:

http://www.adOpenStatic.com/faq/selectstarisbad.asp



At the bottom of that page there is a link to a MS KB article that also says

you should use GetChunk and AppendChunk for MEMO fields if you want to be

certain of returning all the info. There is a explanation of why as well.



Cheers

Ken



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

From: "Tristian O'brien" 

To: "ASP Databases" <asp_databases@p...>

Sent: Thursday, August 31, 2000 2:43 AM

Subject: [asp_databases] cannot see the full contents of a memo field





> Hi,

>

> i have a problem where i cannot see the full contents of a memo field.

Can

> anyone shed any light on this?  I am using access 2000 as the database.

>

>

> ...

> 'strSQL supplies a query which contains the memo field 'HTML' - I can't

see

> the fields entire contents!

>