In explanation of Ryan's response: ZSQL methods understand only named arguments. It should be <dtml-in "getVideoSQL(<arg-name>=pCode)"> where <arg-name> should be replaced by the name getVideoSQL expects. Arguments passed by place are simply not recognized.