Didnt have () around my values to insert.............
Doug ----- Original Message ----- From: "Douglas L. Brown" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Saturday, November 17, 2001 4:36 PM Subject: Re: problem with insert > The only numeric fields are ID, ZIP_CODE. That is why I cannot figure it > out. I have an update that is the sam and works fine on the same table and > the same columns. Here is the update. > > UPDATE cust_location_info > > SET custNum = '#Trim(custNum)#', > id = '#Trim(id)#', > loc_desc = '#Trim(loc_desc)#', > f_name = '#Trim(f_name)#', > l_name = '#Trim(l_name)#', > address_1 = '#Trim(address_1)#', > city = '#Trim(city)#', > state = '#Trim(state)#', > zip_code = '#Trim(zip_code)#', > phone_1 = '#Trim(phone_1)#', > ext_1 = '#Trim(ext_1)#', > email = '#Trim(email)#', > isDefault = 'yes' > > WHERE custNum = '#custNum#' > AND ID = '#ID#' > > ----- Original Message ----- > From: "Peter Tilbrook" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Saturday, November 17, 2001 4:14 PM > Subject: Re: problem with insert > > > > 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";> > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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
