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
