Creating tables with CFQUERY is not dealt with in the latest CFML Language Reference
for Cold Fusion 4.5, nor in Ben Forta's excellent book on CF 4.0. Nor is it in the
Allaire on-line
reference material or in the in the Allaire Unix support forum. So, while some CF
developers may be aware they can create tables and add columns with CFQUERY, I'll bet
most aren't.
Now to the first question. If you try using the same code as PSQL inside CFQUERY
you'll find it won't work. There are a number of differences, the most important being
that ALTER TABLE does
not take, and will not work with, brackets around the column names and datatypes.
The reasons all this is not just an excercise is that not all Linux ISPs understand
Cold Fusion even when they have it on their systems. Using CFQUERY to get around the
PostgreSQL user
permission issue is crucial to working with these folks.
Best regards,
Frank Hilliard
Justin Buist wrote:
> I might have missed something in this discussion -- but isn't what you have
> in your CFQUERY tags exactly the same SQL code you would use on the PostgreSQL
> command line tool (psql) to create a table?
>
> If it is identical, where did the confusion creep in? Creating tables isn't
> something we all do every day via a command line SQL tool; so it's easy to
> forget the exact syntax but it's by no means an undocumented procedure.
>
> Justin Buist
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-linux%40houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_linux or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
