Thanks I did solve this problem, it was the query but it wasn't the database
I was locked down in fixing the bug in one section and didn't see that there
was another field that was converted to bit but was wrapped with TRUE/FALSE
still which was acceptable under access:-)
But will keep that in mind for future reference:-)
-----Original Message-----
From: Dirk De Bock [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 24 May 2000 9:43 PM
To: [EMAIL PROTECTED]
Subject: Re: Upsizing Wizard from Access to MS SQL?
often it is usefull to use smallint in stead of bit fields, it will avoid
this sort of problems and you can GROUP BY on smallint, not on bit, and
there are other reasons that I forget about right now
just a thought
----- Original Message -----
From: "Andrew Scott" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, May 24, 2000 1:23 PM
Subject: Upsizing Wizard from Access to MS SQL?
>
> I have this small problem where I had a YES/NO field in a MS Access
> database, I then used the wizard to upsize this to MS SQL. THe problem is
> that the wizard made this a bit field which is fair enough, now under
> solaris & mySQL I don't recall having this problem but under MS SQL it
> appears to have a problem.
>
> Ok this simple insert query has problems from CF
>
> <cfquery name="name" datasource="datasource">
> insert into test (test) values (1)
> </cfquery>
>
> The error I get is as follows from the ODBC:-
>
> Disallowed implicit conversion from datatype 'varchar' to datatype 'bit'
> Table
>
> This I have no idea how to get around, my limited knowledge of MS SQL has
me
> stumped yet it works under mySQL so what am I doing wrong here:-)
>
> --------------------------------------------------------------------------
----
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
----------------------------------------------------------------------------
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
