By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
457,757 Members | 1,186 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 457,757 IT Pros & Developers. It's quick & easy.

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

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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
Nov 12 '05 #2

P: n/a
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

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.