Re: an SQL statement not working for some reason.

Roy Danon wrote:
> Hi,
> I'm trying to execute the following SQL query on an ACCESS database
> using JET4 drivers.
>
> select distinct topic_id,* from tblThread

Is there a particular reason you want to see the topic_id field twice in
your recordset?

Avoid selstar in production code: http://www.aspfaq.com/show.asp?id=2096

>
>
> for some reason, i'm getting this error :
>
>
> The field is too small to accept the amount of data you attempted to
> add. Try inserting or pasting less data.
>
This error has nothing to do with the sql statement you are showing above.
You may be trapping the error in the wrong place. Let's see some code.

Bob Barrows
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

an SQL statement not working for some reason.

Hi,
I'm trying to execute the following SQL query on an ACCESS database using
JET4 drivers.

select distinct topic_id,* from tblThread


for some reason, i'm getting this error :


The field is too small to accept the amount of data you attempted to add.
Try inserting or pasting less data.

what can be the cause to this?


Roy.