I think it's confused about what to do with that list. You can't
compare text values in an IN() clause like you do with = clauses. You
have to compile an SQL string, and then execute it. Something like
this:
Declare @SQL varchar(8000)
Set @SQL = 'select blah blah from blah where x.cyb_record_num NOT IN ('
+ @spExludeListB + ')'
execute (@SQL)
That should do it.
-----Original Message-----
From: Bradford T Comer [mailto:[EMAIL PROTECTED]
Sent: Friday, September 05, 2003 12:18
To: SQL
Subject: RE: Concatenation assistance...
I finally figured that out, thanks.
Here is a second question, I have a SP that I pass into it a list e.g.
'32','432','43','23','112' then I use that parameter for the WHERE
clause,
using IN e.g.
(CAST(x.cyb_record_num AS varchar(25)) NOT IN (@spExcludeListB))
However it still returns the records with ID's in the list. If i hard
code
it, works as it should:
(x.cyb_record_num NOT IN ('32','432','43','23','112'))
WTF???
Anybody have any pointers? I have been banging my head for an hour.
Brad
-----Original Message-----
From: Raster, Tim [mailto:[EMAIL PROTECTED]
Sent: Friday, September 05, 2003 9:31 AM
To: SQL
Subject: RE: Concatenation assistance...
Did you initialize your @NewRecordIDList = '' first? If not, then it's
null, and null + varchar = null.
-----Original Message-----
From: Bradford T Comer [mailto:[EMAIL PROTECTED]
Sent: Friday, September 05, 2003 06:10
To: SQL
Subject: RE: Concatenation assistance...
Correction...it DOES display the @SID for the PRINT statement, however
after
the END I have this:
PRINT 'TEST'
PRINT 'HELLO' + LTRIM(@NewRecordIDList)
This displays the following:
TEST
That is it, why doesnt the @NewRecordIDList get displayed?
Brad
-----Original Message-----
From: Bradford T Comer [mailto:[EMAIL PROTECTED]
Sent: Friday, September 05, 2003 6:07 AM
To: SQL
Subject: Concatenation assistance...
Why doesn't this output anything? I know that the @SID has a AT least 1
value???
...
WHILE (@@FETCH_STATUS = 0)
BEGIN
PRINT @SID
-- appendIDTo @NewRecordIDList
SET @NewRecordIDList = @NewRecordIDList + ',' +
CAST(@SID AS VARCHAR(25))
END
...
Thanks
Brad
[EMAIL PROTECTED]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:6
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:6
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=<:emailid:>.<:userid:>.<:listid:>
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
http://www.cfhosting.com
