Error Diagnostic InformationODBC Error Code = 22005 (Error in assignment) [Microsoft][ODBC SQL Server Driver][SQL Server]Conversion failed when converting the varchar value '3]' to data type int. SQL = "SELECT * FROM Documents Where Documents.DocAuthor <> ? and Documents.CategoryID = ? AND New = 1 Order by PublDate DESC,DOCID DESC" Query Parameter Value(s) - Parameter #1 = Joharah Baker for MIFTAH Parameter #2 = 3] Data Source = "MIFTAHSQL" The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (42:4) to (42:120). Date/Time: 03/28/24 19:48:21 |