OK, I'm an idiot. ;D Thanks!
--Matt Robertson-- MSB Designs, Inc. http://mysecretbase.com -----Original Message----- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 18, 2002 12:24 AM To: CF-Talk Subject: Re: Dumb SQL: extend nvarchar field length? <CFQUERY DATASOURCE="#request.blah#"> ALTER TABLE dbo.woohoo ALTER COLUMN MyTitle nvarchar (50) NULL </CFQUERY> Douglas Brown Email: [EMAIL PROTECTED] ----- Original Message ----- From: "Matt Robertson" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, June 17, 2002 11:46 PM Subject: Dumb SQL: extend nvarchar field length? > I feel silly asking, but here goes, anyway: > > I want to be able to change a varchar field's length via a SELECT > statement. From a max of 10 chars to 50. How would I do that? I know > of course how to ADD or DROP an entire field, but change its allowable > length? Never did that before. > > Like this, maybe? Seems wrong. > > <!--- create it ---> > <CFQUERY DATASOURCE="#request.blah#"> > CREATE TABLE [dbo].[woohoo] ( > [MyTitle] [nvarchar] (10) NULL > ); > </CFQUERY> > > <!--- now alter the field length ---> > <CFQUERY DATASOURCE="#request.blah#"> > SET NOCOUNT ON > ALTER TABLE [dbo].[woohoo] ADD [MyTitle] [nvarchar] (50) NULL SET > NOCOUNT OFF </CFQUERY> > > > > ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
