concatenate Access memo fields?

[LJB]

I have an ASP that displays two MS Access memo fields in separate table
cells just fine. However when I concatenate them with SQL as in "select fld1
& fld2 as temp...." to display them in one cell only part of the first field
is displayed in the table. What is causing this?

thanks
LJB

[Bob Barrows [MVP]]

LJB wrote:

I have an ASP that displays two MS Access memo fields in separate
table cells just fine. However when I concatenate them with SQL as in
"select fld1 & fld2 as temp...." to display them in one cell only
part of the first field is displayed in the table. What is causing
this?

Concatenating in the query requires the query engine to coerce the
operands to Text, which causes the truncation. You will notice that this
occurs if you create and run a query that does this concatenation in
Access Query builder.

Do the "concatenation" when writing the data to response (use two
separate response.writes, one for each memo field)
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[LJB]

"Bob Barrows [MVP]" <re******@NOyahoo.SPAMcomwrote in message
news:u7**************@TK2MSFTNGP06.phx.gbl...

LJB wrote:

>I have an ASP that displays two MS Access memo fields in separate
table cells just fine. However when I concatenate them with SQL as in
"select fld1 & fld2 as temp...." to display them in one cell only
part of the first field is displayed in the table. What is causing
this?

Concatenating in the query requires the query engine to coerce the
operands to Text, which causes the truncation. You will notice that this
occurs if you create and run a query that does this concatenation in
Access Query builder.

Do the "concatenation" when writing the data to response (use two
separate response.writes, one for each memo field)
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

Problem solved.
Thank you.
LJB