User Answers

Hi Eric,

First you are using &sql who is for internal SQL use : doc

If you want to do an external query to a remote database you can do it with Ensemble :

My guess is that you are concatenating string with the operator "&" (AND) instead of "_".

If you do so, ObjectScript will cast your string as boolean false, the result of (false and false and false) equals 0, the result you see in your question.

Hi, Have you try to type your SQL parameters :

set param(i,"SqlType") = 12 //12 for SQL_VarChar

 

I hope this will help you.