cfprocparam error

[newbiepg]

<cfstoredproc datasource=&quot;test&quot; procedure=&quot;myProc
<cfprocparam type = &quot;IN&quot; CFSQLType=&quot;cf_sql_longvarchar&quot; value= &quot;var_in_clause&quot; maxLength=&quot;4000&quot; dbVarName = &quot;@in_clause&quot; null=&quot;no&quot;>
</cfstoredproc>


Throws this error


[Macromedia][SQLServer JDBC Driver][SQLServer]Syntax error converting the varchar value 'var_in_clause' to a column of data type smallint.


<cfoutput>#var_in_clause#</cfoutput>
gives

5003,5002,5001,5000,45,44,43,25,24,23,22,21,20,19,18,17,16,15,14,13,12,11


The stored proc runs fine when I run it from the query analyzer

Any ideas?

 

[TruthInSatire]

never used this tag before but wouldn't you need #'s around the variable name to get the value? it is in quotes so it is trying to make &quot;var_in_clause&quot; into a number (according to the error)

<cfstoredproc datasource=&quot;test&quot; procedure=&quot;myProc
<cfprocparam type = &quot;IN&quot; CFSQLType=&quot;cf_sql_longvarchar&quot; value= &quot;[bold]#[/bold]var_in_clause[bold]#[/bold]&quot; maxLength=&quot;4000&quot; dbVarName = &quot;@in_clause&quot; null=&quot;no&quot;>
</cfstoredproc>

http://thereptilian.com/

 

[TruthInSatire]

someday i'll earn to preview first.... :-
<cfstoredproc datasource=&quot;test&quot; procedure=&quot;myProc
<cfprocparam type = &quot;IN&quot; CFSQLType=&quot;cf_sql_longvarchar&quot; value= &quot;#var_in_clause#&quot; maxLength=&quot;4000&quot; dbVarName = &quot;@in_clause&quot; null=&quot;no&quot;>
</cfstoredproc>

http://thereptilian.com/

 

[newbiepg]

Hi I managed to solve it

Putting &quot;#var_in_clause#&quot; was the problem
just inserted the values directly instead of assigning values to var_in_clause and trying to pass it

Thanks for trying

 

[TruthInSatire]

your original code didn't have pound signs around the variable name making &quot;var_in_clause&quot; a literal not passing the value of var_in_clause (5003,5002,5001,5000,45...)

http://thereptilian.com/