Shouldnt the storedproc be... .... WHERE studentEmail = @email
-----Original Message----- From: Richard White [mailto:[EMAIL PROTECTED] Sent: Thursday, October 19, 2006 9:36 AM To: CF-Talk Subject: cfstoredproc Hi, i am getting a problem when i try to use stored procedures that are stored in the mysql database. the error that is coming up is java.lang.NullPointerException it is coming up with this error in the following cfstoredproc code: <cfstoredproc procedure="getStudentDetails" datasource="mydataSource"> <cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR" value="[EMAIL PROTECTED]" null="no"> <cfprocresult name="studentDetails"> </cfstoredproc> the stored procedure in the mysql database is: DELIMITER // CREATE PROCEDURE getStudentDetails (IN email VARCHAR(50)) BEGIN SELECT studentTitle, studentFirstName, studentLastName FROM STUDENTS WHERE studentEmail = email; END; // DELIMITER ; i would appreciate any help on why this error may be occuring. The datasource has shown to connect successfully. thanks for any help ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257349 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
