Before I spend too long looking, does anyone know if its possible to ALTER TABLE and
insert a field in other than the last ordinal_position???
This query adds a column in the last position..
<cfquery name="addfield" datasource="#default_datasource#">
ALTER TABLE #table# ADD #form.column_name# #form.type_name#<cfif #form.type_name#
is "varchar">(#form.length#)</cfif> #null#
</cfquery>
like so.
column1
column2
the new column is added here
I want...
column1
Insert a column here
column2
Jeff Craig
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
