Writing Queries

[jbreslow]

Hello,

I am interested in knowing how CF developers write queries in Dreamweaver. I'm
still using CF Studio to code because it has some features that I can't seem to
duplicate in DW. The major feature is writing queries in DW. In CF Studio I can
right-click on a table and write ANY type of query and run it against the DB.
Am I mistaken or does DW lack this feature?

I know in DW that I can go to Bindings and write a select query, but it
doesn't seem to let me run a delete query against the DB. So, what do you guys,
as CF developers, use to write/run queries against your DB?

Thanks

[The ScareCrow]

I myself code 98% of queries by hand, when I need to develop a complecated
query I use the db facilities.

But in DW, instead of using the bindings tab use the server behaviors tab.
There you can delete, insert and update records

Ken

[jbreslow]

Hey ScareCrow,

Thanks for the reply. I too code all my queries by hand, but once in a while I
want to run them against the DB to check their results, or to make a
modification to the DB, etc...

In DW 2004 if I go to Server Behaviors > (+) > Recordset (Query) it won't let
me run an Update or Delete query. I tells me that it must be a Select statement.

If I go to Server Behaviors > (+) > Delete Record, I'm lost. No idea what this
window is for, but it's not what I want. It seems to write to that gets
inserted into a page. I just want to write a query in a little window and run
it against a table.

Josh

[juknapp]

Josh,

If you are using Microsoft SQL Server as your database there is a tool that
allows you to write queries against a table and get immediate results (errors,
success messages). It is SQL Query Analyzer. If your in Enterprise Manager in
SQL, make sure the database you want to run against is selected and choose
Tools - > SQL Query Analyzer. You can access SQL Query Analyzer from the Start
Menu also.

Once SQL Query Analyzer is open, you can write queries and execute them
against the tables. This is a very powerful tool. I'm not sure what the other
DBMS offer.

[jbreslow]

Hi Juknapp,

Yes, that is one way to do it, but it means having another couple of programs
open, which I don't really need.

I'm flabbergasted that this can't be done in DW and nobody else seems to miss
this feature but me. It's not you, I'm just frusterated. I want to switch to DW
but I can't live without this feature. Back to CF Studio I guess.


J