Thanks for the tip Jim. That works on my development machine, but I don't think I can make the change to my production server (shared).
Marc Garrett "Jim McAtee" <[EMAIL PROTECTED]> wrote in message 010701c17abd$5a0aa820$352fa8ce@jim">news:010701c17abd$5a0aa820$352fa8ce@jim... > It looks like in the CF Administrator's ODBC editing for the Merant Text > Driver they forgot to allow you to enter delimiting character. It's > available, however, if you configure the datasource directly through the > server's Data Sources/ODBC utitily. > > Jim > > ----- Original Message ----- > From: <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Saturday, December 01, 2001 3:51 PM > Subject: Merant Text Driver: how to specify pipe character? > > > > How can I get the Merant Text Driver to recognize a pipe ("|") delimited > > text file? I've tried selecting the "character" table type, but I can't > see > > any option to specify the character. > > > > I'm moving from an Access ODBC text driver, which allowed you to specify > the > > separator. Thanks for any assistance, > > > > Marc Garrett > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
