nuBuilder Forum

Posted: **Thu Sep 29, 2022 7:10 pm**

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

Posted: **Fri Sep 30, 2022 4:26 am**

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

Posted: **Fri Sep 30, 2022 8:31 pm**

Thanks

, work great!

nuBuilder Forum

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

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

Re: Select Object loses the hash cookie #RECORD_ID# after nuRefreshSelectObject('objectID')

Re: Select Object loses the hash cookie #RECORD_ID# after nuRefreshSelectObject('objectID')