Filemaker Error Code?

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.

This topic is closed to new replies. Start a new post to keep the conversation going.

pete_freitagCorrect answer

Participating Frequently

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.

pete_freitagCorrect answer

Participating Frequently

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.

Translate

Participant

Thank you so much! It worked like a charm!

Translate

Legend

I have zero experience with Filemaker Pro, but I did find this in a Google search. I hope it helps.

V/r,

^ _ ^

Translate

Sign up