That is giving me the following error: Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'ALTER'.
Stated that it was line 6 which would be the first alter in the statement. Tim Starling Project Manager - Web Development Global Aid Network A ministry of Campus Crusade for Christ International 972-234-0800, extension 1335 www.gainusa.org -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Phillip Holmes Sent: Friday, June 09, 2006 2:45 PM To: Dallas/Fort Worth ColdFusion User Group Mailing List Subject: Re: [DFW CFUG] SQL change data type <cfquery datasource="aff" name="Dataadd"> ALTER TABLE [dbo].[affiliated] with NOCHECK ALTER COLUMN [dbo].[affiliated].[Affiliate_bday] int </cfquery> with nocheck ignores exist constraints. Regards, Phillip Holmes http://www.phillipholmes.com On 6/9/06, Tim Starling <[EMAIL PROTECTED]> wrote: > > > > > > I am trying to change the data type of a column in a ms sql table and have followed the examples that I have but I keep getting a syntax error - I'm probably overlooking something. Here is the SQL that I am using: > > > > <cfquery datasource="aff" name="Dataadd"> > > ALTER TABLE affiliated > > MODIFY Affiliate_bday int; > > </cfquery> > > > > The error I get is: > > > > Incorrect syntax near 'Affiliate_bday'. > > > > > > What is the proper syntax to change the data type for a column in MS SQL? I need to change a column that was set up as varchar to be an integer. > > > > Thanks, > > Tim > > > > Tim Starling > Project Manager - Web Development > Global Aid Network > A ministry of Campus Crusade for Christ International > 972-234-0800, extension 1335 > www.gainusa.org > > ________________________________ This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal - For more information please visit www.marshalsoftware.com ________________________________ > _______________________________________________ > Reply to DFWCFUG: > [email protected] > Subscribe/Unsubscribe: > http://lists1.safesecureweb.com/mailman/listinfo/list > List Archives: > http://www.mail-archive.com/list%40list.dfwcfug.org/ > http://www.mail-archive.com/list%40dfwcfug.org/ > DFWCFUG Sponsors: > www.HostMySite.com > www.teksystems.com/ > > > -- Warmest Regards, Phillip B. Holmes _______________________________________________ Reply to DFWCFUG: [email protected] Subscribe/Unsubscribe: http://lists1.safesecureweb.com/mailman/listinfo/list List Archives: http://www.mail-archive.com/list%40list.dfwcfug.org/ http://www.mail-archive.com/list%40dfwcfug.org/ DFWCFUG Sponsors: www.HostMySite.com www.teksystems.com/ ##################################################################################### This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal ##################################################################################### _______________________________________________ Reply to DFWCFUG: [email protected] Subscribe/Unsubscribe: http://lists1.safesecureweb.com/mailman/listinfo/list List Archives: http://www.mail-archive.com/list%40list.dfwcfug.org/ http://www.mail-archive.com/list%40dfwcfug.org/ DFWCFUG Sponsors: www.HostMySite.com www.teksystems.com/
