Hey, all--

I'm using Dreamweaver to make a SELECT query from an Access 2002 database.

This is an online newspost database, so it needs to display memo fields that are larger than 255 characters.

The problem is that when I define my recordset as a SELECT query, it truncates all the memo fields down to 255 characters, cutting the rest off.

I can't reference the database table directly, since I'm running a COUNT function in my query.

I know that Access won't let you have more than 255 characters in a query result, but I'm running the query in Dreamweaver, so I thought this might let me around the problem.

Any ideas?

Here's the SQL statement to select my data:

SELECT LogTable.Title, LogTable.DateTime, LogTable.Author, LogTable.Entry, Count(CommentTable.Entry) AS CommentsCount
FROM LogTable
LEFT JOIN CommentTable ON LogTable.Title = CommentTable.ParentTitle
GROUP BY LogTable.Title, LogTable.DateTime, LogTable.Author, LogTable.Entry
ORDER BY LogTable.DateTime DESC;

Hi

I remember reading somewhere that to get over this make the memo column reference in the Select part of the statement the last one, then the field won't be truncated.

select myInt, myVarchar, myMemo from etc. etc.

Digga

Sharing Knowledge Saves Valuable Time!!!