I've investigated this too some time back and come up with no answers. An easier solution I've found is to use <cfqueryparam> to insert nulls if the field is empty.
> -----Original Message----- > From: Jim McAtee [mailto:jmcatee@;mediaodyssey.com] > Sent: Wednesday, 23 October 2002 9:30 a.m. > To: CF-Talk > Subject: Access 2000 - ALTER TABLE - Allow Zero Length > > > I've looked around, but haven't been able to find a means to > use an ALTER TABLE > SQL statement to create (or change) a column in Access with > the "Allow Zero > Length" property set to TRUE. Does anyone know of a means to > do this? Maybe a > custom tag instead? > > Jim > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
