What database are you using? How are you running the SQL statement ... via cfquery or directly in the DB?
Do the following fields exist in the tbl_users table: fullname firstname lastname ? --Bill In a message dated 10/5/01 3:29:54 PM Eastern Daylight Time, [EMAIL PROTECTED] writes: > UPDATE tbl_users > SET fullname = 'firstname' & " " & 'lastname' > > got an error, something about checking to see if field exists, too few > parameters. i tried it with and with out single quotes around the > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
