Code: Select all
SELECT vop_timezones_id FROM voyageports
WHERE voyageports_id='#recordID#'
But if I test with the real value as this:
Code: Select all
SELECT vop_timezones_id FROM voyageports
WHERE voyageports_id='153395cc60afe4'
John
Code: Select all
SELECT vop_timezones_id FROM voyageports
WHERE voyageports_id='#recordID#'
Code: Select all
SELECT vop_timezones_id FROM voyageports
WHERE voyageports_id='153395cc60afe4'
Code: Select all
SELECT vop_timezones_id FROM voyageports WHERE voyageports_id='#recordID#'
Code: Select all
SELECT vop_timezones_id FROM voyageports WHERE voyageports_id='-1'
Code: Select all
function defaultCurr(vsubform,curr) {
var sub_row = Array();
sub_row = nuSubformRowArray(vsubform);
for(var i = 0 ; i < sub_row.length; i++) {
var vfield=document.getElementById(sub_row[i]+'ii_currencies_id');
//if value is not set, put a default value
if (vfield.value=='') {
vfield.value = curr;
}
}
}