I am getting this error on some code I inherited. I am running cf9 and jQuery 1.7.
The value + (indx + 1) + cannot be converted to a number.
This is the loop
for (var indx = 0; indx < avgPopulationRecordsCount; indx++) {
CloneAvgPopulationItem(indx, '#rc.qGetAP.ID[' + (indx + 1) + ']#');
}
Your error message is entirely accurate: "The value + (indx + 1) + cannot be converted to a number."
Your variable rc.qGetAP.ID is a query column (effectively an array), and you are trying to index it with a string (as indicated by the single quotes), which CF is attempting to convert into a row number, but it cannot translate the text + (indx + 1) + into a number.
The problem here is less the code and more a matter of understanding what's going on:
JavaScript (which is what this is, not jQuery) occurs in the browser whilst ColdFusion occurs on the server.
These are two separate and distinct environments.
They are not interleaved in the way you are trying to do - they interact only over HTTP requests/responses (or via WebSockets/etc).
In brief:
For a more complete explanation on client/server and HTTP request/response, here is a blog post discussing the subject.
Once you have understood how this process works, the solution is to either:
1) generate all the relevant JS variables from CF first (so your Ids are translated to a JS array), and you have a single line of code to call the JS function CloneAvgPopulationItem inside a JS loop.
For example:
<script type="text/javascript">
var AvgPopIds = <cfoutput>#serialiseJson(ValueArray(rc.qGetAP.ID))#</cfoutput>;
for (var index = 0; index < avgPopulationRecordsCount; index++) {
CloneAvgPopulationItem(index, AvgPopIds[index]);
}
</script>
2) resolve the loop on the CF side, so you get multiple JS lines calling the CloneAvgPopulationItem function.
For example:
<script type="text/javascript">
<cfoutput query="rc.qGetAP">
CloneAvgPopulationItem(#rc.qGetAP.CurrentRow#,'#JsStringFormat(rc.qGetAP.Id)#');
</cfoutput>
</script>
It is important to state: do not just use these code examples but read and understand the article linked above about where JavaScript and ColdFusion run - the whole HTTP request/response process is an important one to understand and will avoid you encountering similar problems in future.
It looks like you are mixing <cfscript> with Javascript. ColdFusion gets processed first on server, then the generated Javascript gets generated. It looks like what you want is closer to
<cfoutput>
<script type="text/javascript>
<cfloop from="0" to="#avgPopulationRecordsCount#" index="indx">
CloneAvgPopulationItem(#indx#, '#rc.qGetAP.ID[indx]#');
</cfloop>
</script>
</cfoutput>
Update based on comments
After the above code is ran on the server, the following will on the web page.
<script type="text/javascript>
CloneAvgPopulationItem(1, 'someInfo');
CloneAvgPopulationItem(1, 'moreInfo');
CloneAvgPopulationItem(1, 'yetmoreInfo');
...
</script>
