Since you are redoing the front end, what would it hurt to go into access
and just rename the database field to something without spaces? I'm not
that familiar with Access, so I don't know if it will let you do it, but
I've done this on more than one occasion with Sybase with no problems.
Todd Ashworth
CEO, Janty Corporation
www.janty.com - We put the 'u' in music!
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, September 08, 2000 11:46 AM
Subject: Access Field Names with Blanks in them
|
|
| I am re-writing a scheduling program that was written in ASP/VB to work in
Cold
| Fusion. The scheduling program uses an Access Database as its backend.
|
| This is just a small program and we are trying to keep the backend the
same and
| just re-write the front end. However, the person that wrote this access
| database made the field names contain spaces. For example, one field
name is 6
| AM
|
| I didn't think you could have spaces in a field name. But even so, how do
you
| tell Cold Fusion the field name? I didn't think you could use #6 AM#.
|
| I have just started re-writing it and I am going to try referencing the
field
| name as #6 AM#, but I wanted to get feedback.
|
| Is this the right way to do it? I would like not to have to re-write the
back
| end just yet.
|
| Mary
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.