' error

[thewizz]

Hi everyone,

Any help with regards to this error ?

Error Executing Database Query.
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC SQL Server
Driver][SQL Server]Line 1: Incorrect syntax near '('.

here's my code----

<cfquery name="getpk" datasource="#DSN.Portal#">

ALTER TABLE [dbo].[portalContent] (
[pk] [numeric](18, 0) NULL ,
[contentid] [char] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[title] [varchar] (400) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[datepublish] [datetime] NULL ,
[greetings] [varchar] (400) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[addContent] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[contact_name] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[contact_address] [varchar] (150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[contact_telephone] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[contact_email] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[contact_website] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[signature] [varchar] (300) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[client_name] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[client_address] [varchar] (150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[client_telephone] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[client_email] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[client_website] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

</cfquery>

Thanks!

[cjeris]

The error message is confusing because it's been double-chewed by an HTML
escaper; the real message is

Incorrect syntax near '('

which is absolutely correct. Check ALTER TABLE in Books Online. You cannot
use the same syntax for ALTER TABLE as you do for CREATE TABLE. You must
add/drop/alter columns individually, or else drop and recreate the table.