Coldfusion and Access and Field Names (It ain't Paradox)

[R Schlageter]

Several years ago I wrote a database which keeps track of our campus
ministry participation ... I'm no expert but it keeps working well The
database is divided front and back end. Now we need to add a small
front end for the web. The university uses cold fusion.. And I've
taught myself how to do simple queries etc. The problem is when the
database was originally written I had a couple of multiple word field
names like First Name etc ( I didn't know any better.)Cold Fusion
doesn't like them but to change them breaks every form report and
query... Is there any utility which would search the database and
change all the reference if I changed a field name. Believe it or not
I used to use paradox for windows and I believe it did that....

Thanks

Fr. Bob Schlageter
University Chaplain
The Catholic University of America

[Olaf Rabbachin]

Hi,

On 21 Dec 2003 20:13:54 -0800, R Schlageter wrote:

Is there any utility which would search the database and
change all the reference if I changed a field name.

check out Rick's FAR: www.rickworld.com/download.html (Shareware).

Cheers,
Olaf [MVP]
--
My .02: www.Resources.IntuiDev.com

[Jerry Boone]

If your web front end is going to be simple, why not build some Access
queries and give your field names aliases? Name the queries something like
cfPeople and stuff... the sql syntax would look something like... Select
[First Name] as FirstName from People ...then in the ColdFusion
development, talk to the cfPeople query.

--
Jerry Boone
Analytical Technologies, Inc.
http://www.antech.biz
Secure Hosting and Development Solutions for ASP, ASP.NET, SQL Server, and
Access


"R Schlageter" <sc********@cua.edu> wrote in message
news:b9**************************@posting.google.c om...

Several years ago I wrote a database which keeps track of our campus
ministry participation ... I'm no expert but it keeps working well The
database is divided front and back end. Now we need to add a small
front end for the web. The university uses cold fusion.. And I've
taught myself how to do simple queries etc. The problem is when the
database was originally written I had a couple of multiple word field
names like First Name etc ( I didn't know any better.)Cold Fusion
doesn't like them but to change them breaks every form report and
query... Is there any utility which would search the database and
change all the reference if I changed a field name. Believe it or not
I used to use paradox for windows and I believe it did that....

Thanks

Fr. Bob Schlageter
University Chaplain
The Catholic University of America