Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2003
    Location
    new zealand
    Posts
    17

    Unanswered: update access db via frontpage asp

    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 !

  2. #2
    Join Date
    Jan 2003
    Location
    Midwest
    Posts
    138
    UPDATE Merlot SET CardRecordID='" & request("the field on the form where the card record id is entered ie. crId) & '", etc...

  3. #3
    Join Date
    Jan 2003
    Posts
    23
    Are all your fields of string type? i see some ID fields are these number?

  4. #4
    Join Date
    Feb 2003
    Posts
    1
    delete the comma after the last field and before the "WHERE"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •