From: Jorge Bastos
Date: June 28 2008 3:59pm
Subject: RE: Offtopic help
List-Archive: http://lists.mysql.com/win32/18883
Message-Id: <00f401c8d937$e29392d0$a7bab870$@jorge@decimal.pt>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Wait wait!!
I don't want to concatenate column, but the value from a column from =
many
rows.



> -----Original Message-----
> From: Leif Johnston [mailto:Leif@stripped]
> Sent: s=E1bado, 28 de Junho de 2008 16:44
> To: 'Jorge Bastos'; win32@stripped
> Subject: RE: Offtopic help
>=20
> Hey Jorge - SQL uses a + as a concatenation function so
>=20
>=20
> Select field3 + ';' field4 from tbl where field1=3Dart1 and =
field2=3Darg2;
>=20
> You will have to work through the details - just watch your comma
> placement
> since it is easy to screw up and test in the UI first, not code so you
> can
> see results.
>=20
> Good luck
>=20
> Leif
>=20
> Leif Johnston
> Managing Partner
> Technology Catalyst, LLC
> www.TechnologyCatalyst.com
>=20
>=20
>=20
> -----Original Message-----
> From: Jorge Bastos [mailto:mysql.jorge@stripped]
> Sent: Saturday, June 28, 2008 8:58 AM
> To: win32@stripped
> Subject: Offtopic help
>=20
> Hi people,
>=20
> I wounder if anyone can give me a hand.
>=20
> I want to create a view or function/procedure that returns a string,
> and
> inside that function I have to pass two arguments, and do a SQL
> statement
> like this:
>=20
>=20
>=20
> Select * from tbl where field1=3Dart1 and field2=3Darg2;
>=20
> Result=3Dconcat(field3 ,';')         <=3D for each record found I need =
to
> concatenate the result, and return it on the end.
>=20
>=20
>=20
> How can this be possible?
>=20
>=20
>=20
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe:
> http://lists.mysql.com/win32?unsub=3Dmysql.jorge@stripped