Nested repeat regions, variable......., solved but now I'm getting duplicate values in nested results.
The parameter name shouldn't have any special characters in the SQL statement.
Try using "clientid" as the parameter.
Hi Ray, thanks very much for getting back to me in the holiday period. I did attempt your suggestion but got the same error. I solved the issue though by creating a variable manually e.g.
<?php
$clientid = ($RsTest->getColumnVal("id"));
settype($clientid, "integer");
?>
Then I placed variable $clientid in the query of the record set for the nested repeat region.
The problem I have now is that I am getting duplicate results in the nested repeat region. I am not the greatest coder in the world but I presume it's because I am using two different record sets and two different repeaters. And the nested repeat region is forced to loop again per parent record.
So my question now is, is there a simple command I can place here to spot and cancel/kill duplicates?
or
Should I use a join tables in one record set to unify the tables in one query? I have read that this solves the duplicate problem in the forums?
Please let me know what you think.
Many thanks.
I have attached updated code if you need to view.