-
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
-
Forum Rules
|
|