> anyone know why i'd be getting this error:
>
> Error Executing Database Query.
> [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC SQL
> Server Driver]Optional feature not implemented
>
> The error occurred in
> D:\usr\dp03dp\www\admintools\changeblog\org\camden\blog\blog.cfc: line
> 408
That code is:
<cfquery datasource="#instance.dsn#" name="days">
select distinct
<cfif instance.blogDBType is "MSSQL">
datepart(dd, posted)
<cfelseif instance.blogDBType is "MYSQL">
extract(day from posted)
<cfelseif instance.blogDBType is "MSACCESS">
datepart('d', posted)
</cfif> as posted_day
from tblblogentries
where
posted >= <cfqueryparam value="#dtMonth#" cfsqltype="CF_SQL_DATE">
and posted <= <cfqueryparam value="#dtEndOfMonth#" cfsqltype="CF_SQL_DATE">
and blog = <cfqueryparam value="#instance.name#"
cfsqltype="CF_SQL_VARCHAR" maxlength="50">
</cfquery>
Line 408 is the end of the query.
What type of database are you using and how have you got the database
driver set up? Looks like you're using ODBC instead of the the native
SQL Server driver which could be causing your problem.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
