SQL issue with concat in WiKi
This statement works with no issue in phpAdmin and in a Wiki page
\{SQL(db="myDSN" wikiparse="1" )\}select Hull,USCG,
'Hull Nbr ', Hull,' - SV ',BoatName, '', OwnerName
from HullInfo where current = 'x' LIMIT 0, 5 \{SQL\}
This statement work fine in phpAdmin but produces an error when saving in Tiki Wiki page
\{SQL(db="myDSN" wikiparse="1" )\}select Hull,USCG,
CONCAT('Hull Nbr ', Hull,' - SV ',BoatName, ''), OwnerName
from HullInfo where current = 'x' LIMIT 0, 5 \{SQL\}
Error message:
Forbidden
You don't have permission to access /tiki/tiki-editpage.php on this server.
Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.
any thoughts?
note: used \ to escape the syntax so the coding would display
thanks
- pat