no more code is shown.
Might help to scope your vars, so add something like
<CFSET VAR Cat = "">
after the <CFFUNCTION
or ommit the name of the CFQUERY if its not going to return anything.
Potentially pass the datasource in as an argument rather than trying
to access the Application scope
HTH
Mike
----- Original Message -----
From: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Mon, 5 Jul 2004 08:55:50 -0400
Subject: Havent seen this error before...
To: CF-Talk <[EMAIL PROTECTED]>
I am now getting an odd error:
Error Executing Database Query.
Unknown Types value
42 : <cffunction name="update" access="public" output="false"
returntype="boolean">
43 : <cfquery name="cat" datasource="#application.config.DSN#">
44 : update tblboutcat2
45 : set txtBoutCat = <cfqueryparam cfsqltype="cf_sql_varchar"
value="#instance.category#" null="#yesnoformat(not len(trim
(instance.category)))#">,
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
