Re: [sqlite] Getting an Array or list in a select statement...

2007-10-11 Thread jose isaias cabrera
Sent: Thursday, October 11, 2007 2:28 PM Subject: RE: [sqlite] Getting an Array or list in a select statement... We use a custom aggregate function called DisplayList to do exactly what you're talking about. C# code follows. SELECT U.UserName, DisplayList(R.RoleName) FROM Us

RE: [sqlite] Getting an Array or list in a select statement...

2007-10-11 Thread Samuel R. Neff
s@sqlite.org Subject: [sqlite] Getting an Array or list in a select statement... Greetings. So, I know that I can do a single select and get a list of the different items found on a column, but what I would like to do is to get this same list on another select statement. Let me explain; I ha

[sqlite] Getting an Array or list in a select statement...

2007-10-11 Thread jose isaias cabrera
Greetings. So, I know that I can do a single select and get a list of the different items found on a column, but what I would like to do is to get this same list on another select statement. Let me explain; I have this select statement, "select ProjID, cust, proj, PClass,