Prob in response.write of a Memo cell in an Access base

[Thanos]

Hi folks!

i've made a simple mdb Access base with "text", "number" and "memo" cells.
These cells displayed with a response.write command in a <TABLE> on an .ASP file.
i have no prob to display the "text" and the "number" cells, but the "memo" ones do not display in the <TABLE>.
if i change the "memo" cells in the Access database to "text" cells, it's working. If i switch back to "memo", it display a blanck screen in the <TABLE>. No error, no text. Just a blanck cell, as if nothing was in the database.
I can't use "text" cells, because i have much more than 255 types in this cell.

i have no prob with IIS. I think it's a bug of Active HTML... (i have the last free version)
anybody can help ?
if not, do you have any suggestion for another free ASP program ?
(i hope i'm clear enought, i'm not english speaking)

[Thanos]

ok, i solved it. ;o)

[aprelium]

Thanos,

Put .value at the end of the asp code to get data out of the recordset.
_________________
Support Team
Aprelium - http://www.aprelium.com

[Thanos]

The problem was here :
rsTitre.Open "SELECT * FROM film WHERE auto=" & id_titre , Conn,3

if i do not write the 3 at the end of the command, the "memo" cell type in Access wasn't read correctly.