Results 1 to 4 of 4

Thread: Need help with Update Statement

  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.

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,931
    I am not an expert in ASP, just throwing a dart, don't you need a ; at the end of the query?

  3. #3
    Join Date
    Mar 2003
    Posts
    3
    I have never needed one before

  4. #4
    Join Date
    Mar 2003
    Posts
    3
    I figured it out, and have to say that this is pretty damn stupid on Microsofts part.

    The datebase i was working with is only an access database(Hope nobody minds me posting this question in an SQL Server forum) and the connection string was the problem. I was using PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE=datebase then switched to Driver={Microsoft Access Driver (*.mdb)};DSN=;DBQ=database and everything works fine now. What the heck was that about.

    Anyhow if anyone ever has that problem, you now have a solution.

    Thanks, Lloyd Cormier

Posting Permissions

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