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.
