Hi Jason,
You're right on both counts. I'll alter the piece I've written on this. Thanks.
Frank Hilliard
Jason Brooke wrote:
> > 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.
