Looks fine to me... I'd try double-checking the data types and paraeters as well...
-----Original Message----- From: S.Isaac Dealey [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 10:23 PM To: CF-Talk Subject: unknown exception condition within cfstoredproc - win2k iis5 cf5 mssql2000 I'm running CF5 on Win2k IIS5 with mssql2000 and getting unknown exception condition PCodeRuntimeContextImp::executeSQLTagCFStoredProc::endTag The error occurred while processing an element with a general identifier of (CFSTOREDPROC), occupying document position (40:1) to (41:64) in the template file C:\CFUSIONMX\WWWROOT\DEV\TAPESTRY44E\_TAG\_OBJ\TAP_LIBRARYUPDATE.CFM. from this stored procedure: <cfstoredproc procedure="tap_LibraryUpdate" datasource="#request.tap.dsn#" username="#request.tap.dsnusr#" password="#request.tap.dsnpwd#"> <cfprocparam type="In" dbvarname="ID" value="#attributes.ID#" cfsqltype="cf_sql_integer"> <cfprocparam type="in" dbvarname="Name" value="#attributes.Name#" cfsqltype="cf_sql_varchar"> <cfprocparam type="in" dbvarname="RevisedBy" value="#attributes.RevisedBy#" cfsqltype="cf_sql_integer"> <cfprocparam type="in" dbvarname="Description" value="#attributes.Description#" cfsqltype="cf_sql_longvarchar"> <cfprocparam type="in" dbvarname="wddx" value="#attributes.wddx#" cfsqltype="cf_sql_longvarchar"> <cfprocparam type="in" dbvarname="Parent" value="#attributes.Parent#" cfsqltype="cf_sql_integer" null="#yesnoformat(not isnumeric(attributes.parent))#"> <cfprocparam type="in" dbvarname="UpdateInterval" value="#attributes.Update Interval#" cfsqltype="cf_sql_varchar" null="#yesnoformat(not len(attributes.updateinterval))#"> <cfprocparam type="in" dbvarname="dtNextUpdate" value="#attributes.dtNextU pdate#" cfsqltype="cf_sql_timestamp" null="#yesnoformat(not isdate(attributes.dtNextUpdate))#"> <cfprocparam type="in" dbvarname="ExpirationDate" value="#attributes.Expira tionDate#" cfsqltype="cf_sql_timestamp" null="#yesnoformat(not isdate(attributes.expirationdate))#"> <cfprocparam type="in" dbvarname="FileExtension" value="#attributes.FileExt ension#" cfsqltype="cf_sql_varchar" null="#yesnoformat(not len(attributes.FileExtension))#"> </cfstoredproc> Anybody see anything out of the ordinary? s. isaac dealey 954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to tapestry api is opensource http://www.turnkey.to/tapi certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
