Well I rechecked all my variable types-in the tables/queries/stored procedure and the passing order, all seems ok (unless my eyes have gone totally batty) But the prob still seems to be only when I try to do a whole grade- it works fine if I pick only the teacher. The only way I can seem to get it to work to get all by grade is by removing the teacher link part from the page and stored procedure leaving my code to look like this.... <CFPROCPARAM TYPE="IN" DBVARNAME="@GRADE" CFSQLTYPE="CF_SQL_VarChar" VALUE="#GRADE#"> <CFPROCPARAM TYPE="IN" DBVARNAME="@TCHRLINK" CFSQLTYPE="CF_SQL_INTEGER" VALUE="#TCHRLINK#"> <CFPROCRESULT NAME="StudentPrint"> </CFSTOREDPROC>
Is there any other place I should look? -----Original Message----- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 09, 2002 11:48 AM To: CF-Talk Subject: RE: Input parameters for stored procedures Are the order of your params in the SP the same order as you are passing them in? i.e. grade then thcrlink, then studentid?....they need to be. Also double check that the datatypes of the variables in the SP are the same as the datatypes in the procparam tag. Finally ensure that the data being passed in is of the datatype that you have specified -----Original Message----- From: Janine Jakim [mailto:[EMAIL PROTECTED]] Sent: 09 April 2002 16:37 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 ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
