ok, i am having trouble with a simple query.
in oracle worksheet, this produces 11 records (what it should be)
SELECT shp_id, spr_nr, loc_cd, pkg_id, csn_na, xcp_cd, act_cd, asn_ir
FROM tbl_shp
WHERE asn_ir IS null
but the same statement in CF produces 0 records...
this is the first time i have
Those have to be the most obfuscated column names I've ever seen :)
- Jim
Stephenie Hamilton wrote:
ok, i am having trouble with a simple query.
in oracle worksheet, this produces 11 records (what it should be)
SELECT shp_id, spr_nr, loc_cd, pkg_id, csn_na, xcp_cd, act_cd, asn_ir
FROM tbl_shp
To: CF-Talk
Cc:
Subject:oracle newbie
ok, i am having trouble with a simple query.
in oracle worksheet, this produces 11 records (what it should be)
SELECT shp_id, spr_nr, loc_cd, pkg_id, csn_na, xcp_cd, act_cd, asn_ir
FROM tbl_shp
WHERE asn_ir IS null
but the same statement in CF
-Original Message-
From: Stephenie Hamilton [mailto:[EMAIL PROTECTED]
Sent: Friday, September 19, 2003 12:19 PM
To: CF-Talk
Subject: oracle newbie
ok, i am having trouble with a simple query.
in oracle worksheet, this produces 11 records (what it should be)
SELECT shp_id, spr_nr
-
From: Dain Anderson [mailto:[EMAIL PROTECTED]
Sent: Friday, September 19, 2003 3:24 PM
To: CF-Talk
Subject: RE: oracle newbie
You may need to prefix the table name with the correct schema:
SELECT shp_id, spr_nr, loc_cd, pkg_id, csn_na, xcp_cd, act_cd, asn_ir
FROM MySchema.tbl_shp
WHERE asn_ir
Can you install a third-party tool like Aqua Data or TOAD? That might
be a little friendlier.
- Jim
Stephenie Hamilton wrote:
I am not sure what the schema name is, they didn't tell me that...any hints on how i
could find it using oracle worksheet?
I cannot use RDS (corporate rules...arg)
you have debugging on? Is the SQL correct there? Cached query? Is the cfm page
cached inadvertantly by CF? The user for the DSN is the same as in this 'oracle
worksheet' and teh same DB actually? I know, some cheesy easy questions, but you
never know. I've been known to bang my head for
i had no control over the db at all.
These obviously were set by some database administrator ;-)
Never would a programer use such messy column names ;-)
~|
Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137753
8 matches
Mail list logo