Allowing zero length strings in Access is a table property separate from allowing NULL values. By default, when you create a table, allow zero length strings is FALSE. I did come across some code to do it using ASP and ADO, but I'm not sure how I'd hook into it using CF.
Jim ----- Original Message ----- From: "Matt Robertson" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, October 22, 2002 3:20 PM Subject: RE: Access 2000 - ALTER TABLE - Allow Zero Length > 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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
