which should throw an error if this is required, should it not? Unless there are two tables, one under the schema and one without ala a synonym.
Stephanie, out of curiosity can you use RDS to browse this table? Can you run the SQL in CFStudio's query tool? Doug >-----Original 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, 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: 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 produces 0 records... >this is the first time i have played with oracle, so am i just having >a bad brain day or what? >~~ >Stephenie > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137735 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
