Will Stillwell (7/22/2016)
Lowell (7/22/2016)
Will Stillwell (7/22/2016)
...the email body doesn't get populated AT ALL....I'm betting you are not handling nulls correctly; you have to isnull every column as you build the string, so that you don't get 'somestring' + null + 'somestring' resulting in a NULL html body.
If that was the case why would running the exact same code outside the trigger it works? I'll look at your post. But I just wanted to bring up that manually running it the body builds just fine. Using the exact same code just populating variables from static entries instead of the inserted info.
The trigger isn't based on updates, and the app only inserts one row at a time.
Also, with the select I'm using, it can bring back more than one row from the table to populate the body. That works. I've done manual runs with it running and returning 20+ rows. works perfect. Ran from the trigger it fails to build the body.
Thank you for your time in trying to help me.
add this just before you send the email:
set @body = isnull(@body,N'BODY IS NULL, LOWELL IS RIGHT, I AM USING OUTER JOINS');
MM
select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);