Another Vendor Rant

[poopee]

Correcting vendor mistakes sometimes feels so good, especially when you've got an audience on the Cc list lol. But seriously, it still stresses you because you can't trust the vendor to get it right the first time. I don't know why they got a junior programmer to interact with the client. Are we not paying enough?

-----Original Message-----
From: Lanny
Sent: Friday, July 20, 2007 2:49 PM
To: Me; ...
Cc: ...
Subject: RE: OMA ReferrerCode NULL Problem

Hi,

Sorry, my mistake.

Attached is the new script.

Thanks
Lanny

-----Original Message-----
From: Me
Sent: Friday, July 20, 2007 2:46 PM
To: Lanny; ...
Cc: ...
Subject: RE: OMA ReferrerCode NULL Problem

Are you sure?? Pls check. "= NULL" is not a conditional check. It will always be false.

-----Original Message-----
From: Lanny
Sent: Friday, July 20, 2007 2:40 PM
To: Me; ...
Cc: ...
Subject: RE: OMA ReferrerCode NULL Problem

Hi,

I have tested the sql in our environment and it works.
SQL won't recognize "is"

Regards
Lanny

-----Original Message-----
From: Me
Sent: Friday, July 20, 2007 2:32 PM
To: Lanny; ...
Cc: ...
Subject: RE: OMA ReferrerCode NULL Problem

Your query: select * from t_online_applicant_info WHERE (create_dt >= '13 July 2007') AND (referrer_id = NULL OR referrer_id = '');

Should be "referrer_id IS NULL"