>>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
Archi
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 an
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
Message-
>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, as
Stephenie
I've never had your exact problem, but I have experience difficulty with
NULL values in Oracle from ColdFusion using the default JDBC/ODBC drivers.
I have several times created queries that would throw JDBC/ODBC errors since
I was selecting fields that contained NULL values particularly
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 IS null
-Dain
-Original Message-
From: Stephenie Hamilton [mailto:[EMAIL PROTECTED]
Sent: Fri 9/19/2003 3:19 PM
To:
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
7 matches
Mail list logo