MS Access 2000.
[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