Column alias

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

Column alias

Do, Tan

The following query worked in version 1.8 but not in 2.2.5:

 

select long_name col_name from table_one

 

In 1.8, the column name is col_name as expected.

In 2.2.5, the column name is still ‘long_name’. 

 

Is there a setting or something?

 

Thanks,

Tan


------------------------------------------------------------------------------
The demand for IT networking professionals continues to grow, and the
demand for specialized networking skills is growing even more rapidly.
Take a complimentary Learning@Cisco Self-Assessment and learn
about Cisco certifications, training, and career opportunities.
http://p.sf.net/sfu/cisco-dev2dev
_______________________________________________
Hsqldb-user mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/hsqldb-user
Reply | Threaded
Open this post in threaded view
|

Re: Column alias

Fred Toussi-2
Yes see the get_column_name connection property.

http://hsqldb.org/doc/2.0/guide/dbproperties-chapt.html

Table 12.6. Column Names in JDBC ResultSet

Fred

On Monday, October 24, 2011 12:08 PM, "Do, Tan"
<[hidden email]> wrote:

The following query worked in version 1.8 but not in 2.2.5:


select long_name col_name from table_one


In 1.8, the column name is col_name as expected.

In 2.2.5, the column name is still ‘long_name’.


Is there a setting or something?


Thanks,

Tan

--------------------------------------------------------------------------
----
The demand for IT networking professionals continues to grow, and the
demand for specialized networking skills is growing even more rapidly.
Take a complimentary Learning@Cisco Self-Assessment and learn
about Cisco certifications, training, and career opportunities.
http://p.sf.net/sfu/cisco-dev2dev

_______________________________________________
Hsqldb-user mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/hsqldb-user

------------------------------------------------------------------------------
The demand for IT networking professionals continues to grow, and the
demand for specialized networking skills is growing even more rapidly.
Take a complimentary Learning@Cisco Self-Assessment and learn
about Cisco certifications, training, and career opportunities.
http://p.sf.net/sfu/cisco-dev2dev
_______________________________________________
Hsqldb-user mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/hsqldb-user
Reply | Threaded
Open this post in threaded view
|

Re: Column alias

Do, Tan
Okay it worked.  Thanks!

Tan

-----Original Message-----
From: Fred Toussi [mailto:[hidden email]]
Sent: Monday, October 24, 2011 12:41 PM
To: User discussions about HyperSQL Database Engine.
Subject: Re: [Hsqldb-user] Column alias

Yes see the get_column_name connection property.

http://hsqldb.org/doc/2.0/guide/dbproperties-chapt.html

Table 12.6. Column Names in JDBC ResultSet

Fred

On Monday, October 24, 2011 12:08 PM, "Do, Tan"
<[hidden email]> wrote:

The following query worked in version 1.8 but not in 2.2.5:


select long_name col_name from table_one


In 1.8, the column name is col_name as expected.

In 2.2.5, the column name is still ‘long_name’.


Is there a setting or something?


Thanks,

Tan

--------------------------------------------------------------------------
----
The demand for IT networking professionals continues to grow, and the demand for specialized networking skills is growing even more rapidly.
Take a complimentary Learning@Cisco Self-Assessment and learn about Cisco certifications, training, and career opportunities.
http://p.sf.net/sfu/cisco-dev2dev

_______________________________________________
Hsqldb-user mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/hsqldb-user

------------------------------------------------------------------------------
The demand for IT networking professionals continues to grow, and the demand for specialized networking skills is growing even more rapidly.
Take a complimentary Learning@Cisco Self-Assessment and learn about Cisco certifications, training, and career opportunities.
http://p.sf.net/sfu/cisco-dev2dev
_______________________________________________
Hsqldb-user mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/hsqldb-user
------------------------------------------------------------------------------
The demand for IT networking professionals continues to grow, and the
demand for specialized networking skills is growing even more rapidly.
Take a complimentary Learning@Cisco Self-Assessment and learn
about Cisco certifications, training, and career opportunities.
http://p.sf.net/sfu/cisco-dev2dev
_______________________________________________
Hsqldb-user mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/hsqldb-user