I routinely run into problems with Dreamweaver MX when trying to update bit (datatype) fields.

Using the update record behavior, it defaults to numeric. When you test the page it returns an error:
<pre id=code><font face=courier size=2 id=code>
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'False'.
</font id=code></pre id=code>

I usually hand code things or make changes on the DB side, but how do you normally handle this with DMX?

Hi Phil,

Usually I dont use the bit datatype, I would say that it is strange that DMX doesnt handle this but with the number of glitches ever growing i wouldnt be suprised.

would be interested to see how people handle this as well.

By the way, any news from George yet?

Regards
Vince

DMX Talkzone Manager

Visit my home: www.chez-vince.com

VBScript | ASP | HTML | SQL | Oracle | Hosting

I even tried the checkbox Y/N. I always have to change them to INT an use 1/0 values.

as for george... www.dmxzone.com/forum/topic.asp?TOPIC_ID=28207