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...
smccafferty's avatar
smccafferty
Occasional Contributor
12 years ago
Hey there and thanks for the quick reply!



I haven't checked the value of localCourseID. Sorry about that. Very new to all this.



How do I get this value?



I know the QUERY generates the courseID (that col is assigned as an integer) as I've checked the SQL and it's sound.



the Project.Variables.yourVariable has name type default value, local value. Can I assign the local value with something like...



Project.Variables.t2350_CourseID.local_value = localCourseID; ?