ColdFusion is very powerful, and of course CFQUERY will work. You should be
able to run any SQL that the database server will understand through it.
Including CREATE TABLE and MODIFY TABLE SQL statements. But I don't think
it's as easy to use as some other things. In order to run a cfquery, you
have to connect to the server somehow to create a cfm page that contains a
cfquery. Then once you create it, you have to save it and then go to your
browser to request the cfm page from the server to run it and see the
results. For me, it is just as easy to connect to the server via ssh, or
telnet, or through any other means and just simply run psql. Then I can
just create queries on the fly and see their results immediately. Then once
I have my query perfected, I'll write it to a cfm page for my ColdFusion
application to use.
Chuck Kimber
-----Original Message-----
From: pgsql-novice-owner@postgresql.org
[mailto:pgsql-novice-owner@postgresql.org]On Behalf Of Frank Hilliard
Sent: Thursday, March 22, 2001 5:52 AM
To: PostGreSQL Novice List
Subject: [NOVICE] Creating tables with Cold Fusion
I just wondered how widely known it is that you can create tables and alter
tables inside Cold Fusion CFQUERY tags? I just found this out and it's
proving
extremely useful for remote control of a database at an ISP.
Frank Hilliard
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)