Re: Aliases in DBI/DBD
From: David N Murray (dmurray_at_jsbsystems.com)
Date: 12/25/04
- Previous message: Robert: "Aliases in DBI/DBD"
- In reply to: Robert: "Aliases in DBI/DBD"
- Next in thread: Jared Still: "Re: Aliases in DBI/DBD"
- Reply: Jared Still: "Re: Aliases in DBI/DBD"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Fri, 24 Dec 2004 22:10:48 -0500 (EST) To: Robert <rgoud@yahoo.com>
If you are trying something like
my $sql = "select to_char(mf.ROW_MOD_DATE,'MM/DD/YYYY') "Modify Date" from
tbl mf";
then its perl that's balking. (List hint: actual code samples are
extremely helpful.) You need to escape the quotes within this string
(well, that's one way to do it, anyway):
my $sql = "select to_char(mf.ROW_MOD_DATE,'MM/DD/YYYY') \"Modify Date\"
from tbl mf";
HTH,
Dave
On Dec 24, Robert scribed:
>
> Hi list, how do I specify alias in DBI/DBD-Oracle
>
> select
>
> to_char(mf.ROW_MOD_DATE,'MM/DD/YYYY') "Modify Date",
>
> mf.mf_name "Manufacture"
>
> from table1 mf
>
>
>
> DBI/DBD doesn't like double quotes, is there any other way?.
>
>
>
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
- Previous message: Robert: "Aliases in DBI/DBD"
- In reply to: Robert: "Aliases in DBI/DBD"
- Next in thread: Jared Still: "Re: Aliases in DBI/DBD"
- Reply: Jared Still: "Re: Aliases in DBI/DBD"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
