Select Object loses the hash cookie #RECORD_ID# after nuRefreshSelectObject('objectID') Topic is solved

[gerese]

Hi,
I tried the following situation: at the first "Select", if I use the nuRefreshSelectObject('objectID') command in the developer console of the browser .... the "Select" which has a mySQL command behind it no longer displays anything.
What am I doing wrong?

Code: Select all

SELECT DISTINCT
text020 AS table2_id,
text020
FROM table2
WHERE table2_table1_id = '#RECORD_ID#'

error refreshselectobject.gif

09-29-2022_191850_nuBuilder_backup.sql.gzip

[kev1n]

I think the sql needs to be altered to since #RECORD_ID# (upper case) will contain the procedure's name.

Code: Select all

SELECT DISTINCT
text020 AS table2_id,
text020
FROM table2
WHERE (table2_table1_id = '#RECORD_ID#' OR table2_table1_id = '#record_id#')

Read more about this topic:
viewtopic.php?p=24221

[gerese]

Thanks , work great!