Hi All,
I’ve got an unusual one here that is a head banger (for me anyway). I have an array stored in a VARCHAR field (UsersCats) in a users table. The array contains Primary Key IDs for another DB table - WorkCats.
I have a repeat that uses Server Connect to list the WorkCats table as the Expression, then a show/hide to only show the rows that match the Primary Key in the users UserCats field.
It seems to display correctly, however, giving it a closer look its adding another 2 rows to the query.
Heres a view of what Im seeing:
You can see from the blue bits that the following have been added, yet they don’t exist in the UsersCats array. Its added a ‘2’ and a ‘4’.
Ive tried a lot of stuff, including converting UserCats to a string, a number etc but it all shows the same result.
Example:
I’m now stumped.!
Anyone have any ideas…?
Last updated: