Hi All,
I'm having a simple problem I'm sure someone has come up against before.
I developed a CF system with an Access backend.
This was then ported to Foxpro.
Nearly everything worked fine but I'm having a problem setting Boolean
fields.
When I try the following -
<CFQUERY>
INSERT INTO (Tablename.BooleanField)
VALUES ('0')
<CFQUERY>
- I get a ODBC Data mismatch error.
I've tried the following in values and still got errors
VALUES(0)
VALUES('TRUE')
VALUES (TRUE)
The original query works fine when I run it against the Foxpro tables linked
into Access.
I presume that JET is doing some sort of Access -> ODBC conversion for me.
Anyone out using Foxpro able to help?
Regards
Michael O'Reilly
TransAer
------------------------------------------------------------------------------
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.
