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 >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:137731 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