VP-ASP :: Shopping Cart Software

Shopping Cart Software Solutions for anywhere in the World

US/Canada(Toll Free): +1 888 587 2278
Europe/UK: +44 (020) 7193 9408
Australia/New Zealand: +61 3 9016 4497

VP-ASP Shopping Cart Customer Forum

Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 VPCart Forum
 General help me questions
 Bulk Update
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

keng
VP-ASP New User

152 Posts

Posted - August 18 2005 :  23:58:07  Show Profile  Reply with Quote
Hi,

When I do my bulk update to update passwords, I get this error message

_________________________________________________

Microsoft JET Database Engine error '80040e14'

Syntax error in UPDATE statement.

..../shopa_editdisplaybulk.asp, line 682
Microsoft JET Database Engine error '80040e14'

Syntax error in UPDATE statement.

/shopping/shopa_editdisplaybulk.asp, line 682
_____________________________________________________

On line 682 of shopa_editdisplaybulk.asp this is what is shows
_____________________________________________________________
next
stocksql=stocksql & sqlo
stocksql=stocksql & " where " & idfield & "=" & idvalue
'debugwrite stocksql
If sqlo<>"" then
dbc.execute(stocksql)
end if
next
shopwriteheader getlang("LangProductUpdated") & " " & rowsintable
end sub
'*********************************************************************************
' ccategory and subcategoryid require updating of prodcategories table
'*********************************************************************************
Sub handleSpecialUpdatefields (fieldname, fieldtype, fieldvalue, sqlo, rc)
rc=4

_____________________________________________

Any clue?

keng
VP-ASP New User

152 Posts

Posted - August 19 2005 :  02:42:50  Show Profile  Reply with Quote
Never mind. This case is resolved.

Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000