I think it is like this: <cfstoredproc procedure="" datasource=""> <cfprocparam cfsqltype="CF_SQL_LONGVARCHAR" dbvarname="@dbVarName" type="In" value="#Variable#"> </cfstoredproc>
---------- Original Message ---------------------------------- From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Mon, 10 Jun 2002 08:54:40 -0400 anyone know how to pass in a text data type into sql server using cfstoredproc and cfprocparam? Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org ______________________________________________________________________ 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

