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
 Add-ons for VP-ASP
 Bug found in shopfileio.asp
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

augiem3
Starting Member

USA
12 Posts

Posted - July 23 2008 :  14:45:28  Show Profile  Reply with Quote
VPASP 6.50.0.2 (Plus)

Original code (line 1968):
if getsess("xdatabasetype") = "MYSQL" OR getsess("xdatabasetype") = "MYSQL351" OR getconfig("xMYSQL")="Yes" OR getsess("xdatabasetype") = "SQLSERVER" then
scsql = scsql & " AND intcatalogid IN (SELECT catalogid FROM products WHERE not hide = 1 "
else
scsql = scsql & " AND intcatalogid IN (SELECT catalogid FROM products WHERE not hide = TRUE "
end if


Corrected code:
if xdatabasetype = "MYSQL" OR xdatabasetype = "MYSQL351" OR getconfig("xMYSQL")="Yes" OR xdatabasetype = "SQLSERVER" then
scsql = scsql & " AND intcatalogid IN (SELECT catalogid FROM products WHERE not hide = 1 "
else
scsql = scsql & " AND intcatalogid IN (SELECT catalogid FROM products WHERE not hide = TRUE "
end if


This normally doesn't cause a problem, but I'm running my site on SQL Server now and this was causing the category navigation to error out.

Edited by - augiem3 on July 23 2008 14:47:19
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000