AnsweredAssumed Answered

SQL Script

Question asked by Ben_B94 on Mar 2, 2016
Latest reply on Mar 3, 2016 by Ben_B94

Tried to edit an SQL script that was provided but one of the variables $currentAssignedItems, keeps returning ? This was after my DB changed from one table broken down into several so probably the wrong field name somewhere but due to a lack of understanding I'm having trouble. I don't really understand the set field part in the loop and secondly does scripting with executeSQL allow you to just specify fields without having the table prefix beforehand even for fields in different tables?

Attachments

Outcomes