Harry,
>From Access97 help:
"When Boolean values are converted to other data types, False becomes 0 and
True becomes -1."
(don't know if this applies to Access2000 but would assume it does...)
Yet another case where Microsoft goes to the beat of their own drummer.
Hope this helps.
Ben
> -----Original Message-----
> From: Harry Kurrosawa [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, October 30, 2000 3:32 PM
> To: CF-Talk
> Subject: Re: Datatype Mismatch in Access
>
> Thanks Kevin and Sebastian for your suggestion. I've tried replacing the
> 'yes' value with 1. But the same error still keeps popping up. WHen I
> modified my script, got rid of CFQUERY and used CFINSERT, it just worked
> beautifully. I'm just wondering, why does this work:
>
> <cfscript>
> Form.HostName = "Host Test";
> Form.RoleContact = 1;
> Form.ContactName = "Sales Manager";
> </cfscript>
>
> <cfinsert datasource="netinfhosts" tablename="CompanyInfo">
>
> while this doesn't:
>
> <cfquery name="AddAccount" datasource="netinfhosts" debug="Yes">
> Insert into CompanyInfo (HostName, RoleContact, ContactName)
> Values('Host Test', 1, 'Sales Manager')
> </cfquery>
>
> Leong
>
> At 08:52 PM 10/29/2000 -0500, you wrote:
> Don't quote the yes value. It is a true false field. Make yes the number
> 1
> with no quotes for yes and 0 for no. It may be a yes no field in access
> but
> it works much better when you supply it a boolean value.
>
> Kevin
> ----- Original Message -----
> From: Harry Kurrosawa <[EMAIL PROTECTED]>
> To: CF-Talk <[EMAIL PROTECTED]>
> Sent: Sunday, October 29, 2000 8:42 PM
> Subject: Datatype Mismatch in Access
>
>
> > Hi,
> >
> > I'm wondering if anyone can help with this problem. Since I'm pretty new
> to using ColdFusion with MS Access, I can't figure out why the following:
> >
> > <cfquery name="AddAccount" datasource="netinfhosts" debug="Yes">
> > Insert into CompanyInfo (HostName, RoleContact, ContactName)
> > Values('Host Test', 'Yes', 'Sales Manager')</cfquery>
> >
> > causes this error:
> >
> > ODBC Error Code = 22005 (Error in assignment)
> > [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria
> expression.
> >
> > The error occurred while processing an element with a general identifier
> of (CFQUERY), occupying document position (10:4) to (10:67)
> >
> > I've rechecked my database, and the fields, HostName, RoleContact, and
> ContactName, have been set as text(50), yes/no, and text(50) respectively.
> Is there anything wrong with the SQL statements or was my database not set
> up properly?
> >
> > Thanks,
> >
> > Harry
> >
> >
> > _____________________________________________________________
> >
> >
> >
>
> --------------------------------------------------------------------------
> ----------------------
> Archives: http://www.mail-archive.com/[email protected]/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
> a message with 'unsubscribe' in the body to
> [EMAIL PROTECTED]
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
