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 column

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.

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

2001-01-31 Thread Johnson, Gregert

Re: Once again ... row to column conversion

2001-01-31 Thread Ryan Wahle
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 Subject: Once again ... row to column conversion Sorry for having to post the same problem a s

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 - but by now I'm

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