Its been stumping me for a few days and I thought I'd ask the experts out here.
Basically, its not recognizing my variable, although it has been set already.
Am I using the wrong syntax?
I'm using ColdFusion 10 and using Filemaker Pro Advanced 15.
Try using cfqueryparam -- it is also more secure:
WHERE IDStudent IN (<cfqueryparam value="#StudList#" list="true" cfsqltype="cf_sql_varchar">)
Also you may get a database error with an IN statement if your variable StudList is empty.
Thank you so much! It worked like a charm!