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
On Fri, 13 Aug 2004 09:27:56 -0400, S. Isaac Dealey <[EMAIL PROTECTED]> wrote:
> You don't happen to be using a view that references that table? ...
> Your view might need to be rebuilt.
>
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
