Are you seeing a stack trace for this exception in the browser or in bluedragon.log? If so, could you post the stack trace to the list?
Paul From: [email protected] [mailto:[email protected]] On Behalf Of Anthony Hixon, Jr. Sent: Friday, February 13, 2009 4:33 PM To: openbd Subject: [OpenBD] Tag Question Are there any known issues using "cfqueryparam"? I'm getting a "java.lang.NullPointerException" on any of my queries that use them hitting a MySQL 5 database. The queries work fine if I remove them and use the actual value. For example, this will work: <cfquery name="qPhysicians" datasource="#request.dsn#"> SELECT PhysicianID, PhyFirstName, PhyLastName FROM physician WHERE PhyStatus = 'A' ORDER BY PhyLastName </cfquery> This will not: <cfquery name="qPhysicians" datasource="#request.dsn#"> SELECT PhysicianID, PhyFirstName, PhyLastName FROM physician WHERE PhyStatus = <cfqueryparam cfsqltype="cf_sql_varchar" value="A"> ORDER BY PhyLastName </cfquery> This is only an example. I have several other queries using cfqueryparam that generate the same NullPointerException. Any ideas? -- Anthony Hixon, Jr. Certified Advanced ColdFusion MX 7 Developer Mobile: (706) 639-3617 [email protected]<mailto:[email protected]> --~--~---------~--~----~------------~-------~--~----~ Open BlueDragon Public Mailing List http://groups.google.com/group/openbd?hl=en official site @ http://www.openbluedragon.org/ !! save a network - trim replies before posting !! -~----------~----~----~----~------~----~------~--~---
