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