oracle newbie

2003-09-19 Thread Stephenie Hamilton
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

Re: oracle newbie

2003-09-19 Thread Jim Campbell
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

RE: oracle newbie

2003-09-19 Thread Dain Anderson
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

RE: oracle newbie

2003-09-19 Thread Ian Skinner
-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

RE: oracle newbie

2003-09-19 Thread Douglas.Knudsen
- 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

Re: oracle newbie

2003-09-19 Thread Jim Campbell
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)

RE: oracle newbie

2003-09-19 Thread Douglas.Knudsen
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

Re: oracle newbie

2003-09-19 Thread Claude Schneegans
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