If you're using SQL Server then you can use Enterprise Manager, other databases have other solutions. If you want to easily run SQL against the server, you can write a SQL slave application (enter text and click GO) or use Jedit and you can type SQL in a new file and run it against the server of your choice (provided you've setup access to the database).
If you really want to avoid code, look into Enterprise Manager, it's the most "Access-like" way to enter data in SQL Server that I'm aware of. There is a way with Access I believe, but I hate Access, so I try to avoid that method. Just my two cents Joshua Miller [EMAIL PROTECTED] -----Original Message----- From: Jeffrey Polaski [mailto:[EMAIL PROTECTED]] Sent: Monday, October 14, 2002 2:11 PM To: CF-Talk Subject: RE: OT? Easy data entry util for SQL? 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
