MySQL Error#: 1064 You have an error in your SQL syntax; check the manual that corr
Powerstore V2
Any page that is bound to "Recordset (WADAProducts)" gives the error:
" MySQL Error#: 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 2"
when I click the tab next to "Recordset (WADAProducts)" in the bindings tab.
In "Server Behaviors" opening "Recordset (WADAProducts)" shows the following in "SQL":
"SELECT * , (ProductStock - (SELECT Coalesce(Sum(DetailQuantity),0)
FROM orderdetails INNER JOIN orders ON OrderID = DetailOrderID
WHERE DetailProductID = ProductID AND OrderDate > ProductUpdateDate))*ProductLive AS NumLeft FROM products WHERE ProductID = ParamProductID OR ( -1= ParamProductID2 AND ProductID= ParamSessionProductID)"
test shows no data and my connection is fine.
Mick
PS. I did try finding an answer in your forums and found a few references to a similar problem but no answer.
In one case the person posting resolved the issue on their own without explaining how or why.
I think that all resolutions should be fully fleshed out so as to make it easier for us to troubleshoot on our own without having to take up your valuable time and if one of you were to offer a synopsis of the process to the resolution, dumb it down if you will, I know it would help me and probably others as well.
