Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2003
    Posts
    32

    Unanswered: how to display data with one line

    i want to ask, how can we put multiple data in one textfield. my problem/situation is like hotmail case.

    let say in hotmail, if i want to put multiple email address into field 'to' then i just clik 'to' then one window appear with phonebook then i just select using chechk box then it will appear at 'to' field with horizontal line

    TO : test@mail.com;dbtest@mail.com;gg@mail.com

    if you have any idea or code to solve this, pls help me

    thanks

  2. #2
    Join Date
    Jan 2003
    Location
    Midwest
    Posts
    138
    concatenate them...to do in code what you did above just do something like this

    Code:
    name1 = "me@hotmail.com"
    name2 = "you@hotmail.com"
    name3 = "us@hotmail.com"
    
    toField = name1 & ";" & name2 & ";" & name3
    it will look like this

    To:me@hotmail.com;you@hotmail.com;us@hotmail.com

  3. #3
    Join Date
    Mar 2003
    Posts
    32
    yeah that rights ,but if 'name' from field table(database) it's that work using this function (concatenate) ? cause the data i pick up from another window then user can select using checkbox. after selected then it will appear at one textfield. what function is suitable to do this ?

    for @ while ?

    thanks Memnoch1207..i owe many knowledge from u ..

  4. #4
    Join Date
    Jan 2003
    Location
    Midwest
    Posts
    138
    This & is the concatenation operator...basically it just combines your variables...so you can do this

    if your working with multiple pages..use session variables
    Code:
    fName = Session("fName") 'on page 1
    mName = Session("mName") 'on page 2
    lName = Session("lName") 'on page 3
    
    Full Name = Session("fName") & " " & Session("mName") & " " & Session("lName")
    so if Session("fName") = "George"
    and Session("mName") = "Walker"
    and Session("lName") = "Bush"

    Full Name will look like this "George Walker Bush"

Posting Permissions

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