don't quote the firstname and lastname first of all and make sure that & is the right concat operator.
Travis ---- Original Message ---- From: James Taavon <[EMAIL PROTECTED]> Sent: 2001-10-10 06:28:23.0 To: SQL <[EMAIL PROTECTED]> Subject: Re: Merging two fields in Access MS Access 2000. yes firstname and lastname fields exist with data. fullname is empty, but i want to populate with the merging of first name and lastname. [EMAIL PROTECTED] wrote: > > 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 > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
