From: Michael A Chase [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 14, 2002 8:47 AM
I recommend using explicit column names instead of '*'. If someone changes
the column order on you it could ruin the rest of your processing.
That's what fetchrow_hashref() is for. Asterisks are
Kipp, James [EMAIL PROTECTED] said:
yep
dates and date formatting to me are the trickiest things to deal with in
Oracle.
I think that there are 2 levels of settings. The main one is the language
setting, that sets other settings (date, numerics, ...), so that it covers 80%
of what the guy
From: [EMAIL PROTECTED]
To:Kipp, James [EMAIL PROTECTED]
Cc:'Vorce, Tim (T.)' [EMAIL PROTECTED], 'Jacqui Caren'
[EMAIL PROTECTED], Ronald J Kimball [EMAIL PROTECTED],
[EMAIL PROTECTED]
Subject: Re: Trying to get LIKE to work
Date: 15 Nov
I have a simple query using a LIKE in the statement and I just can get it
to
return any data. I know it works because i can do it in sqlplus and get
data
returned. I have tried everything to try to quote it correctly, like qq,
qw,
dbh-quote and finally placeholders. Code is below, any
Kipp, James [[EMAIL PROTECTED]] wrote:
I have a simple query using a LIKE in the statement and I just can get it to
return any data. I know it works because i can do it in sqlplus and get data
returned. I have tried everything to try to quote it correctly, like qq, qw,
dbh-quote and finally
Hmmm, I don't know if I agree with the %$date is a reference sentiment:
$ cat t.pl
$d = 7-Aug;
print %$d%;
print \n;
$ perl t.pl
%7-Aug%
$
(I first did this with 'perl -e', bash needs too many backslashes to make
it readable.)
Now, if I try this, I find I can't get it to work:
SQL desc t1
Name
On Thu, Nov 14, 2002 at 08:44:48AM -0500, Kipp, James wrote:
I have a simple query using a LIKE in the statement and I just can get it to
return any data. I know it works because i can do it in sqlplus and get data
returned. I have tried everything to try to quote it correctly, like qq, qw,
On Thu, 14 Nov 2002 08:44:48 -0500 Kipp, James [EMAIL PROTECTED] wrote:
I have a simple query using a LIKE in the statement and I just can get it to
return any data. I know it works because i can do it in sqlplus and get data
returned. I have tried everything to try to quote it correctly, like
the TO_CHAR worked.
Thanks Ronald and all that helped.
Jim
-Original Message-
From: Ronald J Kimball [mailto:rjk-dbi;focalex.com]
Sent: Thursday, November 14, 2002 9:37 AM
To: Kipp, James
Cc: [EMAIL PROTECTED]
Subject: Re: Trying to get LIKE to work
Since you mention sqlplus
oh wait. 7-Aug won't work on a date in oracle. Oracle defaults to upper
caseing everything so a like on %7-Aug% will not match 07-AUG-02 due
to the case difference. Try uppering the data you are testing for. do an
'%' || upper($date) || '%' and see what that does for you.
Something
On Thu, 14 Nov 2002 09:54:46 -0500, Hapworth, Adam wrote:
oh wait. 7-Aug won't work on a date in oracle. Oracle defaults to upper
caseing everything so a like on %7-Aug% will not match 07-AUG-02 due
to the case difference. Try uppering the data you are testing for. do an
'%' ||
On Thu, 14 Nov 2002 15:05:15 +0100, Jacqui Caren wrote:
On Thu, 14 Nov 2002 09:54:46 -0500, Hapworth, Adam wrote:
oh wait. 7-Aug won't work on a date in oracle. Oracle defaults to upper
caseing everything so a like on %7-Aug% will not match 07-AUG-02 due
to the case difference. Try
Since you mention sqlplus, I assume you are using Oracle... One
possibility is that the NLS_DATE_FORMAT (the default format for dates)
differs between your sqlplus and DBI sessions.
This is interesting. I did not know NLS_DATE_FORMAT could different between
tools used to query the data. For
On Thu, 14 Nov 2002 10:12:21 -0500, Kipp, James wrote:
Since you mention sqlplus, I assume you are using Oracle... One
possibility is that the NLS_DATE_FORMAT (the default format for dates)
differs between your sqlplus and DBI sessions.
This is interesting. I did not know
-:HH:MI:SS'),
Tim Vorce
Ford Motor Company
[EMAIL PROTECTED]
-Original Message-
From: Jacqui Caren [mailto:jacqui.caren;ig.co.uk]
Sent: Thursday, November 14, 2002 10:55 AM
To: Kipp, James; Ronald J Kimball
Cc: [EMAIL PROTECTED]
Subject: RE: Trying to get LIKE to work
On Thu, 14 Nov 2002
: Trying to get LIKE to work
As a follow-up, I noticed that setting the nls_lang
environmental variable causes the dates to be displayed
differently. Doesn't make any sense to me.
You can force the date format with something like this
select
COUNTRY_ISO3_C,ACCT_NAME_N,LANG_ISO_C,to_char
If I do it from DBI I get:
11/14/2002 10:11:41 AM
what is the NLS_DATE_FORMAT in your initSID.ora?
I assume the sqlplus is doing an alter session for some reason.
I know toad by default does not do an alter session.
Jacqui
I can't find seem to find that file. Found all types
: Thursday, November 14, 2002 9:41 AM
To: 'Jacqui Caren'
Cc: [EMAIL PROTECTED]
Subject: RE: Trying to get LIKE to work
If I do it from DBI I get:
11/14/2002 10:11:41 AM
what is the NLS_DATE_FORMAT in your initSID.ora?
I assume the sqlplus is doing an alter session
18 matches
Mail list logo