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 |
|