insert query with frontpage

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 ('::Driver::', '::Office::','::Firstname::', '::Lastname::',
'::FullName::' = ('::FirstName::' + ' ' + '::LastName::'),
'::City::', '::State::', '::Status::', '::Vehicle::', '::Cell::',
'::Nextel::', '::Cell2::', '::pager::', '::Home::', '::County::' )

when posting to insert.asp the fullname is blank.

What is it that I am missing?

Thanks

Joe
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top