How do parameters in custom queries work?

[chandiman]

i am trying to use custom query parameters multiple times in the my query. it works fine if I have 1 parameter. but when I have 2 parameters (each used twice), the query doesn’t execute and I get this error in the Local Web Server console.

Undefined binding(s) detected for keys [2,3] when compiling RAW query:

does the custom query component use named parameters or positional parameters?

[Hyperbytes]

Perhaps you could show a screenshot of your query?

[sitestreet]

@chandiman

2 parameters (each used twice)

This sounds like it could be the issue. Try setting them up as separate parameters. I’m thinking that the end query uses ? so is expecting 4 different values.

If you have :P1 and :P2, create :P3 to be the same as :P1 and :P4 to be the same as :P2.

Just a hunch.

[chandiman]

@sitestreet

@chandiman

2 parameters (each used twice)

This sounds like it could be the issue. Try setting them up as separate parameters. I’m thinking that the end query uses ? so is expecting 4 different values.

If you have :P1 and :P2, create :P3 to be the same as :P1 and :P4 to be the same as :P2.

Just a hunch.

This worked for me. Thanks.