Copy link to clipboard
Copied
Hi everyone,
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.
Copy link to clipboard
Copied
I have zero experience with Filemaker Pro, but I did find this in a Google search. I hope it helps.
V/r,
^ _ ^
Copy link to clipboard
Copied
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.
Copy link to clipboard
Copied
Thank you so much! It worked like a charm!