Accessing database

[verns]

I've succesfully built cfm webpage from the getting started tutorial of CF MX7.
Refering to the tutorial i wonder if i can let a user to edit the database
directly from the webpage. This way i dont have to edit the database from the
microsoft access instead a user will be able to access/edit the database.Thanks
in advance!!

[Dan Bracuk]

With the code you write, you can enable users to:
1. Add, update, or delete records in a table.
2. Run "canned" reports.
3. Turn text files into database records.
4. Work with data from more than one database.

other neat stuff

[verns]

Hi there
Generally i got the idea....but frankly speaking i am a beginner...if you dont
mind, would you please eleborate the steps for me?How do i enable users to
perform the above mentioned?Thanks again...

[paross1]

You would design your ColdFusion pages with the appropriate queries (SELECT
UPDATE, INSERT, DELETE) to perform the database actions, based on user input on
the web interface. You can actually create a CF page that allows your clients
to write free form queries directly in a text box that are then executed in the
database, but that is dangerous and not advisable.

Phil

[Dan Bracuk]

verns - step number 1 - learn sql

For learning computer stuff, I like the SAMS books that have titles like Teach
Yourself language abc is x amount of time.

I haven't read this particular one, but, I've heard good things about Teach
Yourself SQL in 10 Minutes, by Macromedia's very own ( ta-da) Ben Forta.

[verns]

Hello guys...thank you very much on your guidance and advise..i am on track now!