TMSUSERS Archives

The Museum System (TMS) Users

TMSUSERS@SI-LISTSERV.SI.EDU
Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
Re: List Views & 1 to many relationships
From:
Ryan Donahue <[log in to unmask]>
Reply To:
The Museum System (TMS) Users
Date:
Wed, 27 Jul 2011 14:27:48 -0400
Content-Type:
text/plain
Parts/Attachments:
text/plain (32 lines) 
I haven't tried it for a listview, but what you're looking for (for T-SQL anyway) is COALESCE.

http://stackoverflow.com/questions/194852/concatenate-many-rows-into-a-single-text-string


On Jul 27, 2011, at 1:32 PM, Hansen, Stephanie wrote:

> Hello again,
> 
> Anyone have any tips on how to handle a 1-many relationship in a listview without returning multiple lines?
> Thanks!
> Stephanie Hansen
> Milwaukee Art Museum
> 
> To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email:
> 
>     signoff TMSUSERS
> 
>     //  eoj
> 
> 
> You will receive a confirmation that your subscription has been removed.

To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email:

     signoff TMSUSERS

     //  eoj


You will receive a confirmation that your subscription has been removed.

ATOM RSS1 RSS2