Looks like you are trying to insert numeric data as text into a number only field. You are using 'quotes' somewhere you shouldn't be.
Quoting "Douglas L. Brown" <[EMAIL PROTECTED]>: > I have the following query and keep getting an error upon insert. The > field type is varchar(10) and the one giving an error is custNum > > > Error = Error Diagnostic Information > ODBC Error Code = 37000 (Syntax error or access violation) > > > [Microsoft][ODBC SQL Server Driver][SQL Server]Line 12: Incorrect > > syntax near '59595098'. > > > > > > > <CFQUERY DATASOURCE="#application.dsn#" NAME="insert_cust_loc_info"> > DECLARE @maxid int > BEGIN > SELECT @maxid = MAX(ID) > FROM cust_location_info > IF @maxid IS NULL > SELECT @maxid = 1 > ELSE > SELECT @maxid = @maxid + 1 > END > > INSERT INTO cust_location_info ( custNum, > id, > loc_desc, > f_name, > l_name, > address_1, > city, > state, > zip_code, > phone_1, > ext_1, > email, > isDefault ) > VALUES '#Trim(custNum)#', > @maxid, > '#Trim(loc_desc)#', > '#Trim(f_name)#', > '#Trim(l_name)#', > '#Trim(address_1)#', > '#Trim(city)#', > '#Trim(state)#', > '#Trim(zip_code)#', > '#Trim(phone_1)#', > '#Trim(ext_1)#', > '#Trim(email)#', > 'yes' > WHERE custNum = '#Trim(custNum)#' > > </CFQUERY> > > > <CF_SIGNATURE > NAME="Douglas L. Brown" > EMAIL="[EMAIL PROTECTED]" > PHONE="714.538.6611" > WEB="http://www.carnivorepc.com";> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com 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
