|
augiem3
Starting Member
USA
12 Posts |
 Posted - July 23 2008 : 14:45:28
|
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 |
|
All Forums
Bug found in shopfileio.asp
New Topic
Printer Friendly
Topic 
TrustGuard - PCI Security Scanner
