Ok, well i took out all the code and tried testing it without using null values, if you guys test this youll get a syntax error,
<cfquery datasource="test"> insert into test3 (Area,GeoMarket,Ctry,Location,LocationDescription,Family,Subfamily,Tag,Group,AssetDescription, Co,Rig,Quantity,Approval,Manufacturer,Model,Serial,PO,ServDateMMYY,FA_TC01,FA_TC02,FA_TC03,FA_TC04,FA_TC05,FA_TC06,FA_TC07,FA_TC08,FA_TC09) values(1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1) </cfquery> ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement. SQL = "insert into test3 (Area,GeoMarket,Ctry,Location,LocationDescription,Family,Subfamily,Tag,Group,AssetDescription, Co,Rig,Quantity,Approval,Manufacturer,Model,Serial,PO,ServDateMMYY,FA_TC01,FA_TC02,FA_TC03,FA_TC04,FA_TC05,FA_TC06,FA_TC07,FA_TC08,FA_TC09) values(1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1)" Data Source = "TEST" The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (1:1) to (1:27) in the template file c:\inetpub\wwwroot\converter\testing.cfm. Date/Time: 03/26/02 17:49:03 Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 5.0) Remote Address: 127.0.0.1 At 07:59 AM 3/26/2002 -0600, you wrote: >ou could use CFPARAM to set a default value of 0 for those >variables that are coming across as null. ______________________________________________________________________ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives........ http://www.mail-archive.com/[email protected] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe.................... mailto:[EMAIL PROTECTED] To Unsubscribe................ mailto:[EMAIL PROTECTED]
