> 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.
Create table syntax can differ from database to database. That's why you
should consult the docs for your database, and not expect it to be in the cf
docs. The cf docs state that you can use cfquery to send sql to your database.
They also mention that that sql it not limited to queries.
http://www.allaire.com/cfdocs/CFML_Language_Reference/2_ColdFusion_Tags/lr2_07
3.htm#1019524
> 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 pgsql docs for alter table don't even suggest you use brackets around
column names or data types - the only place it suggests using brackets is
around the data size/length. Why were you trying to use brackets?
http://postgresql.planetmirror.com/users-lounge/docs/7.0/user/sql-altertable.h
tm
jason
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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.
