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 date fields with NULL values. I resolved this problem this week by installing the Oracle JDBC Thin Client, and setting up a datasource to use that instead. Resolved my misbehaving query at least.
HTH -------------- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA > -----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, 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:137734 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
