Eclipse Community Forums: BIRT » MySQL column Alias Problem

Home » Archived » BIRT » MySQL column Alias Problem

MySQL column Alias Problem [message #236717]

Wed, 02 May 2007 09:19

Eclipse User

Originally posted by: dwarak.orangescape.com

Hi

I am using MySQL as my Datasource (MySQL Connector/J driver). When I write a
query with an alias (e.g. select my_column_name as 'My Column Name' from
myTable then the resultant column name is displayed as unnamed_1 instead of
"My Column Name". If anyone has a solution for this issue it will be of
great help.

Regards
Dwarakanath

Re: MySQL column Alias Problem [message #236760 is a reply to message #236717]

Thu, 03 May 2007 12:13

Eclipse User

Hello Dwarakanath,

Try to drop the as from the select clause:

Select
t.c1 cust_first_name,
t.c2 cust_last_name
from
table t

Scott Rosenbaum

> Hi
>
> I am using MySQL as my Datasource (MySQL Connector/J driver). When I
> write a query with an alias (e.g. select my_column_name as 'My Column
> Name' from myTable then the resultant column name is displayed as
> unnamed_1 instead of "My Column Name". If anyone has a solution for
> this issue it will be of great help.
>
> Regards
> Dwarakanath

Previous Topic:	Report in a Browser widget renders differently or empty
Next Topic:	ChartWizardLauncher in chart examples

Goto Forum:

-=] Back to Top [=-

Current Time: Mon Sep 15 16:39:42 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter