Whoops. another glitch. It placed these includes and the code for the function GetSQLValueString below the recordsets that were generated.
<?php require_once('../../Connections/blog.php'); ?>
<?php require_once("../../webassist/database_management/wa_appbuilder_php.php"); ?>
<?php require_once("../../webassist/database_management/wada_search.php"); ?>
I have two fields that are validated using a boolean lookup table, and I got this error after correcting the code above:
Not unique table/alias: 'lu_bool' 
The query it has a hard time with is:
"SELECT id, title, pubDate, label, label FROM blog_posts LEFT JOIN lu_bool ON lu_bool.val = blog_posts.allowComment LEFT JOIN lu_bool ON lu_bool.val = blog_posts.closeComment ORDER BY pubDate DESC";
It needed to be:
"SELECT id, title, pubDate, lu_bool.label, lu_bool2.label FROM blog_posts LEFT JOIN lu_bool ON lu_bool.val = blog_posts.allowComment LEFT JOIN lu_bool AS lu_bool2 ON lu_bool2.val = blog_posts.closeComment ORDER BY pubDate DESC";
The buttons also came out odd:
That is all I found so far, but it feels a bit not ready for prime time yet. It is heading in the right direction though, but $149 was a bit high as an upgrade for the state of things I think as well. Just my $0.02 worth.
