Professional Web Applications Themes

concat with nulls - Coldfusion Database Access

I am running a query that sends the results to a pdf form. In the select statement I am concating first, middle, and last names. My select looks like this: SELECT concat(p1title, " ", p1FirstName, " ", p1middlename, " ", p1lastname) AS p1name...(snip). As long as the DB has info in all fields it returns results. If, for instance p1middlename is null, it does not return anything. What would be the best way to fix this problem? TIA....

Sponsored Links
  1. #1

    Default concat with nulls

    I am running a query that sends the results to a pdf form. In the select
    statement I am concating first, middle, and last names.
    My select looks like this: SELECT concat(p1title, " ", p1FirstName, " ",
    p1middlename, " ", p1lastname) AS p1name...(snip). As long as the DB has info
    in all fields it returns results. If, for instance p1middlename is null, it
    does not return anything. What would be the best way to fix this problem? TIA.

    Sponsored Links
    rmorgan Guest

  2. #2

    Default Re: concat with nulls

    I guess the DB is MySql.
    Please check this.
    http://bugs.mysql.com/bug.php?id=480

    Hope this will help you.

    Thanks

    Sankalan
    (www.mindfiresolutions.com)
    Sankalan Guest

  3. #3

    Default Re: concat with nulls

    If we're talking about mysql, then try this:

    SELECT CONCAT_WS(' ', p1title, p1Firstname, p1middlename, p1lastname) AS p1name FROM table
    ianwinter Guest

  4. #4

    Default Re: concat with nulls

    Perfect, thank you
    rmorgan Guest

Similar Threads

  1. Concat two fields in SQL
    By thomascraig in forum Coldfusion Database Access
    Replies: 7
    Last Post: June 9th, 01:54 PM
  2. Which version supports concat???
    By Don Vaillancourt in forum MySQL
    Replies: 5
    Last Post: March 27th, 11:14 PM
  3. Concat problem with SQL
    By Shivaan Keldon in forum Coldfusion Database Access
    Replies: 4
    Last Post: October 24th, 12:14 PM
  4. php string concat
    By anybody in forum PHP Development
    Replies: 2
    Last Post: October 14th, 03:04 PM
  5. HOW CAN I CONCAT TWO LINEAR LISTS
    By Nubber webforumsuser@macromedia.com in forum Macromedia Director Lingo
    Replies: 1
    Last Post: August 12th, 11:49 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139