Post reply

Send_db_mail html issue

  • May 21, 2010 at 8:52 am

    #1170890

    You need to be sure that you don't return a NULL value... Try this

    SELECT td = coalesce(Name, 'No Name Returned'),'',td = coalesce(Address, 'No Address Returned'), '',td = '<a href="' + Link+ '">' +Link+ '</a>'

    from Student where payment_type='Credit' and Payment_Status=1

    The text I added

    'No Name Returned'

    'No Address Returned'

    Can both be changed to anything you want to display including just empty data ie: ''

    The coalesce function returns the first NON null value. SO if for example Name is NULL then the value I set in parenthesis will be returned.

    <hr noshade size=1 width=250 color=#BBC8E5> Regards,Jeffery Williams http://www.linkedin.com/in/jwilliamsoh

Viewing post 1 (of 2 total)

You must be logged in to reply to this topic. Login to reply