Invalid column name error?

[cdietschrun]

Error: saving tester - TST-000-341 - item :: System.Data.SqlClient.SqlException: Invalid column name 'TST'. update tbl_swbom_checklist_testers set passfail='No' where package=992-700-358 and tester=TST-000-341 That is part of the exception thrown by my web app. There is no column named TST, the column is named TESTER, which is why the SQL statement is 'where tester=TST-000-341'. The PACKAGE column is the same syntax and it has no complaints. What am I missing here? Here is my entire SP:

CREATE PROCEDURE dbo.sp_UpdateTesterColumn
(
@PACKAGE nvarchar(255),
@TESTER nvarchar(100),
@COLUMN nvarchar(100),
@VALUE nvarchar(100),
@LASTCHANGEBY nvarchar(100)
)
AS

declare @sql nvarchar(1024)
set @sql=''

set @sql=@sql+'update tbl_swbom_checklist_testers set '+@COLUMN+'='''+@VALUE+''' '
set @sql=@sql+'where tester='+convert(nvarchar(100),@tester)+' and package='+convert(nvarchar(255),@package)

print @sql

exec sp_executesql @sql
GO

Obviously the print is when I uncomment the print statement. What am I missing here?

[Blue_Boy]

Change

cdietschrun wrote:

package=992-700-358 and tester=TST-000-341

with package='992-700-358' and tester='TST-000-341'

---

I Love T-SQL "Don't torture yourself,let the life to do it for you." If my post helps you kindly save my time by voting my post. www.aktualiteti.com

[cdietschrun]

I thought so, but that code is generated by the SP, and I am having trouble with the quotation/apostrophes that properly encase each one. Could you help me and show me how to edit the SP itself?

[cdietschrun]

set @sql=@sql+'update tbl_swbom_checklist_testers set '+@COLUMN+'='''+@VALUE+''' '
set @sql=@sql+'where tester='''+convert(nvarchar(100),@tester)+''' and package='''+convert(nvarchar(255),@package)
set @sql=@sql+''''

Ended up looking like that, if anyone was curious.

[Blue_Boy]

Instead using four single quotes then use CHAR(39) set @sql=@sql+'update tbl_swbom_checklist_testers set '+@COLUMN+'='+CHAR(39)+@VALUE+CHAR(39) set @sql=@sql+' where tester='+CHAR(39)+convert(nvarchar(100),@tester)+CHAR(39)+' and package='+CHAR(39)+convert(nvarchar(255),@package)+CHAR(39) Hope this helepd you.

---

I Love T-SQL "Don't torture yourself,let the life to do it for you." If my post helps you kindly save my time by voting my post. www.aktualiteti.com

modified on Tuesday, August 4, 2009 11:56 AM