Author |
Topic |
|
borisvel
Starting Member
Slovenia
47 Posts |
Posted - December 18 2011 : 09:21:44
|
Hi,
if crosseling is enabled ( vp asp version 6.094 ), than it works in Chrome browser, but doesn't works in IE 9.0. Error message:
Error Type: Microsoft JET Database Engine (0x80040E14) Syntax error (missing operator) in query expression 'catalogid in ( ) and hide=0 and cstock> 0'. /shopproductsubs.asp, line 1705
Browser Type: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; Trident/5.0; SLCC1; .NET CLR 2.0.50727; InfoPath.1; .NET4.0C; .NET CLR 3.0.30729)
Page: GET /shopexd.asp
Please help.
Thanks and kind regards, Boris
|
|
diegomilito
VP-CART Expert
Argentina
779 Posts |
Posted - December 20 2011 : 03:52:46
|
can u willing to show me your site url for the page that have cross sell ? i want to look at it before assume anything.
Diego |
|
|
borisvel
Starting Member
Slovenia
47 Posts |
Posted - December 20 2011 : 05:40:14
|
Hi,
i found error.:
file: shopfileio.asp
line 1145
FindInDatabase "CROSSSELLING", strcrossProductids, fieldtype, rc, parsearray
Just one S to mach...
Kind regards, Boris |
|
|
borisvel
Starting Member
Slovenia
47 Posts |
Posted - December 22 2011 : 04:58:55
|
Hi, please ignore my previous explanation, IT'S WRONG.
There must be 3 SSS....
Problem was in SPACE character i have in Crossselling field in PRODUCTS table. I removed it and now it works fine.
Sorry for previous mistake.
Kind regards, Boris |
|
|
diegomilito
VP-CART Expert
Argentina
779 Posts |
Posted - January 14 2012 : 02:28:50
|
boris, looks you have solved yourself. That's good!
enjoy weekend! and im going to play golf on this weekend.
Diego |
|
|
|
Topic |
|