Larry,
Thanks for the reply, apologies for not getting back sooner.
<CFQUERY>
INSERT INTO Tablename (BooleanField) VALUES (.T.)
<CFQUERY>
Sorry, but this doesn't work for me.
I've also tried this code in Borlands SQL explorer using the ODBC connection
to the database I'm using. As I suspected Access (i.e. Jet) was doing some
conversion to make the SQL I was testing work with the linked ODBC Foxpro
databases. But when using just ODBC (i.e. in CF or SQL explorer with Jet out
of the equation) you get an error if the ODBC datasource doesn't like your
SQL.
-----Original Message-----
From: Larry Meadors [mailto:[EMAIL PROTECTED]]
Sent: 09 May 2000 16:03
To: [EMAIL PROTECTED]
Subject: RE: Boolean fields in Foxpro
I know this works:
<CFQUERY>
INSERT INTO Tablename (BooleanField) VALUES (.T.)
<CFQUERY>
Larry
>>> [EMAIL PROTECTED] 05/09/00 01:50AM >>>
I can't believe that this is causing me so much grief.
Last night I tried the following
<CFQUERY>
INSERT INTO (Tablename.BooleanField)
VALUES ('.T.')
<CFQUERY>
I also tried
VALUES (.T.)
VALUES ('T')
VALUES (T)
VALUES ('#.T.#')
and none of these work.
----------------------------------------------------------------------------
--
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.
