Re: Input parameters for stored procedures

shouldn't VALUE="#TCHRLINK#" be VALUE=#TCHRLINK# without the quotes? - Original Message - From: Janine Jakim To: CF-Talk Sent: Tuesday, April 09, 2002 12:28 PM Subject: RE: Input parameters for stored procedures Well I rechecked all my variable type

RE: Input parameters for stored procedures

://www.sheriff.org -Original Message- From: Janine Jakim [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 09, 2002 1:29 PM To: CF-Talk Subject: RE: Input parameters for stored procedures Well I rechecked all my variable types-in the tables/queries/stored procedure and the passing order, all

RE: Input parameters for stored procedures

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

RE: Input parameters for stored procedures

9, 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

RE: Input parameters for stored procedures

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

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