using cf_sql_bit (which would have been the next line of the query) in my db,
but instead the cf_sql_tinyint type (one area of MySQL I wish they would get
with everybody else...) It's always the little things. Thanks for everyone's
input.
Cutter
Quoting "Mark A. Kruger - CFG" <[EMAIL PROTECTED]>:
> Dan,
>
> I would check the following. Is it an exact type match? For example, is the
> field a "text" field and you are using
> varchar? I would check to make sure that the field is nullable - since you
> are using the "null" attribute. And I would
> try other types if you can.
>
> -Mark
> -----Original Message-----
> From: Greg Luce [mailto:[EMAIL PROTECTED]
> Sent: Monday, July 05, 2004 9:28 AM
> To: CF-Talk
> Subject: RE: Havent seen this error before...
>
>
> I don't believe you need those single-quotes inside cfqueryparam. But show
> more code and I'm sure we'll be able to tell you what's wrong. Show us the
> whole query at least.
>
> Greg
>
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Monday, July 05, 2004 10:09 AM
> To: CF-Talk
> Subject: Re: Havent seen this error before...
>
> Looks like you are missing a set of single quotes in your value attribute.
>
> Instead of this,
> 45 : set txtBoutCat = <cfqueryparam
> cfsqltype="cf_sql_varchar"
>
> value="#instance.category#" null="#yesnoformat(not len(trim
> (instance.category)))#">,
>
> try this:
> 45 : set txtBoutCat = <cfqueryparam
> cfsqltype="cf_sql_varchar"
>
> value="'#instance.category#'" null="#yesnoformat(not len(trim
> (instance.category)))#">,
>
>
>
>
> [EMAIL PROTECTED]
> ets.com
> To
> 2004-07-05 09:50 CF-Talk <[EMAIL PROTECTED]>
> cc
>
> Please respond to Subject
> [EMAIL PROTECTED] Re: Havent seen this error
> sion.com before...
>
> 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]
