Just my $0.02...
I'd have to agree with Dave Watts, that, if you are a developer, editing
data in a database manually is rarely a good idea. If you're going to do web
development, it's important to be able manipulate data in a db through SQL.
(Ben Forta's _SQL in 10 Minutes_ is a good start. _Joe Celko's SQL for
Smarties: Advanced SQL Programming_ is also an excellent book when you get
past the basics.)
One of the good things you get from being able to use the standard SQL data
manipulation commands (select, insert, update, delete) is that you can write
scripts to do all of the work for you. For example, you can write a SQL
statement to /generate/ insert statements, or write a python script to make
updating a table easier. I can save you hours and hours of tedious work
better done by a computer.
Probably the most important reason to write all your own SQL is that you
become more aware of what you can do with the database. You can better judge
what kind of code belongs on the db (for example, as a stored procedure).
Jeff Polaski
"The cow is of the bovine ilk;
One end is moo, the other, milk."
-- Ogden Nash
-----Original Message-----
From: Ed Gordon [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 03, 2002 5:52 PM
To: CF-Talk
Subject: OT? Easy data entry util for SQL?
We have been using Access for so long now I got used to being able to
enter/edit data with a few mouse clicks, just opened up the table and
started typing or making corrections (to users, parameters files, or
erroneous transactions during development).
Now that development has been ported to SQL, I dread the command-line data
entry of ISQL 6.5. Is there an easier way to do what I got used to doing
with Access? A recent article, I believe it was in CFDJ, talked about
interfacing the Access front-end to an SQL database thru ODBC. Have you
actually tried it? Any tips/tricks?
Thanks In Advance
Ed Gordon
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
