This content has been marked as final. Show 3 replies
It has nothing to do with your query. This
<cfargument name="newjobNo" required="yes" type="string">
does not match this
Set Job_Key = #ARGUMENTS.jobNo#
Also, your argument specifies a string but your sql does not have quotes.
Finally, since you are setting all the records to the same new job number, instead of running a query inside a loop, it is probably more efficient to run one query which includes something like
where custno in (#ValueList(arguments.yourquery.custno)#)
Thanks for the assist. I was so wrapped up in the passing of the query that I overlooked the obvious. I'll give it a go using the valueList.
Again, thanks for the help.
> It has nothing to do with your query. This
Well it kind of does.
> <cfloop query="#ARGUMENTS.GoodRequests#">
The query parameter takes the NAME of the query, not the *actual query*.
Lose the pound-signs.