Re: Aliases in DBI/DBD
From: Jared Still (jkstill_at_cybcon.com)
Date: 12/25/04
- Previous message: David N Murray: "Re: Aliases in DBI/DBD"
- In reply to: David N Murray: "Re: Aliases in DBI/DBD"
- Next in thread: Robert: "Re: Aliases in DBI/DBD"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
To: David N Murray <dmurray@jsbsystems.com> Date: Sat, 25 Dec 2004 13:01:36 -0800
Or even my $sql=q{select to_char(mf.ROW_MOD_DATE,'MM/DD/YYYY') "Modify
Date" from table1 mf}
Jared
On Fri, 2004-12-24 at 19:10, David N Murray wrote:
> 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: David N Murray: "Re: Aliases in DBI/DBD"
- In reply to: David N Murray: "Re: Aliases in DBI/DBD"
- Next in thread: Robert: "Re: Aliases in DBI/DBD"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
