Why do strings from a dropdown component get truncated in SQL query

Ignition
1

I am working on the ignition gold cert practice test. I ran into an odd error where the value of my staff_id dropdown does not seem to be passing correctly. I am running this script:

image
image1522×969 102 KB

and getting this error:

image
image1886×497 48.3 KB

It seems to be truncating the value to the first character, but I can’t figure out why. The data type in the database is varchar like the other strings:

image
image1383×1002 117 KB

What am I missing?

2

The varchar type has a length associated with it, so I'm guessing you have it defined as length 1.

2 Likes
3

Hi Daniel: have another look at the prompt for the staff_id field datatype, it is listed as an INT to correlate with the user source users table.

4

Welcome to the forum, Rob!

5

Thanks, I appreciate the help!