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:137732 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 Get the mailserver that powers this list at http://www.coolfusion.com
