This is from a working query I have, formatting intact but should be unimportant:
<CFQUERY DATASOURCE="#request.NewDSN#"> CREATE TABLE cm_dhtmlmenu ( ID COUNTER NOT NULL PRIMARY KEY , StatCode text(15) , SubFilter text(10) , MenuText memo ); </CFQUERY> --------------------------------------- Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc., www.mysecretbase.com --------------------------------------- ---------- Original Message ---------------------------------- from: Les Irvin <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] date: Mon, 14 Oct 2002 12:35:20 -0600 >Can anyone tell me the sql for creating a memo field in a table (Access >database)? >This obviously does not work: > ><CFQUERY NAME="create" DATASOURCE="#ds#"> > CREATE TABLE temp (tapeid number PRIMARY KEY, Title char(255), Desc memo) ></cfquery> > >Thanks, >Les > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
