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] --~--~---------~--~----~------------~-------~--~----~ 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 !! -~----------~----~----~----~------~----~------~--~---
