ran the code included with the zip file to setup the DB.
no doing anythign special and i did post a test entry and it posted
just fine. this query just shows up whenever you hit the page (can't
link to it here since it on a private lan).
ERJ
----- Original Message -----
From: Sean Corfield <[EMAIL PROTECTED]>
Date: Thu, 30 Sep 2004 12:41:26 -0700
Subject: Re: SOT: a little blog cfc help
To: CF-Talk <[EMAIL PROTECTED]>
On Thu, 30 Sep 2004 14:13:02 -0400, jonese <[EMAIL PROTECTED]> wrote:
> 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]
