Hello there,

I am trying to update my msaccess database table called Merlot via asp page I'm creating in frontpage...I'm new to hand coding the sql and am getting the SYNTAX ERROR ON UPDATE STATEMENT message..

This is the sql statement I'm using - note that these fields that are displayed for updating come from a custom query in a previous page (I'm using the WHERE statement to identify the record to update)


s-sql="UPDATE Merlot SET CardRecordID='::CardRecordID::', LastName='::LastName::', FirstName='::FirstName::', Salutation=':alutation::', AddressLine1='::AddressLine1::', AddressLine2='::AddressLine2::', AddressLine3='::AddressLine3::', City='::City::', Country='::Country::', Phone1='::Phone1::', Phone2='::Phone2::', FaxNo='::FaxNo::', Email='::Email::', Notes='::Notes::', CustomersSalesValue='::CustomersSalesValue::', DateofReferral=':ateofReferral::', Whomadethereferral='::Whomadethereferral::', Whodidtheyrefer='::Whodidtheyrefer::', SalesValueOfReferal=':alesValueOfReferal::', GiftType='::GiftType::', DateGiftSent=':ateGiftSent::', Area='::Area::', DateofQuote=':ateofQuote::', FollowupDate='::FollowupDate::', DateAccepted=':ateAccepted::', WHERE Phone1='::OldPhone1::'"

Can anyone help ???

Don't forget to go on an occassional wild goose chase.....that's what wild geese are for !

UPDATE Merlot SET CardRecordID='" & request("the field on the form where the card record id is entered ie. crId) & '", etc...

Are all your fields of string type? i see some ID fields are these number?

delete the comma after the last field and before the "WHERE"