Forum Discussion

smccafferty's avatar
smccafferty
Occasional Contributor
12 years ago

Trying to Assign an SQL returned value to a Project Variable

Hey there. I've been trying for a while to assign a value (returned from a SQL query) to a local variable. Here's the code: function SetCourseID() { var aCon, aCmd, setCourseID; var loca...
AlexKaras's avatar
AlexKaras
Community Hero
12 years ago
Hi Sean,



> Project.Variables.AddVariable("t2350_CourseID","String");

> I know the query returns an integer [...]

> The problem is a mismatch on this line: Project.Variables.t2350_CourseID = localCourseID;



What if you change

Project.Variables.AddVariable("t2350_CourseID","String");

to

Project.Variables.AddVariable("t2350_CourseID","Integer");

?



P.S. BTW, I believe that you checked the value of the localCourseID variable in the debugger, aren't you?