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 an hour about some SQL not working right only to find I had cachedwithin set in the cfquery tag. DOH!
I've not seen any issues with null, SQL, and the JDBC driver that ships with CFMX. Its Friday 4:00 EST...time to give up and hit happy hour maybe? ^_^ Doug >-----Original Message----- >From: Stephenie Hamilton [mailto:[EMAIL PROTECTED] >Sent: Friday, September 19, 2003 3:43 PM >To: CF-Talk >Subject: Re:oracle newbie > > >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) so the only way I can >even look at the db is with oracle worksheet, which is doesn't >show me much compared to SQL Ent. Mgr (which is what i worked >with the last 3 years.) > >~~ >Steph > > > >>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 >> > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137743 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
