Error in SQL Server 2005 with passing a variable
In T-SQL code on SQL Server 2005, the variable :t_id is being passed from other pages and works in other statements, but it is not parsing within this statement:
define("TF_T_INFO_INSERET", "
insert into TFT (WG_ID,task_id,tf_id)
SELECT (select WGID from LU_T where TID= :t_id ), :t_id , (select max(TF_ID) from LU_TF); ");
If I replace :t_id with a number, it works fine. I tried declaring a new variable and passing it to the statement, and I get this same error:
An error was encountered while saving: [Microsoft][ODBC SQL Server Driver]COUNT field incorrect or syntax error (SQLExecute[0] at extpdo_odbcodbc_stmt.c:133)
Any idea what is going on?
Software/Hardware used:
Software/Hardware used:
ASKED:
December 12, 2008 4:23 PM
UPDATED:
December 12, 2008 5:45 PM
Answer Wiki:
Last Wiki Answer Submitted:
Be the first to answer this question.
All Answer Wiki Contributors:
Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
