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
 Problems and bugs
 Crosseling products
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

borisvel
Starting Member

Slovenia
40 Posts

Posted - December 18 2011 :  09:21:44  Show Profile  Visit borisvel's Homepage  Reply with Quote
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-ASP Expert

Argentina
723 Posts

Posted - December 20 2011 :  03:52:46  Show Profile  Reply with Quote
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
Go to Top of Page

borisvel
Starting Member

Slovenia
40 Posts

Posted - December 20 2011 :  05:40:14  Show Profile  Visit borisvel's Homepage  Reply with Quote
Hi,

i found error.:

file: shopfileio.asp

line 1145

FindInDatabase "CROSSSELLING", strcrossProductids, fieldtype, rc, parsearray


Just one S to mach...

Kind regards, Boris
Go to Top of Page

borisvel
Starting Member

Slovenia
40 Posts

Posted - December 22 2011 :  04:58:55  Show Profile  Visit borisvel's Homepage  Reply with Quote
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
Go to Top of Page

diegomilito
VP-ASP Expert

Argentina
723 Posts

Posted - January 14 2012 :  02:28:50  Show Profile  Reply with Quote
boris, looks you have solved yourself. That's good!

enjoy weekend! and im going to play golf on this weekend.

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