J
JoeQuick
Hope this is the right group.
I am using FP2k, I created a form, it posts to lets say insert.asp .
All works fine with the exception that my form contains a firstname &
lastname field, and I need to also update the fullname field with the
insert.
Here is the sql I am using:
INSERT INTO AllDrivers (Driver, Office, FirstName, LastName, Name,
City, State, Status, Vehicle, Cell, Nextel, Cell2, Pager, Home,
County)
VALUES (':river::', '::Office::','::Firstname::', '::Lastname::',
'::FullName::' = ('::FirstName::' + ' ' + '::LastName::'),
'::City::', '::State::', '::Status::', '::Vehicle::', '::Cell::',
'::Nextel::', '::Cell2::', ':ager::', '::Home::', '::County::' )
when posting to insert.asp the fullname is blank.
What is it that I am missing?
Thanks
Joe
I am using FP2k, I created a form, it posts to lets say insert.asp .
All works fine with the exception that my form contains a firstname &
lastname field, and I need to also update the fullname field with the
insert.
Here is the sql I am using:
INSERT INTO AllDrivers (Driver, Office, FirstName, LastName, Name,
City, State, Status, Vehicle, Cell, Nextel, Cell2, Pager, Home,
County)
VALUES (':river::', '::Office::','::Firstname::', '::Lastname::',
'::FullName::' = ('::FirstName::' + ' ' + '::LastName::'),
'::City::', '::State::', '::Status::', '::Vehicle::', '::Cell::',
'::Nextel::', '::Cell2::', ':ager::', '::Home::', '::County::' )
when posting to insert.asp the fullname is blank.
What is it that I am missing?
Thanks
Joe