I can't get the supposedly dirt-simple query below to work. Can anyone see anything wrong with my SQL? No matter what I do I get this error:
ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Syntax error in ALTER TABLE statement. The field adds fine in other platforms (different SQL of course); adds fine if used in a CREATE TABLE where all other fields in the table are defined at once, but won't work no matter what I alter below. <CFQUERY DATASOURCE="#request.NewDSN#" DBTYPE="ODBC" NAME="MakeTable"> ALTER TABLE cm_users ( ADD UserName text(10) NULL ); </CFQUERY> Any ideas would be greatly appreciated. --Matt Robertson-- MSB Designs, Inc. http://mysecretbase.com ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.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
