never mind...got it!!! thanks.
ALTER TABLE reports ADD routeId BIGINT NULL it was the explicit word "column" that I had wrong :) thanks! tony weeg uncertified advanced cold fusion developer tony at navtrak dot net www.navtrak.net office 410.548.2337 fax 410.860.2337 -----Original Message----- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Thursday, June 26, 2003 12:41 PM To: CF-Talk Subject: sql-ot:alter table hey, sorry, but.... ALTER TABLE Reports ADD COLUMN routeId INT NULL what is that giving me this error... I just want to add a column to an existing table...called reports, making the new column an INT and have it nullable. ???? thanks....i have used this same snippet before just different names and now its not working? tony weeg uncertified advanced cold fusion developer tony at navtrak dot net www.navtrak.net office 410.548.2337 fax 410.860.2337 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
