HI all,
I’m using a select function to get data from Mysql, but for some reason, there are 3 out of 36 fields that that asterisk can’t get from the table. it used to but not anymore.
here is my statement
MYSQL(Query resultid ${connid} SELECT \ county_code,\ holiday_message,\ emergency_message ,\ UNIX_TIMESTAMP(\term_begin_date),\ term_code_letter,\ term_completed,\ UNIX_TIMESTAMP(\jury_date),\ loc1_need,\ loc1_begin,\ loc1_end,\ UNIX_TIMESTAMP(\loc1_time),\ loc2_need,\ loc2_begin,\ loc2_end,\ UNIX_TIMESTAMP(\loc2_time),\ loc3_need,\ loc3_begin,\ loc3_end,\ UNIX_TIMESTAMP(\loc3_time),\ loc1_trial_finished,\ loc2_trial_finished,\ any_lucky,\ lucky_begin,\ lucky_end,\ any_released,\ released_begin,\ released_end,\ record_owner,\ loc3_trial_finished,\ weather_previous_calltocheck,\ weather_courts_open,\ weather_courts_closed,\ weather_previous_open,\ open_if_transitstrike,\ open_during_transitstrike,\ current_holiday\ from oca_table);
here is my fetch
MYSQL(Fetch fetchid ${resultid} county_code holiday_message emergency_message term_begin_date term_code_letter term_completed jury_date loc1_need loc1_begin loc1_end loc1_time loc2_need loc2_begin loc2_end loc2_time loc3_need loc3_begin loc3_end loc3_time loc1_trial_finished loc2_trial_finished any_lucky lucky_begin lucky_end any_released released_begin released_end record_owner loc3_trial_finished weather_previous_calltocheck weather_courts_open weather_courts_closed weather_previous_open open_if_transitstrike open_during_transitstrike current_holiday)
and here is my output
– Executing NoOp(“SIP/5060-b7c4a950”, “41”) in new stack
– Executing NoOp(“SIP/5060-b7c4a950”, “0”) in new stack
– Executing NoOp(“SIP/5060-b7c4a950”, “0”) in new stack
– Executing NoOp(“SIP/5060-b7c4a950”, “1157083200”) in new stack
– Executing NoOp(“SIP/5060-b7c4a950”, “T”) in new stack
– Executing NoOp(“SIP/5060-b7c4a950”, “0”) in new stack
– Executing NoOp(“SIP/5060-b7c4a950”, “1157428800”) in new stack
– Executing NoOp(“SIP/5060-b7c4a950”, “1000”) in new stack
– Executing NoOp(“SIP/5060-b7c4a950”, “1501”) in new stack
– Executing NoOp(“SIP/5060-b7c4a950”, “1159878600”) in new stack
– Executing NoOp(“SIP/5060-b7c4a950”, “1”) in new stack
– Executing NoOp(“SIP/5060-b7c4a950”, “1502”) in new stack
– Executing NoOp(“SIP/5060-b7c4a950”, “2997”) in new stack
– Executing NoOp(“SIP/5060-b7c4a950”, “1159878600”) in new stack
– Executing NoOp(“SIP/5060-b7c4a950”, “1”) in new stack
– Executing NoOp(“SIP/5060-b7c4a950”, “2998”) in new stack
– Executing NoOp(“SIP/5060-b7c4a950”, “3009”) in new stack
– Executing NoOp(“SIP/5060-b7c4a950”, “0”) in new stack
– Executing NoOp(“SIP/5060-b7c4a950”, “0”) in new stack
– Executing NoOp(“SIP/5060-b7c4a950”, “1”) in new stack
– Executing NoOp(“SIP/5060-b7c4a950”, “3010”) in new stack
– Executing NoOp(“SIP/5060-b7c4a950”, “3999”) in new stack
– Executing NoOp(“SIP/5060-b7c4a950”, “0”) in new stack
– Executing NoOp(“SIP/5060-b7c4a950”, “0”) in new stack
– Executing NoOp(“SIP/5060-b7c4a950”, “0”) in new stack
– Executing NoOp(“SIP/5060-b7c4a950”, “john smith”) in new stack
– Executing NoOp(“SIP/5060-b7c4a950”, “0”) in new stack
– Executing NoOp(“SIP/5060-b7c4a950”, “0”) in new stack
– Executing NoOp(“SIP/5060-b7c4a950”, “0”) in new stack
– Executing NoOp(“SIP/5060-b7c4a950”, “0”) in new stack
– Executing NoOp(“SIP/5060-b7c4a950”, “0”) in new stack
– Executing NoOp(“SIP/5060-b7c4a950”, “0”) in new stack
– Executing NoOp(“SIP/5060-b7c4a950”, “01”) in new stack
– Executing NoOp(“SIP/5060-b7c4a950”, “”) in new stack
– Executing NoOp(“SIP/5060-b7c4a950”, “”) in new stack
– Executing NoOp(“SIP/5060-b7c4a950”, “”) in new stack
Notice the last 3 fields are not populated, loc3_need, loc3_time and loc3_trial_finished are being populated, and i made sure in the table that they have values.
any Help would be appriciated.
thanks in advance