Re: Once again ... row to column conversion

2001-02-01 Thread Markus Fischer
On Wed, Jan 31, 2001 at 08:50:44PM +0100, leo.putz wrote : > Sorry for having to post the same problem a second time - > but by now I'm really at a loss. > Is there really no one out there to give me a hint? > > I need the output of a query result (all query information is in one > row) in one c

Re: Once again ... row to column conversion

2001-01-31 Thread Rus
If i get it right, you should use CONCAT - Original Message - From: leo.putz <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, January 31, 2001 10:50 PM Subject: Once again ... row to column conversion > Sorry for having to post the same problem a second time

Re: Once again ... row to column conversion

2001-01-31 Thread Ryan Wahle
fields FROM table WHERE condition' --vertical dbname > > Otherwise write your program to do it. > > - Original Message - > From: "leo.putz" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Wednesday, January 31, 2001 11:50 AM > Subjec

Re: Once again ... row to column conversion

2001-01-31 Thread Eric Fitzgerald
z" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, January 31, 2001 11:50 AM Subject: Once again ... row to column conversion > Sorry for having to post the same problem a second time - > but by now I'm really at a loss. > Is there really no one out t

RE: row-to-column-conversion in 1 query

2001-01-31 Thread Johnson, Gregert

Once again ... row to column conversion

2001-01-31 Thread leo.putz
Sorry for having to post the same problem a second time - but by now I'm really at a loss. Is there really no one out there to give me a hint? I need the output of a query result (all query information is in one row) in one column (!). So, e.g., if you have all temperature lows in one row, how ca

SQL: row-to-column-conversion in 1 query

2001-01-31 Thread leo.putz
Hi there, I really get nuts Macromedia Generator needs COLUMNS to create a chart. But data to be visualized is stored in one ROW (whole record). Therefore I need a SQL- query which generates one column out of one row like: my wish:my source: ++ | capt.

row to column conversion

2001-01-29 Thread leo.putz
Hi there! Macromedia Generator needs a cloumn as query result to create a chart from given data (e.g. temperature lows). My data is stored in records (rows). Does anybody know a SQL syntax to return one column as query result containing the information from one row. Any help is greatly appreciate