try cf_sql_integer or try dropping the cfqueryparam tags and testing
it that way just to isolate the issue. You do want the cfqueryparam
tags, but if it works when you drop them, then you know it has
something to do with the chosen datatype and cf_sql_ values for the
column.
You're right, it's odd behavior. Especially without a view being
involved.
> Nope,
> Just your average-joe-query.
> <code>
> SELECT *
> FROM table1 ep, table2 su, table3 sr, table4 af
> WHERE ep.CandidateID = <cfqueryparam
> cfsqltype="cf_sql_bigint"
> value="#CandidateID#">
> <cfif FormID>AND ep.FormID = <cfqueryparam
> cfsqltype="cf_sql_smallint" value="#FormID#"></cfif>
> <cfif thisBlahID>AND ep.thisBlahID = <cfqueryparam
> cfsqltype="cf_sql_integer" value="#thisBlahID#"></cfif>
> AND su.thisBlahID = ep.thisBlahID
> AND af.FormID = ep.FormID
> AND af.thatBlahID = sr.thatBlahID
> </code>
> And it only happens to this one table.
> CREATE TABLE [dbo].[AssessmentForms] (
> [FormID] [smallint] IDENTITY (1, 1) NOT NULL ,
> [FormTitle] [varchar] (512) COLLATE
> SQL_Latin1_General_CP1_CI_AS NOT NULL ,
> [FormMessage] [varchar] (1024) COLLATE
> SQL_Latin1_General_CP1_CI_AS NULL ,
> [QueryPage] [varchar] (100) COLLATE
> SQL_Latin1_General_CP1_CI_AS NULL ,
> [FormPage] [varchar] (100) COLLATE
> SQL_Latin1_General_CP1_CI_AS NULL ,
> [thisBlahID] [tinyint] NOT NULL ,
> [FormMetaData] [varchar] (256) COLLATE
> SQL_Latin1_General_CP1_CI_AS NULL
> )
> George
s. isaac dealey 954.927.5117
new epoch : isn't it time for a change?
add features without fixtures with
the onTap open source framework
http://www.sys-con.com/story/?storyid=44477&DE=1
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
