Highlighted

Filemaker Error Code?

New Here ,
Sep 04, 2018

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.

HelpHere.PNG

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.

Views

136

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more

Filemaker Error Code?

New Here ,
Sep 04, 2018

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.

HelpHere.PNG

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.

Views

137

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Sep 04, 2018 0
LEGEND ,
Sep 04, 2018

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,

^ _ ^

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Sep 04, 2018 0
Enthusiast ,
Sep 04, 2018

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.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Sep 04, 2018 1
IvanGn LATEST
New Here ,
Sep 04, 2018

Copy link to clipboard

Copied

Thank you so much! It worked like a charm!

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Sep 04, 2018 0