Professional Web Applications Themes

concatenating results in a new var - Coldfusion - Getting Started

hi. i'm trying to set a new var , 'name', with two results returned froma query; a user_firstname and user_lastname. here's the code: <cfset name=qry_login.user_firstname qry_login.user_lastname> just wondering the right way to concatenate these two results returned from my query. tx. fumeng....

  1. #1

    Default concatenating results in a new var

    hi.

    i'm trying to set a new var , 'name', with two results returned froma query; a
    user_firstname and user_lastname. here's the code:

    <cfset name=qry_login.user_firstname qry_login.user_lastname>

    just wondering the right way to concatenate these two results returned from my
    query.

    tx.

    fumeng.

    fu-meng Guest

  2. #2

    Default Re: concatenating results in a new var

    Hi:

    I think you might want to do that like this:

    <cfset name=FName+LName>

    Red
    FusionRed Guest

  3. #3

    Default Re: concatenating results in a new var

    <cfset name=qry_login.user_firstname & " " & qry_login.user_lastname>
    Stressed_Simon Guest

  4. #4

    Default Re: concatenating results in a new var

    thank you both for your help. simon, i used your method and it worked perfectly.

    thanks much.

    fumeng.
    fu-meng Guest

Similar Threads

  1. Concatenating strings
    By JMSB in forum Coldfusion - Getting Started
    Replies: 1
    Last Post: October 25th, 08:22 PM
  2. Concatenating
    By TK in forum Microsoft Access
    Replies: 1
    Last Post: July 28th, 02:51 PM
  3. problem concatenating
    By Ray at in forum ASP
    Replies: 2
    Last Post: July 9th, 09:25 PM
  4. Concatenating A Double
    By Ron in forum ASP.NET General
    Replies: 2
    Last Post: July 2nd, 10:16 PM
  5. Concatenating Hash's
    By Simon Strandgaard in forum Ruby
    Replies: 2
    Last Post: July 1st, 11:18 PM

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