set to use the MS SQL driver.
i'm get this error at line 408 and 648
408:
<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>
648:
<cfif structKeyExists(arguments.params,"byAlias")>
and tblblogentries.alias = <cfqueryparam
value="#arguments.params.byAlias#" cfsqltype="CF_SQL_VARCHAR"
maxlength="100">
</cfif>
----- Original Message -----
From: Dave Watts <[EMAIL PROTECTED]>
Date: Thu, 30 Sep 2004 17:15:50 -0400
Subject: RE: a little blog cfc help
To: CF-Talk <[EMAIL PROTECTED]>
> 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
I'd recommend that you use the JDBC driver for MS SQL Server, instead of
ODBC.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: 202-797-5496
fax: 202-797-5444________________________________
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
