Doesn't the code below work? I don't have Access2k installed anywhere anymore, or I'd be able to answer this myself :D
<CFQUERY DATASOURCE="#request.NewDSN#"> ALTER TABLE cm_settings ADD isDemo text(1) NULL ; </CFQUERY> --------------------------------------- Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc., www.mysecretbase.com --------------------------------------- ---------- Original Message ---------------------------------- from: "Matthew Walker" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] date: Wed, 23 Oct 2002 10:10:45 +1300 >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
