WOW! It's amazing what a pair of single quotes will do. That was the problem. In looking back you did not have that in your original code either. I must have added them while I was trying different settings. My fault.
On a side note, dealing with the same script, I would effictively like to insert a Variable into that function call on the template: <%set Carrier = Dbsql::custom::GetCarrier('<%ID%>')%>
Obviously this does not work. What is the best way to insert a variable, rather than a fixed number, to call that script?
Also, is there any difference between using a Global versus using an outside script file? I actually prefer the script file over the global variable just because I'm a programmer and it is easier to modify and control a file (mainly with upgrades I can just drop and replace a file to test on a non production server). But if there is an advantage to using the Globals I would be happy to.
On a side note, dealing with the same script, I would effictively like to insert a Variable into that function call on the template: <%set Carrier = Dbsql::custom::GetCarrier('<%ID%>')%>
Obviously this does not work. What is the best way to insert a variable, rather than a fixed number, to call that script?
Also, is there any difference between using a Global versus using an outside script file? I actually prefer the script file over the global variable just because I'm a programmer and it is easier to modify and control a file (mainly with upgrades I can just drop and replace a file to test on a non production server). But if there is an advantage to using the Globals I would be happy to.