|
keng
VP-CART New User
152 Posts |
 Posted - August 18 2005 : 23:58:07
|
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?
|
|
All Forums
Bulk Update
New Topic
Printer Friendly
Topic 
TrustGuard - PCI Security Scanner
