-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
At least with the example you gave, you've got two issues to deal
with -- the embedded space & the leading digit in the field name.
Neither of those are kosher in CF.
Try something like:
<Cfquery ...>
SELECT '6 AM' as SixAm
FROM ....
</cfquery>
If you use the SQL query to alias all of your 'bad' field names to
something CF can deal with, then you should be okay.
Although... In all honesty, you *should* rename the fields....
Hope that helps!
Best regards,
Zac Bedell
> I was just trying to avoid having to explain why I had to
> rename them when "it
> was working just fine using ASP."
> 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!
>
> |
> |
> | 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.
-----BEGIN PGP SIGNATURE-----
Version: PGPfreeware 6.5.8 for non-commercial use <http://www.pgp.com>
iQA/AwUBObkzHwraVoMWBwRBEQJ3BwCg8s6ZzROYyxzpxXDYPOYKhlP3/k8AoMRb
PnOTmryOLQxehBs5zpYcwJgm
=ZnQj
-----END PGP SIGNATURE-----
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
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.
