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 > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
