• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

Filemaker Error Code?

New Here ,
Sep 04, 2018 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.

Views

320

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
community guidelines

correct answers 1 Correct answer

Enthusiast , Sep 04, 2018 Sep 04, 2018

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.

Votes

Translate

Translate
LEGEND ,
Sep 04, 2018 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,

^ _ ^

Votes

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
community guidelines
Enthusiast ,
Sep 04, 2018 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.

Votes

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
community guidelines
New Here ,
Sep 04, 2018 Sep 04, 2018

Copy link to clipboard

Copied

LATEST

Thank you so much! It worked like a charm!

Votes

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
community guidelines
Resources
Documentation