Skip site navigation (1) Skip section navigation (2)

RE: Creating tables with Cold Fusion

From: "Chuck Kimber" <chuckk(at)ext(dot)usu(dot)edu>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: RE: Creating tables with Cold Fusion
Date: 2001-03-22 21:39:39
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
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(at)postgresql(dot)org
[mailto:pgsql-novice-owner(at)postgresql(dot)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
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(at)postgresql(dot)org)

In response to

pgsql-novice by date

Next:From: Lars ForsethDate: 2001-03-22 22:30:58
Subject: Re: Postgres installation
Previous:From: Philip YueDate: 2001-03-22 16:45:46
Subject: RE: [JDBC] Lost in unicode?

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group