You could do the following (I am assuming you are using SQL server?)
declare @Avariable INT
SELECT @Avariable = ISNULL(YourId, 0) FROM Atable WHERE something =
something
IF @Avariable > 0
BEGIN
do something
END
ELSE
BEGIN
do somethign else
END
just my 2 cents worth.
----- Original Message -----
From: "Russ" <[EMAIL PROTECTED]>
To: "CF-Talk" <[email protected]>
Sent: Friday, February 17, 2006 3:15 PM
Subject: RE: if not exists (SQL) question
> So there's no way to get it to return the id from inside that statement?
> Maybe assign it to a variable in there?
>
>> -----Original Message-----
>> From: Adrian Lynch [mailto:[EMAIL PROTECTED]
>> Sent: Thursday, February 16, 2006 7:46 PM
>> To: CF-Talk
>> Subject: RE: if not exists (SQL) question
>>
>> My guess would be that because the first SELECT is part on the condition,
>> IF
>> NOT EXISTS(SELECT...), it doesn't return a result set. Move the SELECT
>> out
>> of the condition and do some different logic.
>>
>> Adrian
>>
>> -----Original Message-----
>> From: Russ [mailto:[EMAIL PROTECTED]
>> Sent: 17 February 2006 00:37
>> To: CF-Talk
>> Subject: if not exists (SQL) question
>>
>>
>> I have a query similar to the following:
>>
>>
>>
>> declare @emailLinkID int
>>
>> if not exists (
>>
>> select emailLinkID from emailLinks
>>
>> where linkURL='https://www.someurl.com'
>>
>>
>> )
>>
>> begin
>>
>> insert into emailLinks (
>>
>> linkURL
>>
>> ) values (
>>
>> 'https://www.someurl.com,
>>
>> )
>>
>> set @emailLinkID = @@IDENTITY
>>
>> select @emailLinkID as emailLinkID
>>
>> end
>>
>>
>>
>>
>>
>> This works fine when the record doesn't exist. But it doesn't return the
>> id
>> if the record does exist. What am I doing wrong?
>>
>>
>>
>> Russ
>>
>>
>>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232705
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
