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
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
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
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
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
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.
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