Because you pass the list in through a variable, the query actually
expands to look like this to the server:
(x.cyb_record_num NOT IN ("'32','432','43','23','112'"))
In other words, you're looking for a record where cyb_record_num equals
the whole string, not one value in a list of values.
Thanks,
Eric
"Bradford T Comer" <[EMAIL PROTECTED]>
09/05/2003 01:17 PM
Please respond to sql
To: SQL <[EMAIL PROTECTED]>
cc:
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:>
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics.
http://www.fusionauthority.com/signup.cfm
