Hello everyone,

I was wondering if someone might be able to help me.

I'm doing a lot of work on putting these Access 2000 Queries of our 

database on the web in a HTML table fasion.

Using 'Beginning ASP Databases' I've made a make table subroutine to do 

this.

A lot of our "text" and "memo" fields of our database are rather long and 

make the table look bad so I've edited the maketable subroutine to make a 

textarea for those long field values.

The code works GREAT for "text" type data, but I'm not getting anything 

for "memo" type.

Here is my code and I hope it displays correctly.  This is my first time 

posting on this forum and I hope it doesn't pick up on HTML tags...lets 

pray:

------

Sub MakeTable(SourceIn,dsnIn)

Hi Nic,



You might want to read:

http://support.microsoft.com/support/kb/articles/Q200/1/24.ASP

(Accessing Text or Memo fields returns No Data)



and

http://support.microsoft.com/support/kb/articles/Q175/2/39.ASP

(80020009 Error when retrieving data from SQL)



and if you are using SELECT *

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

(which also links to the above)



Cheers

Ken



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

From: "Nic Linley" <nlinley@q...>

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

Sent: Thursday, August 23, 2001 6:39 PM

Subject: [asp_databases] Access 2000 Field Type "memo" and "text" ..HELP!





: Hello everyone,

: I was wondering if someone might be able to help me.

: I'm doing a lot of work on putting these Access 2000 Queries of our

: database on the web in a HTML table fasion.

: Using 'Beginning ASP Databases' I've made a make table subroutine to do

: this.

: A lot of our "text" and "memo" fields of our database are rather long and

: make the table look bad so I've edited the maketable subroutine to make a

: textarea for those long field values.

: The code works GREAT for "text" type data, but I'm not getting anything

: for "memo" type.

: Here is my code and I hope it displays correctly.  This is my first time

: posting on this forum and I hope it doesn't pick up on HTML tags...lets

: pray:

: ------

: Sub MakeTable(SourceIn,dsnIn)