Hi, looking at the code, this comes from the macro itself. It checks whether a select, show or describe query is done, and if not, it returns this error.

Is this one of these three type of queries?

Kind regards
Bart

--- (Edited on 23-March-2016 13:39 [GMT+0100] by bartjol) ---

--- (Edited on 23-March-2016 13:40 [GMT+0100] by bartjol) ---

Ok, I've managed to enter the WHERE clause (must escape the ' chars with \).

So, this works:

<script>

function RefreshGroup(group) {

document.getElementById("familiaProducto").outerHTML='^SQL("SELECT DISTINCT Familly FROM db.Products WHERE Group=\'hardCodedGroupNotTheParameterButWorks\'", ^0;, "databaseLinkId");';

}

</script>

This doesn't work (and i need it working!):

<script>

function RefreshGroup(group) {

document.getElementById("familiaProducto").outerHTML='^SQL("SELECT DISTINCT Familly FROM db.Products WHERE Group=\'' + group + '\'", ^0;, "databaseLinkId");';

}

</script>

I've alse tried to, unsuccessfully, use this function to format the string (similar ti C# .Net)

<script>
    String.format = function() {
        var s = arguments[0];
        for (var i = 0; i < arguments.length - 1; i++) {       
            var reg = new RegExp("\\{" + i + "\\}", "gm");             
            s = s.replace(reg, arguments[i + 1]);
        }
        return s;
    }
</script>

Regards

--- (Edited on 3/23/2016 12:12 pm [GMT-0500] by sysred) ---

I don’t think you can use the sql macro the way you want it to. I haven’t used WebGUI in a while but as far as I can remember the macro’s are precompiled and therefore cannot be used to update stuff dynamically from javascript functions.

Correct me if I’m wrong of course!

I thought in the same direction, but sysred gets an error from the macro itself, meaning it is getting processed as far as I can tell. Allthough, I think youŕe right on that the won't get evaluated again on a js input.

--- (Edited on 23-March-2016 20:18 [GMT+0100] by bartjol) ---

chatty-mode

how’s the mongodb course going :P

Will call you soon!

/chatty-mode

--- (Edited on 23-March-2016 20:35 [GMT+0100] by bartjol) ---

I think the concatenating goes awry:

If I look at where the single quotes are placed, I think it only gets:

'^SQL("SELECT DISTINCT Familly FROM db.Products WHERE Group=\''

(that are 2 sigle quotes on the end) and the next part falls off:

 + group + '\'", ^0;, "databaseLinkId");'

Not sure whether the js variable within a macro gets evaluated properly, allthough nested macros are possible. You might want to try:

document.getElementById("familiaProducto").outerHTML='^SQL("SELECT DISTINCT Familly FROM db.Products WHERE Group=\'" + group + "\'", ^0;, "databaseLinkId");';

but no garantuees, as I really doubt it will work :)

--- (Edited on 23-March-2016 20:32 [GMT+0100] by bartjol) ---

First of all, thank you very much for all your replies! (:

Setting the outerHTML was one of my first "bullets" against this problem, I tried it without success. But I've managed to solve my problem using a SQL Report.

Looks like the ^SQL macro is designed to "fire" a SQL sentence "as is" (without any kind of custom parameters)

--- (Edited on 3/30/2016 9:43 am [GMT-0500] by sysred) ---