Surround the field name with square brackets like:
[field name]
Regards,
Howie Hamlin - inFusion Project Manager
On-Line Data Solutions, Inc.
www.CoolFusion.com
631-737-4668 x101
inFusion Mail Server (iMS) - The Intelligent Mail Server
----- Original Message -----
From: "Arden Weiss" <[EMAIL PROTECTED]>
To: "CF-Server" <[EMAIL PROTECTED]>
Sent: Sunday, June 10, 2001 9:01 PM
Subject: RE: Reading records from FoxPro database
> This ole dog didn't pay attention enough to understand the issue I
> reckon...
>
> How did you get a table containing a field name with a blank in it?
>
> When creating Fox tables via Fox's "create table" command, Fox doesn't let
> you have field names with spaces in them. I have no Fox tables that have
> field names with blanks in them.
>
> I don't think Fox will process field names with blanks. Are use sure that
> the blank is a blank and not an underscore "_" ???
>
> Let's talk some more...
>
> ^
> / \__
> ( @\___
> / O
> / (_____/
> /_____/
> Whoof...
> 410-757-3487
>
> -----Original Message-----
> From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> Sent: Saturday, June 09, 2001 9:14 PM
> To: CF-Server
> Subject: RE: Reading records from FoxPro database
>
>
> Thanks Arden for your response. I did read your paper and found it to be
> extermely valuable. However, I did not find an answer to my question.
> Which is how to select from a column that has space in its name. Keep in
> mind I have no control over how to name the column. An earlier reponse
> suggested aliasing where I use the name with a quote in conjunction with
> AS and give it a new column name without space. I tried that and it does
> not work. In other I wrote something like this:
>
> SELECT 'activity date' AS ActivityDate from TableName
>
> what I get is the literal ActivityDate instead of the value for that
> column. Your help is greatly appreciated.
>
>
> Safa
>
> > I use CF 4.5 to access FoxPro tables (both free and those contained in a
> > DBC) all of the time (using MDAC 2.5 ODBC driver -- I'm told 2.6 version
> of
> > the driver may have problems so have stayed away from it).
> >
> > I gave a presentation at the March 22nd meeting of the Annapolis
> Maryland
> > CFUG meeting on "FoxPro And ColdFusion Integration Problems and
> Solutions"
> > located at: www.ancfug.com/meetings (lists past meeting topics convered
> > ansd available papers).
> >
> > My paper has coding examples plus advice based on my good and bad
> > experiences.
> >
> > Hope it helps...
> >
> > ^
> > / \__
> > ( @\___
> > / O
> > / (_____/
> > /_____/
> > Whoof...
> > 410-757-3487
> >
> > -----Original Message-----
> > From: Paul Mone [SMTP:[EMAIL PROTECTED]]
> > Sent: Friday, June 08, 2001 8:11 PM
> > To: CF-Server
> > Subject: RE: Reading records from FoxPro database
> >
> > Have you tried putting quotes around the column names?
> >
> >
> > ---
> > Paul Mone
> > Ninthlink Consulting Group
> > [EMAIL PROTECTED]
> > http://www.ninthlink.com
> > 619.222.7082
> >
> >
> > -----Original Message-----
> > From: safa [mailto:[EMAIL PROTECTED]]
> > Sent: Friday, June 08, 2001 2:25 PM
> > To: CF-Server
> > Subject: Reading records from FoxPro database
> >
> >
> > I am trying to read from a database written in FOXPRO that I recieve from
> > one of my suppliers. I am trying to read the records in Cold Fusion, and
> I
> > am having problem writing the columns that have space in their name. Does
> > anyone know if its possible to handle that in Cold Fusion? Your help is
> > greatly appreciated?
> >
> > Safa Hussain - Application Developer
> > IET- Communications Resources
> > University of California, Davis
> > Voice (530) 754-7285
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
