Is param1 a string with the type set to something like CF_SQL_VARCHAR
or CF_SQL_LONGVARCHAR, then I assum param2 to be a 1 or a 0 with the
type set to CF_SQL_BIT and finaly a numeric passed to param 3 with a
type of CF_SQL_INTEGER ?
You also seem to have a YesNoFormat() in the Null section of the
CFQUERYPARAM, are the fields setup to allow for Null values?
HTH
Mike
----- Original Message -----
From: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Mon, 5 Jul 2004 09:50:09 -0400
Subject: Re: Havent seen this error before...
To: CF-Talk <[EMAIL PROTECTED]>
Sorry, HOF cut off some of the message (formatting from CFs error stuff)
I am now getting an odd error:
Error Executing Database Query.
Unknown Types value
The error occurred in /home/httpd/[omitted]/system/cfcomponents/com/
[omitted]/boutique/category.cfc: line 43
Called from /home/httpd/[omitted]/secure/editor/_cat.cfm: line 205
Called from /home/httpd/[omitted]/secure/editor/main.cfm: line 114
Called from /home/httpd/[omitted]/system/cfcomponents/com/
[omitted]/boutique/category.cfc: line 43
Called from /home/httpd/[omitted]/secure/editor/_cat.cfm: line 205
Called from /home/httpd/[omitted]/secure/editor/main.cfm: line 114
41 :
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)))#">,
--
SQL update tblboutcat2 set txtBoutCat = (param 1) , blActive = (param 2)
where intBoutCatID = (param 3)
DATASOURCE [omitted]
SQLSTATE S1000
Anybody ever seen this one before? This function is nearly identical to one in
another CFC that I currently have running which works perfectly (different
table and fields). I've double checked that there are values to my 'instance'
vars, that I have the sqltypes set correctly, etc. And I still can't figure it
out. Help....
Cutter
Quoting JediHomer <[EMAIL PROTECTED]>:
> Whats the other code around that, as I notice you end with a comma but
> 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]
