Posted by Richard Lynch on 01/20/05 01:03

Tim Burgan wrote:
> I am continually getting a data type mismatch error (relating to the
> boolean columns) when trying to execute this code.
>
> I've tried removing the single quotes, but that returns a syntax error.

I've forgotten the rules for MS-Access, but...

Perhaps try 1 and 0 as your bool, with no apostprophes.

I really would have expected the true/false with no apostrophes to work
myself...

You could try to build a sample query in Access itself, using that damn
GUI thingie they have, which always just confused me personally, to see
what Microsoft thinks is proper SQL -- Not that it really *IS* proper SQL,
but at least it will work with Access, hopefully.

--
Like Music?
http://l-i-e.com/artists.htm

• Prev in thread: SQL - INSERT INTO booleans
• Next in forum: Re: [PHP] Re: Windows CLI and task scheduler
• Prev in forum: Re: [PHP] Need best way to determine if cronjob or external browser called my script
• Thread view: SQL - INSERT INTO booleans

[Reply to this message]