Janine, I suspect that one of your chose "types" is wrong. instead of CF_SQL_VARCHAR have you tried any other character types? How is your local variable declared within the stored proc?
-----Original Message----- From: Janine Jakim [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 09, 2002 10:37 AM To: CF-Talk Subject: Input parameters for stored procedures I have a stored procedure set that gives info for an entire grade or just one class depending on what the user chooses (by way of select boxes). But I can't seem to get the cfprocparam correct- When I try to pull by grade only I keep getting the error ODBC Error Code = 22005 (Error in assignment) [Microsoft][ODBC SQL Server Driver]Invalid character value for cast specification SQL = "sproc_GetStudents" This is how I'm calling the sp <CFSTOREDPROC PROCEDURE=" sproc_GetStudents" DATASOURCE="#Request.dsn#"> <CFPROCPARAM TYPE="IN" DBVARNAME="@GRADE" CFSQLTYPE="CF_SQL_VarChar" VALUE="#GRADE#"> <CFPROCPARAM TYPE="IN" DBVARNAME="@TCHRLINK" CFSQLTYPE="CF_SQL_INTEGER" VALUE="#TCHRLINK#"> <CFPROCPARAM TYPE="OUT" DBVARNAME="@STUDENTID" CFSQLTYPE="CF_SQL_VarChar" VARIABLE="STUDENTID"> <CFPROCRESULT NAME="StudentPrint"> </CFSTOREDPROC> I added Null="yes" but then just received a blank screen back. Thanks for any help ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
