Results 1 to 4 of 4

Thread: Need help with Update Statement

Threaded View

  1. #1
    Join Date
    Mar 2003
    Posts
    3

    Need help with Update Statement

    FieldName, Type, Size

    productid, Long Integer,
    name, Text, 255
    french_name, Text, 255
    productcode, Text, 50
    brief, Memo, 536870910
    french_brief, Memo, 536870910
    description, Memo, 536870910
    french_description, Memo, 536870910
    specs, Memo, 536870910
    french_specs, Memo, 536870910
    reviews, Memo, 536870910
    french_reviews, Memo, 536870910
    price, Curreny, 8
    saleprice, Curreny, 8
    rebateprice, Curreny, 8
    deliveryprice, Curreny, 8
    corporate, Curreny, 8
    government, Curreny, 8
    wholesale, Curreny, 8
    VIP, Curreny, 8
    employee, Curreny, 8
    image, Text, 255
    catcode, Integer, 4
    type, Text, 10
    notes, Memo, 536870910
    french_notes, Memo, 536870910
    featured, Boolean, 2
    accessory, Boolean, 2
    rates, Memo, 536870910
    french_rates, Memo, 536870910
    rebateinfo, Memo, 536870910
    french_rebateinfo, Memo, 536870910

    Qry = "Update products Set name='Cybiolink 2500',french_name='',productcode='',brief='The Cybiolink 2500 has all the great features of the Cybio 2000, with a new sleek look. It has a four-line display with Simultaneous Viewing of existing and incoming calls, One-touch Voice Mail and a 67-Name and 99-Number Memory, which makes keeping up-to-date and organized an easy chore. ',french_brief='',description='The Cybiolink 2500 has all the great features of the Cybio 2000, with a new sleek look. The Cybiolink 2500 has a four-line display with Simultaneous Viewing of existing and incoming calls, One-touch Voice Mail and a 67-Name and 99-Number Memory, which makes keeping up-to-date and organized an easy chore. ',french_description='',specs='more specs coming soon...',french_specs='',reviews='',french_reviews ='',price=80,saleprice=0,rebateprice=0,deliverypri ce=5,corporate=80,government=0,wholesale=80,VIP=80 ,employee=80,image='no_image',catcode=7,type='',no tes='dec6.02 - sale until dec 24',french_notes='',featured=0,accessory=0,rates=' ',french_rates='',rebateinfo='',french_rebateinfo= '' Where productid=493"

    objRecConn.Execute(Qry)

    -2147217900, Syntax error in UPDATE statement.

    When this statement is cut and pasted into an update view in access it works fine, but not from ASP.

    Can anyone tell me what the problem is.
    Thanks, Lloyd Cormier
    Last edited by Tomfoolry; 03-13-2003 at 02:46 PM.

Posting Permissions

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