mx 6.1 selecting smalldatetime

[drdave2]

- just upgraded to 6.1 and now getting this error when trying to select
smalldatetime values, but only WITH ntext values..

can select either field individually but together they give me the error.

Macromedia]Numeric value out of range

SELECT request,date_created
FROM dbo.requests

any ideas??

[BKBK]

Looks like a driver bug. However, the cause can also be invalid values in a
date column. Check, using

<cfquery name="q" etc>
select date_created
from requests
</cfquery>
<cfoutput query="q">
<cfif NOT isDate(date_created)>
Invalid date in DB: #date_created# <br>
</cfif>
</cfoutput>

[PaulH *ACE*]

drdave2 wrote:

> - just upgraded to 6.1 and now getting this error when trying to select
> smalldatetime values, but only WITH ntext values..

its usually a good idea to put the Ntext or text column last in the select list:

SELECT date_created,request
FROM dbo.requests

[GaryGlitter]

thx for the replies, in the administrator there was a checbox for "return timestamp as string", unchecked that and Boo YeaH!

back in business..

Dave