I've played around with ADO with success. Would be interested in seeing the code. There's some useful ADO stuff at cfhub.com
Matthew Walker http://www.matthewwalker.net.nz/ > -----Original Message----- > From: Jim McAtee [mailto:jmcatee@;mediaodyssey.com] > Sent: Wednesday, 23 October 2002 10:51 a.m. > To: CF-Talk > Subject: Re: Access 2000 - ALTER TABLE - Allow Zero Length > > > 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
